Executing stored procedure with user defined table type parameter in entity framework using EntityFrameworkExtras

Entity framework does not support user defined type by default. So to support user defined type in entity framework we implement EntityFrameworkExtras package available on NuGet.
Below are step by step implementation for executing stored procedure with user defined table type parameter in entity framework using EntityFrameworkExtras
Step 1: Create user defined type in SQL SERVER
CREATE TYPE [dbo].[UserDefineType] AS TABLE(
[ID] [int] NULL,
[Value] [int] NULL
)
GO

Step 2: Create stored procedure and use above defined type in step 1 as parameter of stored procedure along with other parameter if needed.

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
—- Your logic
INSERT INTO [dbo].[TestTable]
(
[ID]
, [Value])
SELECT ID
, Value
FROM @udt
—- Your logic
END
Step 3: Add EntityFrameworkExtras package from Nuget in your project as per your version of entity framework.
Entity Framework 4 – https://www.nuget.org/packages/EntityFrameworkExtras/
Entity Framework 5 – https://www.nuget.org/packages/EntityFrameworkExtras.EF5/
Entity Framework 6 – https://www.nuget.org/packages/EntityFrameworkExtras.EF6/
3.1: Right click references in your project and select Manage NuGet package option from context menu
3.2: Search EntityFrameworkExtras package and select install.

Step 4: Create a class in your project that will represent user defined type created in step 1.
///

[UserDefinedTableType(“UserDefinedType”)]
public class UserDefinedType
{
[UserDefinedTableTypeColumn(1)]
public int ID { get; set; }
[UserDefinedTableTypeColumn(2)]
public int Value { get; set; }
}

Note: UserDefinedTableType(“UserDefinedType”) attribute take name of your user defined type in SQL Server.

Step 5: Create another class in your project that will represent stored procedure defined in step 2.
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace MyDemoApplication
{
///

[StoredProcedure(“TestStoredprocedure”)]
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 UserDefinedType { get; set; }
}
}
Note: Third property parameterName value must be same as defined in stored procedure

Step 6: Now finally execute stored procedure using dbcontext or ObjectContext.
DbContext context = new DbContext(“ConnectionString”);
var procedure = new TestStoredProcedure()
{
Name = “Ashish”,
Description = “Executing user defined table type in entity framework”,
UserDefinedType = new List()
{
new UserDefinedType() {ID = 1, Value = 16}
}
};
context.Database.ExecuteStoredProcedure(procedure);