Where is the ExecuteStoreCommand method in Entity Framework 5?

Question

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.

Are you sure? http://msdn.microsoft.com/en-us/library/system.data.objects.objectcontext.executestorecommand.aspx — tomfanning, Dec 13 '12 at 09:58
@tomfanning, that depends if he is using ObjectContext or DbContext — Justin Harvey, Dec 13 '12 at 10:00
Correct. EF5/6 are DbContext (POCO) by default unless you cast them. — DFTR, Apr 15 '15 at 18:34

score 91 · Accepted Answer · answered Dec 13 '12 at 09:59

91

Try this:

ctx.Database.ExecuteSqlCommand

answered Dec 13 '12 at 09:59

Justin Harvey

1

This answer should be mark as answer...this is a perfect solution.1 vote up for you @Justin Harvey – Kashif Hanif Dec 11 '13 at 08:45
2

i am using : ctx.Database.ExecuteSqlCommand("SET IDENTITY_INSERT profile ON") But its not working... Unable to insert custom primary key. How to do that ? – Er Mayank Apr 16 '15 at 07:44

1 Answers1