ADO+ Managed Provider. The ADO+ Managed Provider uses native OLEDB through COM Interop to enable data access.
The OLEDB provider supports both manual transactions and automatic trasnsactions. For automatic transactions the OLEDB provider automatically enlists in the transaction and obtains the transaction details from the Component Services Context.
public class System.Data.ADO.ADOConnection { //. . . public int BeginTransaction(); public void CommitTransaction(); public void RollbackTransaction() //. . . }
ADO+ SQL Server Managed Provider (TDS). This adapter talks direct TDS to SQL Server. It does not use OLEDB, ADO or ODBC. It is all managed code.
The SQL Managed Adapter uses Microsoft.ComServices ContextUtil.GetObjectObject InTransaction to determine if it should enlist the SQL Server associated with its Connection in the transaction. If so, it obtains the Transaction from the COM+ Services Context and enlists the SQL Server.
public class System.Data.SQL.SQLConnection { public int BeginTransaction(); public int BeginTransaction(String transactionName); public void CommitTransaction(); public void RollbackTransaction(); public void RollbackTransaction(String transactionName); public void SaveTransaction(String savePointName); int TransactionLevel {get;} }