CODEWITHSUNDEEP
entity-frameworkentity-framework-6
Greg Gum
Greg Gum

Reputation: 37875

How to ExecuteSqlCommand in Entity Framework without it being contained in a transaction

I need to execute a stored procedure with Entity Framework.

Normally I call it like this:

this.Context.Database.ExecuteSqlCommand("EXEC edi_UploadTransmission");

However, this particular stored procedure includes accessing a linked server.

Since EF wraps ExecuteSqlCommand in a transaction, it is failing, as a linked server is not supported in a transaction (as far as I can tell).

Is there a way to execute this stored procedure with Entity Framework without it being in a transaction?

Upvotes: 11

Views: 8303

Answers (2)

Rami A.
Rami A.

Reputation: 10582

Pass TransactionalBehavior.DoNotEnsureTransaction as the first parameter to the ExecuteSqlCommand method.

For example,

this.Context.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, "EXEC edi_UploadTransmission");

Upvotes: 20

Jonathan Allen
Jonathan Allen

Reputation: 70277

My recommendation would be to simply not use EF for this part of your code. You can freely combine EF with straight ADO.NET code or with other ORMs such as Dapper or Chain.

https://github.com/docevaad/Chain/wiki/A-Chain-comparison-to-Dapper

Upvotes: 1

Related Questions