title: What’s the best way to bulk database inserts from c#?
body: <p>How do I/what’s the best way to do bulk database inserts?</p>
  
  <p>In C#, I am iterating over a collection and calling an insert stored procedure for each item in the collection.</p>
  
  <p>How do I send all the data in one database call?</p>
  
  <p>E.g. say I have a person list (<code>List&lt;Person&gt;</code>) containing 10 items. I am currently calling the InsertPerson stored proc 10 times. I would like to reduce this to 1 call.</p>
  
  <p>I am using MS SQL Server 2005.</p>