Ado .net entity data model with My Sql database [Solved]
-
Hi friends.. I used entity data model with Microsoft Sql database since 6 months. But today i use MySql database and generate model for that database. I got error when i insert a record in a table which have relationships with two other tables.This table have unique rows based on those two related tables.So this table don't have any primary key.. I got the following error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ......." The table in which i insert data have not any primary key..So is it the reason for that error?? Please reply..Please also provide some good links for MySql+EntityDataModel if anybody have..
modified on Saturday, October 31, 2009 7:44 AM
The table in which i insert data have not any primary key..that was the reason for that error..
modified on Saturday, October 31, 2009 7:56 AM