ADO.NET Connection Transaction
Lets talk about, how in various scenarios we can use TransactionScope with various options for managing real life transactions using ADO.NET. One of the important aspect for any business application is Transaction management. Each and every large scale development framework provides a component for managing transactions. .NET Framework is a large development framework and it also provides its own transaction management component. From.NET Framework 2.0 onwards TransactionScope class is available in the System.Transactions assembly. This class provides a transactional framework with the help of which any .NET developer can write transactional code without having much knowledge. To resolve transactional issues like deadlocks, timeouts, etc., you must know each and every concept directly/indirectly related to a transaction. There is no alternative. So the concepts of a transaction and its related components need to be clear. In a database transaction we can say, a series of MDL ope...