title: What happens when you commit a transaction after rollback?
body: <p>Let’s say I have a C# class that creates a transaction for the database and then calls a stored procedure. The stored procedure returns an <code>int = 1</code> if there’s an error. And let’s say that we update a table but then return 1 because an error happened somewhere in the SP.</p>
  
  <p>This then throws an exception in c#, which calls a method to rollback the transaction — but in the FINALLY block of the method, we commit the transaction.</p>
  
  <p>Since the transaction was rolled back, what happens when we then call commit?</p>