qakmak qakmak - 2 months ago 25
C# Question

Where is the ExecuteStoreCommand method in Entity Framework 5?

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

Try this:

ctx.Database.ExecuteSqlCommand