Hi All,

In 7.0 mappings, I had table names marked as such : [Table_Name], this allowed me to use reserved keywords as table names, eg. [User] (which I dont think is uncommon).

With 8.4 I have had to remove the square brakets and am getting the expected SqlException: Incorrect syntax near the keyword 'User'.

Is there anything else I can use in 8.4 (apart from []) to mark a literal as a table name.

Thanks

My Error, 7.0 Allowed the use of [] on both table names and column names.

8.4 still allows it on table names. But not on column names. Luckily I dont have any conflicting column names.

Thanks

Guido

Use back-ticks for your table and column names that are protected SQL keywords. So, table="`User`" or column="`From`".

I ran into this problem today, I have a table called "Group".

Using table="[Group]" in the mapping file seems to work.

As baggins said, you should use back-ticks as they are "localized" depending on the database you use ([] aren't).