NGWS SDK Documentation  

This is preliminary documentation and subject to change.
To comment on this topic, please send us email at ngwssdk@microsoft.com. Thanks!

Manual Transactions and ADO+

The ADO+ managed provider and the ADO+ SQL Server managed provider support manual transactions in the NGWS runtime.

ADO+ managed provider

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()
  //. . .
}

ADO+ SQL Server Managed Provider

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;}
}

See Also

Automatic Transactions and NGWS Classes