Entity Framework. Delete all rows in table

by

For those that are googling this and ended up here like me, this is how you currently do it in EF5 and EF6:

context.Database.ExecuteSqlCommand("TRUNCATE TABLE [TableName]");

Assuming context is a System.Data.Entity.DbContext

Edit:

Currently in net6.0 (dotnet 6 core) you can do the following:

context.Database.ExecuteSqlRaw("TRUNCATE TABLE [TableName]");

Or use the Async overload:

await context.Database.ExecuteSqlRawAsync("TRUNCATE TABLE [TableName]");

These are extension methods coming from Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions

If you’re having issues with foreign keys (in MySql), you might have to do the following (Doing the SET FOREIGN_KEY_CHECKS = 0; part in a separate call does not seem to work for me)

context.Database.ExecuteSqlRaw("SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE [TableName];");

So if you want to truncate your entire database (Possibly for unittesting reasons) – you can do the following:

var tableNames = context.Model.GetEntityTypes()
    .Select(t => t.GetTableName())
    .Distinct()
    .ToList();

foreach (var tableName in tableNames)
{
    context.Database.ExecuteSqlRaw($"SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `{tableName}`;");
}

More Related Contents:

  1. LINQ to SQL multiple tables left outer join
  2. Join and Include in Entity Framework
  3. Calling a SQL User-defined function in a LINQ query
  4. Entering keys manually with Entity Framework
  5. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  6. Bulk-deleting in LINQ to Entities
  7. Entity framework left join
  8. Value cannot be null. Parameter name: source
  9. Filter/Search using Multiple Fields – ASP.NET MVC
  10. Could not find an implementation of the query pattern
  11. The result of a query cannot be enumerated more than once
  12. Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator
  13. How to convert an expression tree to a partial SQL query?
  14. Generate EF orderby expression by string [duplicate]
  15. Entity-framework code is slow when using Include() many times
  16. The operation cannot be completed because the DbContext has been disposed using MVC 4
  17. Retrieve an object from entityframework without ONE field
  18. How does LINQ expression syntax work with Include() for eager loading
  19. Export Model to DataTable
  20. Anonymous type result from sql query execution entity framework
  21. Dynamic query with OR conditions in Entity Framework
  22. Simulating Cross Context Joins–LINQ/C#
  23. Only primitive types or enumeration types are supported in this context
  24. Max return value if empty query
  25. Check if list contains item from other list in EntityFramework
  26. How to do an “in” query in entity framework?
  27. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  28. How to wrap Entity Framework to intercept the LINQ expression just before execution?
  29. Linq union usage?
  30. Querying data using Entity Framework from dynamically created table

Leave a Comment