<p><strong>Problem:</strong></p>

      <p>Entity Framework support for User Defined Table Types as input parameters doesn&#39;t really exist.</p>

      <p><strong>Solution:</strong></p>

      <p><a href="https://www.nuget.org/packages/EntityFrameworkExtras/" target="_blank">Entity Framework Extras</a></p>

      <p><a href="https://github.com/Fodsuk/EntityFrameworkExtras#nuget" target="_blank">On Github with examples</a></p>

      <p><a href="http://stackoverflow.com/questions/20971331/how-to-use-the-procedure-with-user-defined-table-type-in-entity-framework/21120985#21120985" target="_blank">My Stackoverflow answer</a></p>

      <p><a href="http://stackoverflow.com/questions/8157345/entity-framework-stored-procedure-table-value-parameter" target="_blank">More Stackoverflow answers</a></p>

      <p><a href="https://dev6.blob.core.windows.net/blog-images/UserDefinedSqlParameters.zip">A Sample Visual Studio Project</a> Be sure to update the connection strings in App.Config!</p>

      <p>The Sql</p>
      <script type="syntaxhighlighter" class="brush: sql"><![CDATA[
USE [SuperMouseTrap]--start a new database with this name and run this script
GO
/****** Object:  UserDefinedTableType [dbo].[UdtGuidList]    Script Date: 7/22/2014 10:42:23 PM ******/
CREATE TYPE [dbo].[UdtGuidList] AS TABLE(
	[Guid] [uniqueidentifier] NULL
)
GO
/****** Object:  StoredProcedure [dbo].[MyUdtSproc]    Script Date: 7/22/2014 10:42:23 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[MyUdtSproc] 
    -- Add the parameters for the stored procedure here
    (@GuidList  UdtGuidList READONLY)
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT *
    from @GuidList
END
GO
]]></script>
      <p>The C#</p>
      <script type="syntaxhighlighter" class="brush: csharp"><![CDATA[
    [TestClass]
    public class DataTests
    {
        private string _efConn = ConfigurationManager.ConnectionStrings["Entities"].ConnectionString;
        private string _conn = ConfigurationManager.ConnectionStrings["Ado"].ConnectionString;

        [TestMethod]
        public void TestEfUdt()
        {
            var db = new Entities(_efConn);
            var sproc = new MyUdtSproc();
            sproc.UserDefined = new List<UserDefinedTable>()
                                {
                                    new UserDefinedTable(){Guid = Guid.NewGuid()},
                                    new UserDefinedTable(){Guid = Guid.NewGuid()},
                                    new UserDefinedTable(){Guid = Guid.NewGuid()},
                                    new UserDefinedTable(){Guid = Guid.NewGuid()}
                                };

            var result = db.Database.ExecuteStoredProcedure<Guid>(sproc);
        }

        [TestMethod]
        public void TestAdo()
        {
            var dt = new DataTable();

            dt.Columns.Add("Guid");

            for (int i = 0; i < 4; i++)
            {
                var row = dt.NewRow();
                row["Guid"] = Guid.NewGuid();
                dt.Rows.Add(row);
            }

            using (var conn = new SqlConnection(_conn))
            {
                using (var sproc = new SqlCommand("[dbo].[MyUdtSproc]", conn))
                {
                    var param = new SqlParameter("@GuidList", SqlDbType.Structured);
                    param.TypeName = "[dbo].[UdtGuidList]";
                    param.SqlValue = dt;
                    sproc.Parameters.Add(param);

                    if (conn.State != ConnectionState.Open) conn.Open();
                    var reader = sproc.ExecuteReader();
                }
            }
        }
    }
]]></script>

      <script type="syntaxhighlighter" class="brush: csharp"><![CDATA[
    [StoredProcedure("MyUdtSproc")]
    public class MyUdtSproc
    {
        [StoredProcedureParameter(SqlDbType.Udt, ParameterName = "GuidList")]
        public List<UserDefinedTable> UserDefined { get; set; }
    }
]]></script>

      <script type="syntaxhighlighter" class="brush: csharp"><![CDATA[
    [UserDefinedTableType("UdtGuidList")]
    public class UserDefinedTable
    {
        [UserDefinedTableTypeColumn(1)]
        public Guid Guid { get; set; }
    }
]]></script>

User Valued Parameters with Entity Framework

Allan Chadwick

Entity Framework and User Defined Parameters