title: Error while passing table as a parameter to the stored procedure in Entity Frame Work
body: <p>Actual  I was working on stored procedure by passing a table as a parameter using EntityFrameworkExtras package</p>
  
  <p>below is the code <br/>
  Step 1: Created user defined type in SQL SERVER</p>
  
  <pre><code>                   CREATE TYPE [dbo].[UserDefineType] AS TABLE(
                     [ID] [int] NULL,
                     [Value] [int] NULL
                 )
  </code></pre>
  
  <p>Step 2: Created stored procedure and use above defined type in step 1 as parameter of stored procedure</p>
  
  <pre><code> SET ANSI_NULLS ON
   GO
    SET QUOTED_IDENTIFIER ON
  GO
    CREATE PROCEDURE [dbo].[TestStoredProcedure]
      (@name varchar(100)
      ,@description varchar(500)
      ,@udt UserDefineType READONLY
     )
  AS
    BEGIN
   INSERT INTO [dbo].[TestTable]
           (
              [ID] , [Value]
            )
            SELECT ID,Value          
             FROM @udt
      END
  </code></pre>
  
  <p>Step 3: Created class for User Defined Type</p>
  
  <pre><code>    /// &lt;summary&gt;
      /// Represents User Defined Type for database
      /// &lt;/summary&gt;
         [UserDefinedTableType("UserDefinedType")]
          public class UserDefinedType
        {
         [UserDefinedTableTypeColumn(1)]
         public int ID { get; set; }
         [UserDefinedTableTypeColumn(2)]
          public int Value { get; set; }
        }
  </code></pre>
  
  <p>Step 4: Created class for User Defined Type</p>
  
  <pre><code>         public class TestStoredProcedure    
           {
           [StoredProcedureParameter(SqlDbType.NVarChar, ParameterName="name")]
            public string Name { get; set; }
  
  
      [StoredProcedureParameter(SqlDbType.NVarChar,ParameterName="description")]
            public string Description { get; set; }    
  
         [StoredProcedureParameter(SqlDbType.Udt, ParameterName = "udt")]
             public List&lt;UserDefinedType&gt; UserDefinedType { get; set; }
           }
  </code></pre>
  
  <p>But while calling that procedure I am getting error like </p>
  
  <p>(Column, parameter, or variable @udt. : Cannot find data type UserDefinedType.) <br />
  <a href="https://i.stack.imgur.com/b3t96.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/b3t96.png" alt="enter image description here"></a></p>