Using Entity Framework -Is there a way to pass a string of commands to be executed in a manner similar to a stored procedure?

Question

I want something that achieves a simmilar effect to passing the text of a stored proc to SQL Server and then executing it?

For example to set identity_insert and then insert a value

undefined · Accepted Answer · 2013-05-07 03:28:16Z

1

You mean something like this?

context.Database.ExecuteSqlCommand("INSERT INTO....");

This can take multiple commands if you wish.

answered May 7, 2013 at 3:28

undefined

34.4k23 gold badges136 silver badges203 bronze badges

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

2 Comments

Maybe. Can you execute multiple sql commands in sequence using that? i.e to set indentity_insert then to do the insert

@kirsteng i believe so yes