Where is the ExecuteStoreCommand method in Entity Framework 5?

qakmak picture qakmak · Dec 13, 2012 · Viewed 15.8k times · Source

I'm using EF5 in VS2012, and I trying to delete all data of some table using ExecuteStoreCommand, something like this:

ctx.ExecuteStoreCommand("TRUNCATE TABLE [" + tableName + "]");

but the problem is EF is telling me, method ExecuteStoreCommand not found. I can't understand why?

Can you tell me why?, or give me a performant solution remove all data of the table.

Answer

Justin Harvey picture Justin Harvey · Dec 13, 2012

Try this:

ctx.Database.ExecuteSqlCommand