MVC5 Validation failed for one or more entities. See 'EntityValidationErrors' property for more details

Question

I can't seem to get update-database to populate my database using my Seed Method.

I was coding a MVC4 with EF application and is now in the process of upgrading it to MVC5 with EF. Previously in MVC4 I had to create a class called User.cs but in MVC5 with Identity we need our User class to derive from IdentityUser.

I'm using the exact same code as I did with the MVC4 configuration file and just changed :

var users = new List<User>

to

var users = new List<ApplicationUser>

and

new User{ FirstMi....

to

new ApplicationUser { FirstMi....

Error is on line 61 which is here

users.ForEach(s => context.Users.AddOrUpdate(p => p.FirstMidName, s)); context.SaveChanges()

PM> Update-Database 
Specify the '-Verbose' flag to view the SQL statements being applied to the target database.
No pending explicit migrations.
Running Seed method.
System.Data.Entity.Validation.DbEntityValidationException: Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.
   at System.Data.Entity.Internal.InternalContext.SaveChanges()
   at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
   at System.Data.Entity.DbContext.SaveChanges()
   at RecreationalServicesTicketingSystem.Migrations.Configuration.Seed(ApplicationDbContext context) in C:\Users\Jason\Documents\Visual Studio 2015\Projects\RecreationalServicesTicketingSystem\RecreationalServicesTicketingSystem\Migrations\Configuration.cs:line 62
   at System.Data.Entity.Migrations.DbMigrationsConfiguration`1.OnSeed(DbContext context)
   at System.Data.Entity.Migrations.DbMigrator.SeedDatabase()
   at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.SeedDatabase()
   at System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)
   at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)
   at System.Data.Entity.Migrations.DbMigrator.UpdateInternal(String targetMigration)
   at System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClassc.<Update>b__b()
   at System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
   at System.Data.Entity.Migrations.Infrastructure.MigratorBase.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
   at System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration)
   at System.Data.Entity.Migrations.Infrastructure.MigratorBase.Update(String targetMigration)
   at System.Data.Entity.Migrations.Design.ToolingFacade.UpdateRunner.Run()
   at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
   at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
   at System.Data.Entity.Migrations.Design.ToolingFacade.Run(BaseRunner runner)
   at System.Data.Entity.Migrations.Design.ToolingFacade.Update(String targetMigration, Boolean force)
   at System.Data.Entity.Migrations.UpdateDatabaseCommand.<>c__DisplayClass2.<.ctor>b__0()
   at System.Data.Entity.Migrations.MigrationsDomainCommand.Execute(Action command)
Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.

IdentityModel.cs(Snippet that contains my user class)

public class ApplicationUser
: IdentityUser<int, ApplicationUserLogin,
    ApplicationUserRole, ApplicationUserClaim>, IUser<int>
{
    public async Task<ClaimsIdentity>
        GenerateUserIdentityAsync(UserManager<ApplicationUser, int> manager)
    {
        var userIdentity = await manager
            .CreateIdentityAsync(this, DefaultAuthenticationTypes.ApplicationCookie);
        return userIdentity;
    }


    public bool IsAdministrator { get; set; }
    [StringLength(50, MinimumLength = 1)]

    public string LastName { get; set; }
    [StringLength(50, MinimumLength = 1, ErrorMessage = "First name cannot be longer than 50 characters.")]

    [Column("FirstName")]
    public string FirstMidName { get; set; }

    public string FullName
    {
        get { return FirstMidName + " " + LastName; }
    }
    [DataType(DataType.Date)]
    [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}", ApplyFormatInEditMode = true)]
    public DateTime EnrollmentDate { get; set; }
    public int DepartmentID { get; set; }
    [ForeignKey("DepartmentID")]
    public virtual Department Department { get; set; }
    public int DepotID { get; set; }
    [ForeignKey("DepotID")]
    public virtual Depot Depot { get; set; }
    public virtual ICollection<Ticket> Tickets { get; set; }
}

Configuration.cs(Seed Method)

internal sealed class Configuration : DbMigrationsConfiguration<RecreationalServicesTicketingSystem.Models.ApplicationDbContext>
{
    public Configuration()
    {
        AutomaticMigrationsEnabled = false;
    }

    protected override void Seed(ApplicationDbContext context)
    {
        var departments = new List<Department>
        {
            new Department { DepartmentID = 1, DepartmentName = "IT"},
            new Department { DepartmentID = 2, DepartmentName = "Menzit Admin" },
            new Department { DepartmentID = 3, DepartmentName = "Human Resources"},
            new Department { DepartmentID = 4, DepartmentName = "Mechanics" },
            new Department { DepartmentID = 5, DepartmentName = "Directors" },
            new Department { DepartmentID = 6, DepartmentName = "Operations"}

        };
        departments.ForEach(s => context.Departments.AddOrUpdate(p => p.DepartmentName, s));
        context.SaveChanges();


        var depots = new List<Depot>
        {
            new Depot { DepotID = 1, DepotName = "Porana"},
            new Depot { DepotID = 2, DepotName = "Far North"},
            new Depot { DepotID = 3, DepotName = "Horowhenua"},
            new Depot { DepotID = 4, DepotName = "Manawatu"},
            new Depot { DepotID = 5, DepotName = "Silverdale"},
            new Depot { DepotID = 6, DepotName = "Christchurch"},

        };
        depots.ForEach(s => context.Depots.AddOrUpdate(p => p.DepotName, s));
        context.SaveChanges();

            var users = new List<ApplicationUser>
    {
        new ApplicationUser { FirstMidName = "Jason",   LastName = "Wan",
            EnrollmentDate = DateTime.Parse("2016-02-18"), DepartmentID = 1, DepotID = 1,IsAdministrator = true},
        new ApplicationUser { FirstMidName = "Andy", LastName = "Domagas",
            EnrollmentDate = DateTime.Parse("2016-02-18"), DepartmentID = 1,DepotID = 1,IsAdministrator = true},
        new ApplicationUser { FirstMidName = "Denis",   LastName = "Djohar",
            EnrollmentDate = DateTime.Parse("2016-02-18"), DepartmentID = 1 ,DepotID = 1,IsAdministrator = true },
        new ApplicationUser { FirstMidName = "Christine",   LastName = "West",
            EnrollmentDate = DateTime.Parse("2016-02-18"), DepartmentID = 2, DepotID = 3,IsAdministrator = false},

    };

             users.ForEach(s => context.Users.AddOrUpdate(p => p.FirstMidName, s));
            context.SaveChanges(); <--ERROR HERE

            users.ForEach(s => context.Users.AddOrUpdate(p => p.LastName, s));
            context.SaveChanges();



        var categories = new List<Category>
        {
            new Category {CategoryID = 0001, CategoryName = "Desktop"},
            new Category {CategoryID = 0002, CategoryName = "Mobile"},
            new Category {CategoryID = 0003, CategoryName = "Menzits"},
            new Category {CategoryID = 0004, CategoryName = "XMPRO"},
            new Category {CategoryID = 0005, CategoryName = "Con-X"},
            new Category {CategoryID = 0006, CategoryName = "Promapp"},
            new Category {CategoryID = 0007, CategoryName = "QGIS"},
        };
        categories.ForEach(s => context.Categories.AddOrUpdate(p => p.CategoryName, s));
        context.SaveChanges();

        var tickets = new List<Ticket>
        {
            new Ticket {
                UserID = users.Single(s => s.LastName == "Wan").Id, //UserID
                CategoryID = categories.Single(c => c.CategoryName == "Con-X" ).CategoryID,
                Issue = ("Con-X Login Error"),
                Priority = Priority.High
            },
            new Ticket {
                UserID = users.Single(s => s.LastName == "Wan").Id, //UserID
                CategoryID = categories.Single(c => c.CategoryName == "Desktop" ).CategoryID,
                Issue = ("Can't remote access C0123"),
                Priority = Priority.Med
            },
        };


        foreach (Ticket e in tickets)
        {
            var ticketInDataBase = context.Tickets.Where(
                s =>
                    s.User.Id == e.UserID && //UserID
                    s.Category.CategoryID == e.CategoryID).SingleOrDefault();
            if (ticketInDataBase == null)
            {
                context.Tickets.Add(e);
            }
        }
        context.SaveChanges();

    }




}

Answer 1

Just sharing my case - Code first

I have a context.AddOrUpdate(entity) which asynchronously updates/adds the entity. This meant that I only received the error in the Package Manager Console window afterwards, and there is nothing I could do about it. The try-catch did not catch the exception because it occurred afterwards.

I simply added context.SaveChanges() right after the AddOrUpdate which immediately throws the exception and I was then able to check the EntityValidationErrors of the exception and figure out where the problem was. Sounds simple/obvious, but it really helped me.

Answer 2

as the error say's you must check for entity validation errors,

try
{
    db.Entity.Add(entity);
    db.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
    foreach (var validationErrors in dbEx.EntityValidationErrors)
    {
        foreach (var validationError in validationErrors.ValidationErrors)
        {
            System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
        }
    }
}

Answer 3

a simple solution would be to add this line to the watch window:

((System.Data.Entity.Validation.DbEntityValidationException)$exception).EntityValidationErrors

but my guess would be that the error comes from the ApplicationUser's UserName property, you need to give it a valu while adding a new user :)

i hope it helped.