SqlConnection conn = new SqlConnection(connString);
SqlTransaction trans = conn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand(“MyWriteProc”,conn, trans);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(….
…
// additional transactioned writes to database
trans.Commit();
}
catch
{
trans.Rollback();
}
When you use ADO.NET manual transactions, you can set the desired isolation
level on the BeginTransacion method as shown in the following code fragment.
SqlConnection conn = new SqlConnection(connString);
SqlTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
