Renamed column hidden by another column
I have a LINQ to SQL connection which is not providing access to all the columns in a table with certain characteristics, and I don't know how to get around this.
I think it's easiest to explain with an example:
If you make a table called 'Test', which contains columns: 'Test' and 'Contents', the LINQ to SQL connection only exposes a 'Contents' member, which actually refers to the 'Test' column.
This question shows the same problem:
http://stackoverflow.com/questions/1192813/linq-modelling-column-name-same-as-table-name
Is there any way to get at the hidden 'Contents' member, or change the name used for column names which match their table name?
I think it's easiest to explain with an example:
If you make a table called 'Test', which contains columns: 'Test' and 'Contents', the LINQ to SQL connection only exposes a 'Contents' member, which actually refers to the 'Test' column.
This question shows the same problem:
http://stackoverflow.com/questions/1192813/linq-modelling-column-name-same-as-table-name
Is there any way to get at the hidden 'Contents' member, or change the name used for column names which match their table name?
Comments
www.linqpad.net/beta.aspx
If another column exists called 'Content', LINQPad will use the identifier 'Value' instead.