entity framework delete record

Question

I am trying to delete record from table store but I having problem of recognizing DeleteObject in my code. I have reference

using System.Linq;
using System.Data.Entity;
using System.Data.Objects;

but it still not working. I am using MVC 4 using Visual Studio 2012.

public void Delete()
{
    using (var db = new AppContext())
    {
        var query_D = (from b in db.Stores
                   where b.storeID == 1
                   select b).First();

        db.DeleteObject(query_D);
        db.SaveChanges();
    } 
}

thanks in advance

Answer 1

I realized that you're using the MVC 4 with VS2012, and by default the Entity Framework version is 5.

Now the way you delete is from EF4.

Here's the proper way to delete using the EF5

using (var db= new AppContext(ConnectionStr))
{
    try
    {
        con.Configuration.AutoDetectChangesEnabled = false;
        var o = new Store { Id = 1 };
        db.Stores.Attach(o);
        db.Stores.Remove(o);
        db.SaveChanges();
    }
    catch (Exception ex)
    {
        throw new Exception(ex.InnerException.Message);
    }
    finally
    {
        con.Configuration.AutoDetectChangesEnabled = true;
    }
}

Answer 2

Just use

db.Entry(query_D).State = System.Data.EntityState.Deleted;