Entity Framework - printing EntityValidationErrors to log
You can try something like this
foreach (var failure in ex.EntityValidationErrors)
{
string validationErrors="";
foreach (var error in failure.ValidationErrors)
{
validationErrors+=error.PropertyName+" "+error.ErrorMessage;
}
}
Here are some extension methods:
/// <summary>
/// A DbEntityValidationException extension method that formates validation errors to string.
/// </summary>
public static string DbEntityValidationExceptionToString(this DbEntityValidationException e)
{
var validationErrors = e.DbEntityValidationResultToString();
var exceptionMessage = string.Format("{0}{1}Validation errors:{1}{2}", e, Environment.NewLine, validationErrors);
return exceptionMessage;
}
/// <summary>
/// A DbEntityValidationException extension method that aggregate database entity validation results to string.
/// </summary>
public static string DbEntityValidationResultToString(this DbEntityValidationException e)
{
return e.EntityValidationErrors
.Select(dbEntityValidationResult => dbEntityValidationResult.DbValidationErrorsToString(dbEntityValidationResult.ValidationErrors))
.Aggregate(string.Empty, (current, next) => string.Format("{0}{1}{2}", current, Environment.NewLine, next));
}
/// <summary>
/// A DbEntityValidationResult extension method that to strings database validation errors.
/// </summary>
public static string DbValidationErrorsToString(this DbEntityValidationResult dbEntityValidationResult, IEnumerable<DbValidationError> dbValidationErrors)
{
var entityName = string.Format("[{0}]", dbEntityValidationResult.Entry.Entity.GetType().Name);
const string indentation = "\t - ";
var aggregatedValidationErrorMessages = dbValidationErrors.Select(error => string.Format("[{0} - {1}]", error.PropertyName, error.ErrorMessage))
.Aggregate(string.Empty, (current, validationErrorMessage) => current + (Environment.NewLine + indentation + validationErrorMessage));
return string.Format("{0}{1}", entityName, aggregatedValidationErrorMessages);
}
Usecase 1:
catch(DbEntityValidationException e) {
Logger.WriteError(e.DbEntityValidationExceptionToString());
throw;
}
Should Output:
StackTrace
Validation errores:
[EntityName]
- [Property - ErrorMessage]
- [Property - ErrorMessage]
[EntityName2]
- [Property - ErrorMessage]
- [Property - ErrorMessage]
Usecase 2:
catch(DbEntityValidationException e) {
Logger.WriteError(e.DbEntityValidationResultToString());
throw;
}
Should Output:
[EntityName]
- [Property - ErrorMessage]
- [Property - ErrorMessage]
[EntityName2]
- [Property - ErrorMessage]
- [Property - ErrorMessage]
cleaner syntax:
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
Logger.WriteError("{0}{1}Validation errors:{1}{2}", ex, Environment.NewLine, ex.EntityValidationErrors.Select(e => string.Join(Environment.NewLine, e.ValidationErrors.Select(v => string.Format("{0} - {1}", v.PropertyName, v.ErrorMessage)))));
throw;
}