title: How can I pass a list of object in a SQL Procedure with SQL Server 2008?
body: <p>How can I pass a list of object in a SQL Procedure with SQL Server 2008 ?</p>
  
  <p>I want to avoid this : </p>
  
  <pre><code>foreach (var item in itemList)
  {
     myContext.ExecuteStoreCommand("EXEC MyAtomicProc ... item ...);
  }
  </code></pre>
  
  <p>I want to do the <code>foreach</code> in a store procedure.</p>
  
  <p>How can I pass a c# list of object and execute this procedure in EF :</p>
  
  <pre><code>myContext.ExecuteStoreCommand("EXEC MyGlobalProc ... itemList ...);
  </code></pre>