The ADO+ managed provider and the ADO+ SQL Server managed provider support manual transactions in the NGWS runtime.
The ADO+ managed provider uses native OLE DB through COM Interoperability to enable data access. The following NGWS class exposes methods that you can use to manage manual transactions:
public class System.Data.ADO.ADOConnection { //. . . public int BeginTransaction(); public void CommitTransaction(); public void RollbackTransaction() //. . . }
This adapter uses the private protocol called tabular data stream (TDS) to communicate with SQL Server, instead of using OLE DB, ADO or ODBC. It is all managed code.
The following class exposes transaction-related methods:
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;} }