Entity Framework Code First AddOrUpdate method insert Duplicate values

by

Ok I was banging my face off the keyboard for an hour with this. If your table’s Id field is an Identity field then it won’t work so use a different one for identifierExpression. I used the Name property and also removed the Id field from the new Hall {...} initializer.

This tweak to the OPs code worked for me so I hope it helps someone: 

protected override void Seed(HallContext context)
{
    context.Halls.AddOrUpdate(
        h => h.Name,   // Use Name (or some other unique field) instead of Id
        new Hall
        {
            Name = "Hall 1"
        },
        new Hall
        {
            Name = "Hall 2"
        });

    context.SaveChanges();
}

More Related Contents:

  1. LINQ to Entities case sensitive comparison
  2. Entity Framework 4 – AddObject vs Attach
  3. Entity Framework/Linq EXpression converting from string to int
  4. Entity Framework/SQL2008 – How to Automatically Update LastModified fields for Entities?
  5. Entity Framework/Linq to SQL: Skip & Take
  6. Why re-initiate the DbContext when using the Entity Framework?
  7. Entity Framework – Invalid Column Name ‘*_ID”
  8. Exclude a field/property from the database with Entity Framework 4 & Code-First
  9. Internal .NET Framework Data Provider error 1025
  10. Entity Framework Code Only error: the model backing the context has changed since the database was created
  11. Entity Framework 4: How to find the primary key?
  12. Change db table name in EF4 (entity framework 4)
  13. Entity Framework Multiple Object Contexts
  14. The principal end of this association must be explicitly configured using either the relationship fluent API or data annotations
  15. Repository Pattern, POCO, and Business Entities
  16. Easiest way to compare arrays in C#
  17. Difference between ObservableCollection and BindingList
  18. XML serialization of interface property
  19. How do arrays in C# partially implement IList?
  20. String Concatenation using ‘+’ operator
  21. How to save a List on Settings.Default?
  22. Escape invalid XML characters in C#
  23. What is the fastest way to create a checksum for large files in C#
  24. DateTime to javascript date
  25. Should we always include a default constructor in the class?
  26. DDD Approach to Access External Information
  27. Initial capacity of collection types, e.g. Dictionary, List
  28. ASP.NET Web API and [Serializable] class
  29. trying to convert rgb from a .net Color to a string such as “red” or “blue”
  30. The component does not have a resource identified by the uri

Leave a Comment