Entity framework insert fails

Question

Using EF6 + EF extensions for bulk deletion.

In the code I'm doing 2 things: First, clean all related entities, and second add new related entities. Just to avoid checking for similarity.

This main objects class:

[Table("distrule")]
public class Distrule: CommonEntity
{
    //other properties
    public virtual ICollection<Distrule_content> DistruleContent { get; set; }
}

[Table("distrule_content")]
public class Distrule_content
{
    [Key,Column(Order=0)]
    public int distrule_id { get; set; }
    [Key, Column(Order = 1)]
    public string IDEC { get; set; }

    [ForeignKey("distrule_id")]
    public virtual Distrule Distrule { get; set; }
    [ForeignKey("IDEC")]
    public virtual Content Content { get; set; }
}

Here is deletion-1 code:

Db.Distrule_contents.Where(x=> x.distrule_id == DistruleId).Delete();
Db.SaveChanges();

This is deletion-2 code:

List<Distrule_content> dcs = Distrule.DistruleContent.ToList();
dcs.Select(x => { Db.Entry(x).State = System.Data.Entity.EntityState.Deleted; return x; }).ToList();
Db.SaveChanges();

And after some manipulations add new entries:

//dc has type of List<Distrule_content> and contain new collection.
Db.Distrule_contents.AddRange(dc);
Db.SaveChanges();

So when I use deletion-1 to make it faster (in some cases there are up to 10K entries to delete) I got this error:

System.InvalidOperationException: The changes to the database were committed successfully, but an error occurred while updating the object context. The ObjectContext might be in an inconsistent state. Inner exception message: Saving or accepting changes failed because more than one entity of type 'IDS.DAL.Entities.Distrule_content' have the same primary key value. Ensure that explicitly set primary key values are unique. Ensure that database-generated primary keys are configured correctly in the database and in the Entity Framework model. Use the Entity Designer for Database First/Model First configuration. Use the 'HasDatabaseGeneratedOption" fluent API or 'DatabaseGeneratedAttribute'

When I use deletion-2 everything is OK, just longer.

All operations with db context works in transaction scope like this:

new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted, Timeout = TransactionManager.MaximumTimeout });

Db context looks like this:

public class DBWrapper : DbContext
{
    public DBWrapper()
        : base("Name=DefaultConnection")
    {

        var adapter = (IObjectContextAdapter)this;
        var objectContext = adapter.ObjectContext;
        objectContext.CommandTimeout = 30; // value in seconds
        // set this for faster delete/insert operations
        // reduce wait time from minute or two to 10-15 seconds
        this.Configuration.AutoDetectChangesEnabled = false;
        this.Configuration.ValidateOnSaveEnabled = false;
    }
    // dbsets...
}

how to avoid this exception, since I want to use this extension for EF?

Answer 1

The Delete method is an immediate operation.

When you call it, you don't need to call after SaveChanges and therefore, you will not get this error.

---

It's currently unclear which library you are using (You are saying "EF extensions for bulk deletion." in the question but have tagged initially "entity-framework-extended".

Disclaimer: I'm the owner of all those products.

EF Extended is no longer supported since 2014,

It is recommended to move to:

• Entity Framework Plus (Free and Open Source)
• Entity Framework Extensions (Commercial but the Delete from query feature is free)

Both of those products also have this feature.