How to delete a single Record using Entity Framework?

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)

Asked by:- Sam

: 301 At:- 12/19/2017 12:54:11 PM

C# Entity-framework Delete a single record using EF sql-server

add comment to question

1 Answers

Answered by:- Vipin

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();
}
}

 var ObjectTORemove= Context.Table_Name.Where(a => a.id == 1).FirstOrDefault();

  //Delete it from memory
  entities.DeleteObject(ObjectTORemove);
  //Save to database
  entities.SaveChanges();