I have problem, I have just started learning EF Model First and Im staying in one point for some time. I got such error :
"An error occurred while updating the entries. See the inner exception for details"
I have created an easy model on diagram, generated the database and wrote easy code in C# to add just one row in the table but the error is showing up all the time.
I post screenshot with Diagram/Generated DLL/Simple Main/And error throwing
Link for bigger size : http://i.imgur.com/bKGc4wv.png
Pluralization On. The problem is that you model object are using singular name (
Pupil) convention, while in your database you are using pluralized names
This post shows how can you turn it on or off. Some relevant excerpt of that post:
To turn pluralization on and off
On the Tools menu, click Options.
In the Options dialog box, expand Database Tools. Note: Select Show all settings if the Database Tools node is not visible.
Click O/R Designer.
Set Pluralization of names to Enabled = False to set the O/R Designer so that it does not change class names.
Set Pluralization of names to Enabled = True to apply pluralization rules to the class names of objects added to the O/R Designer.
But note that, you should avoid pluralized names. You can read here how to do it (I'll cite it here, just in case the link gets broken).
(...) When you work with Entity Framework Code First approach, you are creating your database tables from your model classes. Usually Entity Framework will create tables with Pluralized names. that means if you have a model class called PhoneNumber, Entity framework will create a table for this class called â€œPhoneNumbersâ€œ. If you wish to avoid pluralized name and wants singular name like Customer , you can do it like this In your DBContext class, Override the â€œOnModelCreatingâ€ method like this (...)
(...) Having this Method Overriding will avoid creating tables with pluralized names. Now it will create a Table called â€œPhoneNumberâ€ , Not â€œPhoneNumbersâ€ (...)
It could be caused by a data conversion from .NET to SQL, for instance a datetime conversion error. For me it was a null reference to a datetime column.
Also, that is not an exact error message. You can see the exact error in watch at exception.InnerException.InnerException -> ResultView.