title: Best way to insert multiple rows into SQL Server 2008 database from .NET 4.0 app
body: <p>I have a scenario where I get back a list of items and I need to insert each item into a database, with one item > one row mapping.</p>
  
  <p>Initially, I thought about using a stored procedure that would insert a single item, and looping over a list, calling the stored procedure for each element. But I wonder if there are more elegant/optimal methods available. Especially leveraging SQL Server 2008 / .NET 4.0. </p>
  
  <p>Entity Framework could also come into play.</p>