I have a C# Application which makes use of SqlConnection and SqlCommand objects with a Transaction set by calling BeginTransaction.
Now what happens say if the application is in the middle of Executing the Command and then abnormally ends (power failure, whatever) so without calling Commit (or Rollback).
So the Connection obviously terminates, what happens to the Transaction? Does it auto rollback when a connection terminates?
Your speedy response is appreciated.