Question - What are two types of transactions supported by ADO.net?
Answer -
Two types of Transaction supported by ADO.net
- Local Transaction: A local transaction is based on a single data source. It will be handled directly by the database. For Example, We import ‘System.Data.SQL client’ namespace, if we need to perform data transaction using Sqlserver. Similarly, we import ‘System.Data.Oracle client’ namespace, if we are using Oracle database.
- Distributed Transaction: If the user needs to perform a transaction across multiple data Servers like SQL Server, Oracle, etc he can use a distributed transaction.