title: Entity Framework pass a complex type parameter to a stored procedure
body: <p>I have a stored procedure which is defined with custom input type because I need to send there whole grid. For example something like this:</p>
  
  <pre><code>CREATE TYPE members_table_type AS TABLE
  (
      mem_username VARCHAR(25),
      mem_firstname VARCHAR(25),
      mem_lastname VARCHAR(25)
  );
  
  CREATE STORED PROCEDURE insert_members
      @members members_table_type
  AS
  BEGIN
      INSERT INTO dbo.members 
      (mem_username, mem_firstname, mem_lastname)
      SELECT mem_username, mem_firstname, mem_lastname FROM @members;
  END
  </code></pre>
  
  <p>And I'm using Entity Framework and if I update my model from database, then this procedure does not have input parameter..</p>
  
  <p>Is there a way how to do it using Entity Framework?</p>
  
  <p>I found a working solution using ADO.NET but I don't want to mix technologies for database communication.</p>
  
  <p>Thanks</p>