title: Pass Dictionary<string,int> to Stored Procedure T-SQL
body: <p>I have mvc application. In action I have <code>Dictionary&lt;string,int&gt;</code>. The <code>Key</code> is ID and <code>Value</code> is sortOrderNumber. I want to create stored procedure that will be get key(id) find this record in database and save <code>orderNumber</code> column by <code>value</code> from Dictionary. I want to call stored procedure once time and pass data to it, instead of calling many times for updating data.</p>
  
  <p>Have you any ideas?
  Thanks!</p>