Entity Framework - An error occurred while updating the entries See the inner exception for details

Question

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

User · Answer

I was facing the same problem and non of the above solutions helped me  In my Web Api 2 project  I had actually updated my database and had placed a unique constraint on an SQL table column  That was actually causing the problem  Simply Checking the the duplicate column values before inserting helped me fix the problem

User · Answer

In my case   following steps resolved      There was a column value which was set to  Update  - replaced it with Edit  non sql keyword    There was a space in one of the column names  removed the extra space or trim

User · Answer

View the Inner Exception of the exception to get a more specific error message   One way to view the Inner Exception would be to catch the exception  and put a breakpoint on it  Then in the Locals window  select the Exception variable   InnerException   Message  And Or just write to console       catch  Exception e                Console WriteLine e InnerException Message

User · Answer

Turn the Pluralization On  The problem is that you model object are using singular name  Pupil  convention  while in your database you are using pluralized names Pupils with s   UPDATE  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    UPDATE 2  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

User · Answer

For the records I had this issue and was a stupid mistake on my end  My issue was data type mismatch  Data type in database table and C  classes should be same

User · Answer

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

User · Answer

My problem was that the Id of the table is not AUTO INCREMENT and I was trying to add range

User · Answer

I had this problem recently   This was happen  because the permissions of user database  check permissions of user database  maybe the user do not have permission to write on db

User · Answer

I faced the same error         An error occurred while updating the entries  See the inner exception   for details      Simply Delete and Recreate the     edmx file  Its worked for me  the error will gone

User · Answer

I had same problem about SaveChanges   in EF but in my case I forget to update my sql table then after I used migration my problem solved so maybe updating your tables will solve problem

[c#] Entity Framework - "An error occurred while updating the entries. See the inner exception for details"

Examples related to c#

Examples related to entity-framework

Examples related to ef-model-first