Ado.Net - Connection.EnlistTransaction

Suppose I have a method and I now want to use this method to participate in an existing Transaction:



private static void Insert( string orderId, string cnnStr )
{
...
SqlConnection oCnn = new SqlConnection( cnnStr );
oCnn.Open();
SqlCommand oCmd = new SqlCommand( "usp_Insert", oCnn );
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.Parameters.AddWithValue( "@orderId", orderId );
oCmd.ExecuteNonQuery();
}Since this method will be part of an existing trans, can I do something like?:



private static void Insert( string orderId, string cnnStr )
{
...
SqlConnection oCnn = new SqlConnection( cnnStr );
oCnn.EnlistTransaction( System.Transactions.Transaction.Current );
oCnn.Open();
SqlCommand oCmd = new SqlCommand( "usp_Insert", oCnn );
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.Parameters.AddWithValue( "@orderId", orderId );
oCmd.ExecuteNonQuery();
}Is that all, or should I find a way to commit the trans?

»»» Ken.Awamura