creating an ado.net entity data model - dotconnect for MySQL

mgaoulil · Post by **mgaoulil** » Wed 15 Apr 2009 00:35

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)

AndreyR · Post by **AndreyR** » Wed 15 Apr 2009 14:05

Could you please specify the full version of the MySQL server you are using on Debian?

mgaoulil · Post by **mgaoulil** » Wed 15 Apr 2009 22:55

Hi

MySQL server version is : 5.0.32-Debian_7etch1~bpo.1-log

Thanks

AndreyR · Post by **AndreyR** » Thu 16 Apr 2009 13:29

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.

mgaoulil · Post by **mgaoulil** » Thu 16 Apr 2009 23:34

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

AndreyR · Post by **AndreyR** » Fri 17 Apr 2009 09:51

Thank you for the additional information, it helped greatly.
The problem will be fixed in the nearest Release build of dotConnect for MySQL.