title: Rollback a stored procedure call from inside a transaction using LINQ-to-SQL?
body: <p>I have a C#.net winform program which runs with a SQL Server database.  I am using LINQ-to-SQL.  Is it possible to rollback the call to one or more stored procedures inside a transaction within my program using LINQ-to-SQL?  </p>
  
  <p>Initially I thought it would make sense to manage the transaction inside the stored procedure but if I need to rollback more than one stored procedure call as part of a single transaction it would need to be done in my C# program.</p>
  
  <p>Can someone point me to a code snippet on how to do this or provide some insight into an alternative?</p>