some column name make insertion failing?

some column name make insertion failing?

Postby 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?
grace
 
Posts: 7
Joined: Tue 31 May 2011 02:27

Postby 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
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby 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
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to LinqConnect (LINQ to SQL support)