title: Passing parameters to stored procedure using EF6
body: <p>I use sql-server 2012 in my project.</p>
  
  <p>I have stored procedure, I fire and passing parameters to the stored procedure with help of entity framework 6 method called <code>ExecuteSqlCommand</code>.</p>
  
  <pre><code> _context.database.ExecuteSqlCommand("SP_GetRecords", here all params)
  </code></pre>
  
  <p>One of the parameters that I try to sent to stored procedure is list of integers.</p>
  
  <p>I was <a href="https://stackoverflow.com/questions/40206071/how-do-i-declare-array-of-integers-in-a-sql-server-stored-procedure">advised</a> to create table-valued parameters on sql-server and pass to it array or list.</p>
  
  <p>But don't know how to pass this list or array of integers using <code>ExecuteSqlCommand</code> method to table-valued parameter.</p>
  
  <p>Any idea how to pass list or array type inside <code>ExecuteSqlCommand</code>?</p>