title: How to use the Procedure with User Defined Table Type in Entity Framework
body: <p>How to use a procedure with a user-defined table type in Entity Framework?</p>
  
  <p>I have the EF with database-first approach, when I add a procedure with a user-defined table type columns it will not reflected in the EF will update the model.</p>
  
  <p>And how can I pass the user-defined table parameter in EF with procedure?</p>
  
  <p>My procedure :</p>
  
  <p>Sample_Proce_Sp
  (
  @TableTest @UserDefinedTable Readonly
  )
  AS
  BEgin
  Select * from @TableTest 
  END</p>
  
  <p>In EF I have updated the model, will adding the stored procedure it shows the error like</p>
  
  <pre><code>The model was generated with warnings or errors.
  Please see the Error List for more details. These issues must be fixed before running your application.
  Loading metadata from the database took 00:00:03.1330217.
  Generating the model took 00:00:01.9251464.
  Successfully registered the assembly 'System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' in the Web.Config file. 
  </code></pre>