DbEntityValidationException – How can I easily tell what caused the error?

by

The easiest solution is to override SaveChanges on your entities class. You can catch the DbEntityValidationException, unwrap the actual errors and create a new DbEntityValidationException with the improved message.

  1. Create a partial class next to your SomethingSomething.Context.cs file.
  2. Use the code at the bottom of this post.
  3. That’s it. Your implementation will automatically use the overriden SaveChanges without any refactor work.

Your exception message will now look like this:

System.Data.Entity.Validation.DbEntityValidationException: Validation
failed for one or more entities. See ‘EntityValidationErrors’ property
for more details. The validation errors are: The field PhoneNumber
must be a string or array type with a maximum length of ’12’; The
LastName field is required.

You can drop the overridden SaveChanges in any class that inherits from DbContext:

public partial class SomethingSomethingEntities
{
    public override int SaveChanges()
    {
        try
        {
            return base.SaveChanges();
        }
        catch (DbEntityValidationException ex)
        {
            // Retrieve the error messages as a list of strings.
            var errorMessages = ex.EntityValidationErrors
                    .SelectMany(x => x.ValidationErrors)
                    .Select(x => x.ErrorMessage);
    
            // Join the list to a single string.
            var fullErrorMessage = string.Join("; ", errorMessages);
    
            // Combine the original exception message with the new one.
            var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
    
            // Throw a new DbEntityValidationException with the improved exception message.
            throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
        }
    }
}

The DbEntityValidationException also contains the entities that caused the validation errors. So if you require even more information, you can change the above code to output information about these entities.

See also: http://devillers.nl/improving-dbentityvalidationexception/

More Related Contents:

  1. EF: Include with where clause [duplicate]
  2. Entering keys manually with Entity Framework
  3. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  4. The cast to value type ‘Int32’ failed because the materialized value is null
  5. LINQ To Entities does not recognize the method Last. Really?
  6. Entity framework left join
  7. Value cannot be null. Parameter name: source
  8. Recursive Hierarchy – Recursive Query using Linq
  9. Filter/Search using Multiple Fields – ASP.NET MVC
  10. Encrypt password in App.config
  11. The result of a query cannot be enumerated more than once
  12. How to do a Bulk Insert — Linq to Entities
  13. Entity Framework – Add Navigation Property Manually
  14. EF Data Context – Async/Await & Multithreading
  15. The operation cannot be completed because the DbContext has been disposed using MVC 4
  16. Error-Attempt by method ‘X.set_DbConnection(System.Data.Common.DbConnection)’ to access method ‘Y.get_Settings()’ failed
  17. ToArrayAsync() throws “The source IQueryable doesn’t implement IAsyncEnumerable”
  18. DbContext discard changes without disposing
  19. How to COUNT rows within EntityFramework without loading contents?
  20. Simulating Cross Context Joins–LINQ/C#
  21. Can you get the DbContext from a DbSet?
  22. Entity Framework | Sequence contains more than one matching element
  23. Max return value if empty query
  24. Working with SQL views in Entity Framework Core
  25. How to do an “in” query in entity framework?
  26. Entity Framework Code First: How can I create a One-to-Many AND a One-to-One relationship between two tables?
  27. big issue in converting string to datetime using linq-to-entities
  28. Register AspNetCore 2.1 Identity system with DbContext interface
  29. Why is EF returning a proxy class instead of the actual entity?
  30. System.Data.Entity.Core.EntityCommandExecutionException Occurred in MVC app Using EF

Leave a Comment