How to handle System.Data.Entity.Validation.DbEntityValidationException

Question

I wrote this simple code to update my database column.

            using (HRMSEntities context = new HRMSEntities())
        {
            TBL_EMPLOYEE dataTicketInsert = new TBL_EMPLOYEE();
            dataTicketInsert = context.TBL_EMPLOYEE.Where(x => x.Id == inputEmployeeID).FirstOrDefault();
            dataTicketInsert.Ticket = ticketT;
            context.SaveChanges();
        }

Error Message: An exception of type 'System.Data.Entity.Validation.DbEntityValidationException' occurred in EntityFramework.dll but was not handled in user code Additional information: Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.

How can I resolve the problem?

"See 'EntityValidationErrors' property for more details." – Gert Arnold May 07 '15 at 20:42 — Gert Arnold, May 07 '15 at 20:42

score 1 · Accepted Answer · edited May 23 '17 at 12:08

Add the following code to your DbContext class, then in the validation error message, you will be able to see the details of the validation problem:

public override int SaveChanges()
{
        try
        {
            return base.SaveChanges();
        }
        catch (DbEntityValidationException ex)
        {
            var errorMessages = ex.EntityValidationErrors
                    .SelectMany(x => x.ValidationErrors)
                    .Select(x => x.ErrorMessage);

            var fullErrorMessage = string.Join("; ", errorMessages);

            var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);

            throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
        }
 }

Reference: https://stackoverflow.com/a/15820506/1845408

How to handle System.Data.Entity.Validation.DbEntityValidationException

1 Answers1