Querying EF model with "name", "id" or "date" columns fails
Posted: Sat 20 Sep 2008 09:20
I don't know if it is still the case with the latest release because I changed the column names of my table to continue working, but if you have a table with either "date", "id" or "name" as a column name, the entity framework model will be properly generated but the queries formed by the provider will omit to quote the column names and will cause an sql exception. There are certainly many other reserved names that will cause the same exception when not quoted.
select name from user.table => select "name" from user.table
If it could be fixed if it's not fixed yet...
select name from user.table => select "name" from user.table
If it could be fixed if it's not fixed yet...