Reserved Words for Columns are not Escaped

adun9002 · Post by **adun9002** » Sun 14 Mar 2010 14:58

I have a TextResource table for localization. I chose the simplest names possible for my Columns. (RegionCode, Key, Value) The Key column name is not escaped such as `Key` when passed to MySql therefore the SQL is invalid. I found that I can modify the Property Source Name in the Entity Developer which is very nice but I hate the idea that I would have to remember this should I want to Blow out and repopulate the Schema. Can we make the Sql Builder automatically escape all entity names using the `ObjectName` syntax?

Is anyone else having this issue?

AndreyR · Post by **AndreyR** » Tue 16 Mar 2010 14:06

Thank you for the report, we have reproduced the problem.
I will let you know about the results of our investigation.

AndreyR · Post by **AndreyR** » Thu 04 Nov 2010 09:24

We have fixed the error. The fix will be included in the nearest build.