How can I delete (remove) single record from database table using entity framework in asp.net MVC Controller?
please note I want to delete row of selected Id from the database permanently(Not to make a column
IsActive
and set it as false
)
You can delete the single record using Entity framework by selecting that record first and then using .Remove ()
method
using (var Context= new DataBaseEntities()) { var itemToRemove = Context.Table_Name.Where(a => a.id == 1).FirstOrDefault(); //returns a single item. if (itemToRemove != null) { Context.Table_Name.Remove(itemToRemove); Context.SaveChanges(); } }
Or you can use context
.Entry(employer).State = EntityState.Deleted
using (var Context= new DataBaseEntities()) { var itemToRemove = Context.Table_Name.Where(a => a.id == 1).FirstOrDefault(); //returns a single item. if (itemToRemove != null) { Context.Entry(itemToRemove).State = EntityState.Deleted; Context.SaveChanges(); } }
Or
var ObjectTORemove= Context.Table_Name.Where(a => a.id == 1).FirstOrDefault(); //Delete it from memory entities.DeleteObject(ObjectTORemove); //Save to database entities.SaveChanges();
Subscribe to our weekly Newsletter & Keep getting latest article/questions in your inbox weekly