title: create transaction to stored procedures calls under c#
body: <p>I am using stored procedures in sql server.
  I have several stored procedures calls written in c#. I want to wrap them inside transaction:</p>
  
  <pre><code>//Begin Transaction here
  sp1Call();
  sp2Call();
  sp3Call();
  //Commit here
  //Rollback if failed
  </code></pre>
  
  <p>is there any way to do it?</p>
  
  <p>Update:
  I am using the enterprise library. example to sp1Call():</p>
  
  <pre><code>public static void sp1Call(string itemName)
      {
          DbCommand command = db.GetStoredProcCommand("dbo.sp1_insertItem");
          db.AddInParameter(command, "@item_name", DbType.String, itemName);
          db.ExecuteNonQuery(command);
      }
  </code></pre>