Delete multiple rows with Entity Framework 5

Question

I tried this piece of code :

context.Database.ExecuteSqlCommand
("DELETE [MYSCHEMA].TABLE1 Where TABLE2.Id = 5");

But I get this exception : Cannot call methods on nvarchar.

Currently I use a loop but I'd like avoid this.

Thanks,

Asif Mushtaq · Accepted Answer · 2013-04-24 11:33:53Z

3

Try this

context.Database.ExecuteSqlCommand
     ("DELETE [MYSCHEMA].TABLE1 Where TABLE2_Id = 5");

answered Nov 5, 2012 at 11:22

Asif Mushtaq

13.1k3 gold badges36 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mcalex · Accepted Answer · 2012-11-05 11:33:20Z

1

Delete syntax is 'delete from TABLE where ...'

try context.Database.ExecuteSqlCommand("DELETE FROM [MYSCHEMA].TABLE1 Where Table2.Id = 5");

answered Nov 5, 2012 at 11:24

mcalex

6,7985 gold badges53 silver badges86 bronze badges