title: C# Oracle transactions
body: <p>How can I insert a record a their childs in a single transaction?</p>
  
  <p>For example I have a class named <code>Requisition</code> (<code>IdRequisition</code>, <code>Description</code>, <code>RegisterDate</code>) and <code>RequisitionRequirement</code> (<code>IdRequisitionRequirement</code>, <code>IdRequisition</code>, <code>DocumentName</code>, <code>DeliveryDate</code>, <code>LimitDate</code>) and I need to insert the <code>Requisition</code> and get the <code>IdRequisition</code> by outparameter and then insert the list of <code>RequisitionRequirements</code> that must being related with the <code>Requisition</code>, in a single transaction and ensure that if one of the <code>RequisitionRequirement</code> fails the insert, do a rollback.</p>
  
  <p>I don't know what is the correct form to do it, if handling transactions from c# with <code>cmd.Connection.BeginTransaction()</code> or another way.</p>
  
  <p>I was using Linq to entities and we had no problem with that, but the current app uses Oracle and stored procedures and I'am new in this context.</p>
  
  <p>Sorry for my english but I'm learning too !</p>