Entity Framework Core - Knowledge Base (KB)

DbUpdateException: Which field is causing "String or binary data would be truncated"

I am getting a ...DbUpdateException... with message ...String or binary data would be truncated...I understand that one of the fields in the entity won't fit the length of the column in the database. And that I could go down and check them manually....Wha...

Entity Framework: one or more of the foreign-key properties is non-nullable

I have a very complex database model. My program computes some ...data+db entries... and ...modifies+generates new entries... to update+insert in the database....When I use database context to insert the entries, everything works. But when I try to save c...

Best practice to handling exceptions of ef core in asp.net project?

i use ef core 2.1 in asp.net core mvc project.i also use repository pattern to access database....ISSUE:...i want show some exceptions(e.g foreign key constraint fails) with ajax to user and other exceptions svae in log file of my program.by applying D...

How to use SqlException in .NET CORE?

In my old project with .Net Framework use from... using System.Data.SqlClient; ...and ...if (ex.GetType() == typeof(SqlException)) { return ErrorMessage((SqlException)ex); } ...and now in .NET CORE Does not know Code above...How to use ...typeof(SqlEx...

Entity Framework Core DbContext.SaveChanges throws System.InvalidCastException: Unable to cast object of type System.Boolean to type System.Int16

I am using .net core 2.2 with entity framework using MySql.Data.EntityFramework.Core. Bump into this exception when I do the following:...DbContext.MyDbSet.Add(new MyClass()); DbContext.SaveChanges(); ...Exception:...System.InvalidCastException: Unable to...