title: Multiple insert into SQL Server 2008 via Ado.Net 3.5 and C#
body: <p>I have a collection of data. I need to insert these records into SQL Server 2008. I also need to maintain transaction, so that if one insert fails, I need to rollback all the changes done. </p>
  
  <p>Can some one suggest a best way to do this? I use .Net 3.5. </p>