title: How do I insert records into 2 SQL tables sharing a dependency when I don't commit until the end?
body: <p>I keep finding myself in this situtation:</p>
  
  <p>I have an ASP.NEt 2.0 app. I have to insert into 2 tables in SQL. There is a dependency between the tables. I insert a record the first using a transaction. Then I move onto the 2nd table. But, because the first isn't committed yet the second one throws a error. </p>