title: How to maintain transaction handling executing two stored procedure from C# code
body: <p>I one method in my class Which executing two stored procedure and insert data into three tables. How to handle transaction in that case?</p>
  
  <p>For Example:</p>
  
  <pre><code>public class InsertClass
  {
     public void AddData()
     {
         try
         {
             Execute Sp1;
             Execute Sp2;
         }
         catch (Exception ex)
         {
             throw ex;
         }
     }
  }
  </code></pre>
  
  <p>Both SP are for insert.</p>