Entity Framework. Delete all rows in table?

Question

How I can quickly remove all rows in table using Entity Framework? I am currently using: var rows = from o in dataDb.Table select o; foreach (var row in rows) { dataDb.Table.Remove(row); } dataDb.SaveChanges(); However, it takes a long time to execute. Are there any alternatives?

Answer 1

If it's taking along time, it likely means your data size is fairly large. I would recommend using a truncate statement in this case.

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