On Aug 21, 4:34*pm, "G.S." <gstoy...@gmail.comwrote:
Is there a way to use transactions from within C# code without using
MSDTC (client-and-server environment where the SQL server is behind a
firewall)?
Thank you
I guess I'll reply myself :)
If the target database is SQL 2005 and certain conditions are met, the
TransactionScope will stay "light-weight" and will not be promoted to
a full-blown MSDTC transaction.
From reading this up quickly it looks the condition is to only create
the DB connection once and pass it around throughout the body of the
transaction.
Would somebody comment if there's a way to explicitely request a LWT
since I know I only hit ONE SQL Server 2005.
Thanks