Where is the ExecuteStoreCommand method in Entity

2019-03-22 15:31发布

问题:

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.

回答1:

Try this:

ctx.Database.ExecuteSqlCommand