The object cannot be deleted because it was not found in the ObjectStateManager

C#asp.netEntity Framework-4

C# Problem Overview


I am getting this error "The object cannot be deleted because it was not found in the ObjectStateManager."

My code is:

    protected MyEntities sqlEntities;

    public virtual void Delete(TEntity entity)
    {
        System.Type t = typeof(TEntity);
        sqlEntities.DeleteObject(entity);
        sqlEntities.SaveChanges();
    }

C# Solutions


Solution 1 - C#

It means that entity is not attached (it was not loaded by the same context instance). Try this:

protected MyEntities sqlEntities;

public virtual void Delete(TEntity entity)
{
    sqlEntities.Attach(entity);
    sqlEntities.DeleteObject(entity);
    sqlEntities.SaveChanges();
}

Solution 2 - C#

Just a small clarification on the answer by Ladislav Mrnka (which should be the accepted answer).

If like me, you've got code in a format like this:

using (var context = new MyDataContext())
{
    context.MyTableEntity.Remove(EntytyToRemove);
    var nrOfObjectsChanged = context.SaveChanges();
}

..then this what you want to do:

using (var context = new MyDataContext())
{
    // Note: Attatch to the entity:
    context.MyTableEntity.Attach(EntityToRemove);

    context.MyTableEntity.Remove(EntityToRemove);
    var nrOfObjectsChanged = context.SaveChanges();
}

Perhaps this seems obvious, but it was not clear to me initially that it is necessary to specify the entity to attatch to, and not just the context.

Solution 3 - C#

Just to propergate on Kjartans explanation:

I had:

public Project DeleteProject(int id)
    {
        using (var context = new Context())
        {
            var p = GetProject(id);
            context.Projects.Remove(p);
            context.SaveChanges();
            return p;
        }
    }

The problem is that I used my own method (GetProject()) to get the entity (hence using another context to load the entity):

public Project GetProject(int id)
    {
        using (var context = new Context())
        {
            var project = context.Projects
                .Include(p => p.Reports.Select(q => q.Issues.Select(r => r.Profession)))
                .Include(p => p.Reports.Select(q => q.Issues.Select(r => r.Room)))
                .SingleOrDefault(x => x.Id == id);
            return project;      
        }
    }

One solution could be to attach the loaded entity as Kjartan states, another could be mine solution, to load the entity within the same context:

public Project DeleteProject(int id)
    {
        using (var context = new Context())
        {
            var p = context.Projects.SingleOrDefault(x => x.Id == id);
            if (p == null)
                return p;

            context.Projects.Remove(p);
            context.SaveChanges();
            return p;
        }
    }

Solution 4 - C#

You can write this code:

var x=yourquery.FirstOrDefault(); 

sqlEntities.DeleteObject(x);
sqlEntities.SaveChanges();

Solution 5 - C#

I know this question is quite old but none of the above worked for me since i was deleting registers from more than one class/service and each of of them was instantiating it's own database connection context.

What i did to solve it was to send the first created context to the rest of the classes/services that where going to access the database.

For example, my serviceA was going to delete some of it's registers and call serviceB and serviceC to do the same with their registers.

I would then delete my registers on serviceA and pass as a parameter the context created on the serviceA to serviceB and serviceC.

Solution 6 - C#

In case none of the above worked, you may try this solution:

context.Entry(yourObject).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();

Solution 7 - C#

You should be sure that your object is exist in the list you are trying to remove from , you should put the following condition

>>if(context.entity.contains(your object))

>>remove it.

if you have a complicated condition for equality you should override equal method in entity class to put your condition for equality , to get the right way for an extension method "entity.contains"

Solution 8 - C#

Make sure the model passing into Remove(Entity) is exactly same as the database record.

Some times its possible to pass the model with out some fields like Id or Date. keep those into @html.Hiddenfor if you posting as form.

Best way is to pass the ID and get the entity using Find(Id) method and pass that to Remove(Entity)

Hope this helps someone.

Solution 9 - C#

I got this problem and solve it. Just copy below code:

sqlEntities.Attach(entity);
sqlEntities.Remove(entity);
sqlEntities.SaveChanges();

Solution 10 - C#

In my case there was one context , but I got entity with 'AsNoTracking' option

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionSamiView Question on Stackoverflow
Solution 1 - C#Ladislav MrnkaView Answer on Stackoverflow
Solution 2 - C#KjartanView Answer on Stackoverflow
Solution 3 - C#esbenrView Answer on Stackoverflow
Solution 4 - C#mehdiView Answer on Stackoverflow
Solution 5 - C#ArielView Answer on Stackoverflow
Solution 6 - C#Ala' AlnajjarView Answer on Stackoverflow
Solution 7 - C#Mohammad Ahmad AbdullahView Answer on Stackoverflow
Solution 8 - C#Dheeraj PalagiriView Answer on Stackoverflow
Solution 9 - C#vahid sabetView Answer on Stackoverflow
Solution 10 - C#vborutenkoView Answer on Stackoverflow