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.