Hi, Is it possible to use ADO.NET transactions (in C# code - not transactions within MSSQL stored procs)on shared hosting? SqlTransaction trans = conn.BeginTransaction(); conn.Commit(); conn.Rollback() Would the above code be valid? How should I manage transactions if this is not possible? Thank you
SqlTransactions CAN be used here. What you CAN'T use is the newer transaction stuff like the newer TransactionScope. That one requires using a DTC which isn't supported here - unless things have changed since last time I asked.
ok - how about transactions within SQL Server(from stored procedures) ? If not then I would have look to somewhere else.
I just ran a test with my account on SQL Server 2005. You can apparently use native SQL Server transactions (within stored procedures). Thank goodness for this - without transactions creativity is pretty much killed ....
