title: Sql Transaction - SQL Server or C#?
body: <p>Am I right in saying that from a performance perspective, sql transactions are far better within a stored procedure than code?</p>
  
  <p>At the moment I use most of my transactions in stored procs but sometimes I use code for more complex routines - which obviously I keep to a minimum as much as possible.</p>
  
  <p>It's just that there was a complex routine that required too many "variables" that writing the sql transaction in c# was far easier than using SQL Server. It's a fine line between code readability and performance.</p>
  
  <p>Any ideas?</p>