title: Pass a List<> of object as parameter to SQL stored proc
body: <p>I would like to pass a List&lt;> of object say <code>List&lt;Student&gt;</code> to the parameter of stored proc and have the data stored in corresponding fields in the database. How can I do this? I use SQL Server 2005. </p>
  
  <p>So if the database Table has fields StudentId,Name,Age and the object <code>List&lt;Student&gt;</code> has the same properties containing the data, then the data should go to the corresponding fields in Table.</p>
  
  <p>Please advice with code. Thanks in advance.</p>