Delete a single record from Entity Framework?

by

It’s not necessary to query the object first, you can attach it to the context by its id.
Like this:

var employer = new Employ { Id = 1 };
ctx.Employ.Attach(employer);
ctx.Employ.Remove(employer);
ctx.SaveChanges();

Alternatively, you can set the attached entry’s state to deleted :

var employer = new Employ { Id = 1 };
ctx.Entry(employer).State = EntityState.Deleted;
ctx.SaveChanges();

More Related Contents:

  1. summing values of a column based on id [closed]
  2. MSSQL Error ‘The underlying provider failed on Open’
  3. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  4. Getting data from stored procedure with Entity Framework
  5. Entity framework very slow to load for first time after every compilation
  6. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  7. How can I lock a table on read, using Entity Framework?
  8. Mapping composite keys using EF code first
  9. EF 6 – How to correctly perform parallel queries
  10. Entity-framework code is slow when using Include() many times
  11. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  12. Optimistic concurrency: IsConcurrencyToken and RowVersion
  13. Entity Framework 6 transaction rollback
  14. The LINQ expression could not be translated and will be evaluated locally
  15. Dynamic query with OR conditions in Entity Framework
  16. Entity Framework | Sequence contains more than one matching element
  17. Keyword Not Supported: Metadata
  18. Why is EF generating SQL queries with unnecessary null-checks?
  19. How to Specify Primary Key Name in EF-Code-First
  20. How to Identify the primary key duplication from a SQL Server 2008 error code?
  21. Should the order of LINQ query clauses affect Entity Framework performance?
  22. Watch for a table new records in sql database
  23. What is the purpose of self tracking entities?
  24. Entity Framework/Linq EXpression converting from string to int
  25. Using DateTime in a SqlParameter for Stored Procedure, format error
  26. How to convert an expression tree to a partial SQL query?
  27. Generate EF orderby expression by string [duplicate]
  28. How does the SQLite Entity Framework 6 provider handle Guids?
  29. Passing array to a SQL Server Stored Procedure
  30. How to set Identity Seed value in code-first?

Leave a Comment