So I have multiple SqlConnections that I want to all be used in one SqlTransaction. I know that I could use just one connection, but ultimately in each connection there is a good amount of newly declared and useless (after the connection is done) variables, and I need the program to stay as fast as possible.

I have each Connection in a using statement.

I am using the latest .NET and SQL Server 2008 R2.

Is it possible?

ALSO, I already viewed:

How to use a single SqlTransaction for multiple SqlConnections in .NET?

Nobody answered the question, the platforms are outdated.

Edit
Report