Page 1 of 1
creating an ado.net entity data model - dotconnect for MySQL
Posted: Wed 15 Apr 2009 00:35
by mgaoulil
Hi, when I try to generate and ado.net entity data model (.edmx file) using dotconnect for mysql 5.0.26. I get an exception saying
Devart.data.MySql.MySqlException, with the error message: 'Unknown column 'Yes' in field list ...
this problem only happens when I try to use a Mysql database which is on different server (Linux debian)
Posted: Wed 15 Apr 2009 14:05
by AndreyR
Could you please specify the full version of the MySQL server you are using on Debian?
Posted: Wed 15 Apr 2009 22:55
by mgaoulil
Hi
MySQL server version is : 5.0.32-Debian_7etch1~bpo.1-log
Thanks
Posted: Thu 16 Apr 2009 13:29
by AndreyR
We are investigating the problem. It may take significant amount of time (two weeks or even more). I will let you know about the results of our investigation as soon as possible.
Posted: Thu 16 Apr 2009 23:34
by mgaoulil
Thank you for your reply.
I have worked out what caused this problem. I have an application that uses the same MySQL server and requires the sql_mode to be set to ‘MSSQL’. If I set this sql_mode to the default the wizard to generate ado.net entity data model (.edmx) runs fine.
My question now is there a work around this?
Thanks
Posted: Fri 17 Apr 2009 09:51
by AndreyR
Thank you for the additional information, it helped greatly.
The problem will be fixed in the nearest Release build of dotConnect for MySQL.