some column name make insertion failing?

grace · Post by **grace** » Wed 15 Jun 2011 22:27

I encountered some db execution failed error when inserting record.
I found out one of th column which name was 'condition' made it fail.
but it's failidng just on inserting. selecting and updating is fine.

It seems to be reserved name in the database.
by the way, I'm using mysql.

is it expected behavior?

StanislavK · Post by **StanislavK** » Thu 16 Jun 2011 12:25

Thank you for the report, we have reproduced the issue. We will inform you when it is fixed.

Generally, a column name should be quoted if it coincides with a server keyword. As a workaround, you can manually quote the Source property of the corresponding entity member.

StanislavK · Post by **StanislavK** » Tue 12 Jul 2011 15:33

We have fixed this issue. The fix is available in the new 2.50.27 build of LinqConnect. The new build can be downloaded from
http://www.devart.com/linqconnect/download.html
(the trial and free versions) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/

For the information about other fixes and improvements available in LinqConnect 2.50.27, please refer to
http://www.devart.com/forums/viewtopic.php?t=21451