How to Delete all data from the table (Truncate) in Entity Framework ?

If you want to Truncate Data or delete all the data from the table in Entity Framework (.NET 4.5) , you can use the ExecuteSqlCommand defined in the DBContext.Database class .

How to Delete all data from the table(Truncate) in Entity Framework ?

Below is a sample source to demonstrate how to truncate table in Entity Framework.

dbContext.Database.ExecuteSqlCommand("TRUNCATE TABLE tablename");
If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.
Pin It

Leave a Reply

Your email address will not be published. Required fields are marked *