Re: Runtime Exception using LINQ to Entity Framework

[Eric Santonacci]

Hello,

Just for information, I have the same problem with connector 6.3.6, Visual Studio 2010 and .NET 4.0 nad server 5.5.5 64bit. A MySql syntax error in SubmitChanges() method while inserting new row.

I couldn't find out where does the problem come from so far but I discovered it using an EntityDataSource in web pages (error was: MySql.Data.MySqlClient.MySqlException: Every derived table must have its own alias ) and now in a class library. Always on the same table while others work properly.

concurrency mode is not set in any fields, however when I imported the model from the database, when a field is set to "NOT NULL", entity property set "entity key" to true.

I have to admit I don't know where to find a solution et consider returning to "old fashion" insert command without EF.

--
Eric



Edited 2 time(s). Last edit at 02/14/2011 06:35AM by Eric Santonacci.