FindBy and using a column name that is non-C# standard

[wonderbison]

Hi

 

I want to find a record in a table but there are column names that are prefixed __$. Its a SQL Server CDC thing.

 

So the following is invalid

 

Db.schema.table.FindBy(__$start_lsn: 22)

I have tried it as a variable and surrounded the name in brackets and a couple of other ways but not much luck

 

Help appreciated

 

Robin

[Mark Rendle]

Just use StartIsn, Simple.Data will resolve the internal database name from that.

Mark

[wonderbison]

 

 

Hi

 

Thanks for the info. Can I ask how does it do that please?

 

Thanks

[Mark Rendle]

It uses the database schema tables and finds objects (tables, columns, etc) which match only on alphanumeric characters.

[wonderbison]

Clever stuff!!

 

Thanks