Update Row if it Exists Else Insert Logic with Entity Framework [closed]

by

If you are working with attached object (object loaded from the same instance of the context) you can simply use:

if (context.ObjectStateManager.GetObjectStateEntry(myEntity).State == EntityState.Detached)
{
    context.MyEntities.AddObject(myEntity);
}

// Attached object tracks modifications automatically

context.SaveChanges();

If you can use any knowledge about the object’s key you can use something like this:

if (myEntity.Id != 0)
{
    context.MyEntities.Attach(myEntity);
    context.ObjectStateManager.ChangeObjectState(myEntity, EntityState.Modified);
}
else
{
    context.MyEntities.AddObject(myEntity);
}

context.SaveChanges();

If you can’t decide existance of the object by its Id you must execute lookup query:

var id = myEntity.Id;
if (context.MyEntities.Any(e => e.Id == id))
{
    context.MyEntities.Attach(myEntity);
    context.ObjectStateManager.ChangeObjectState(myEntity, EntityState.Modified);
}
else
{
    context.MyEntities.AddObject(myEntity);
}

context.SaveChanges();

More Related Contents:

  1. Using Transactions or SaveChanges(false) and AcceptAllChanges()?
  2. Add data annotations to a class generated by entity framework
  3. Insert/Update Many to Many Entity Framework . How do I do it?
  4. Circular reference detected exception while serializing object to JSON
  5. How to create a many-to-many mapping in Entity Framework?
  6. The type of one of the expressions in the join clause is incorrect in Entity Framework
  7. Entity Framework DateTime and UTC
  8. Linq to Entities, random order
  9. Can I reuse code for selecting a custom DTO object for a child property with EF Core?
  10. How to Bulk Update records in Entity Framework?
  11. Using DataAnnotations with Entity Framework
  12. Entity Framework – retrieve ID before ‘SaveChanges’ inside a transaction
  13. How to declare one to one relationship using Entity Framework 4 Code First (POCO)
  14. Understanding ForeignKey attribute in entity framework code first
  15. EF 6 – How to correctly perform parallel queries
  16. When should I create a new DbContext()
  17. EF migration for changing data type of columns
  18. EF 6 Parameter Sniffing
  19. The operation cannot be completed because the DbContext has been disposed error
  20. Entity Framework Queryable async
  21. Delete a single record from Entity Framework?
  22. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  23. Entity framework raw SQL Query
  24. C# Entity-Framework: How can I combine a .Find and .Include on a Model Object?
  25. How to Identify the primary key duplication from a SQL Server 2008 error code?
  26. Entity Framework 4.1: Unable to cast from DbQuery to ObjectQuery
  27. How to include() nested child entity in linq
  28. Oracle Entity Framework – Generate Entity From Tables in Different Schema
  29. Entity framework – get entity by name
  30. LINQ Query to Convert string to datetime

Leave a Comment