title: Fastest method for SQL Server inserts, updates, selects
body: <p>I use SPs and this isn't an SP vs code-behind "Build your SQL command" question. I'm looking for a high-throughput method for a backend app that handles many small transactions. I use SQLDataReader for most of the returns since forward only works in most cases for me.</p>
  
  <p>I've seen it done many ways, and used most of them myself.</p>
  
  <ol>
  <li><p>Methods that define and accept the stored procedure parameters as parameters themselves and build using cmd.Parameters.Add (with or without specifying the DB value type and/or length)</p></li>
  <li><p>Assembling your SP params and their values into an array or hashtable, then passing to a more abstract method that parses the collection and then runs cmd.Parameters.Add</p></li>
  <li><p>Classes that represent tables, initializing the class upon need, setting the public properties that represent the table fields, and calling methods like Save, Load, etc</p></li>
  </ol>
  
  <p>I'm sure there are others I've seen but can't think of at the moment as well. I'm open to all suggestions.</p>