如何设置ASP.NET SQL数据源以接受TVP

CREATE TYPE dbo.MyTableType AS TABLE (
    Id INT,
    Name NVARCHAR(50)
)

CREATE PROCEDURE usp_InsertData
    @MyTableParam dbo.MyTableType READONLY
AS
BEGIN
    INSERT INTO MyTable (Id, Name)
    SELECT Id, Name
    FROM @MyTableParam
END

DataTable table = new DataTable();
table.Columns.Add("Id", typeof(int));
table.Columns.Add("Name", typeof(string));

// 添加数据
table.Rows.Add(1, "John Doe");
table.Rows.Add(2, "Jane Doe");

using (SqlConnection connection = new SqlConnection(connectionString))
{
    using (SqlCommand command = new SqlCommand("usp_InsertData", connection))
    {
        command.CommandType = CommandType.StoredProcedure;
        SqlParameter parameter = command.Parameters.AddWithValue("@MyTableParam", table);
        parameter.SqlDbType = SqlDbType.Structured;
        parameter.TypeName = "dbo.MyTableType";

        connection.Open();
        command.ExecuteNonQuery();
    }
}