/* * Catch DbEntityValidationException when db.SaveChanges() is called */ public static void DemoUpdate() { try { using (var db = new AppDbTemplateEntities()) { db.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); } }
public static List <EmployeeInformation> DbTest() { using (var db = new AppDbTemplateEntities()) { return(db.EmployeeInformations .Where(x => x.CurrentStatusCode.ToLower() != "t") .OrderBy(x => x.LastHireDate) .Take(10) .ToList()); } }