如何将表参数传递到EF Core中的SQL Server存储过程？

// 步骤1：创建自定义数据类型
CREATE TYPE dbo.MyTableType AS TABLE
(
    Id INT,
    Name VARCHAR(50)
);

// 步骤2：定义模型类
public class MyTableType
{
    public int Id { get; set; }
    public string Name { get; set; }
}

// 步骤3：配置存储过程映射
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.HasDbFunction(() =>
    {
        var function = new SqlFunctionExpression("dbo.MyStoredProcedure",
            typeof(void),
            new[]
            {
                new SqlParameterExpression
                {
                    Name = "@myTable",
                    TypeMapping = new TableTypeMapping("dbo.MyTableType", typeof(MyTableType))
                }
            });

        return function;
    });
}

// 步骤4：调用存储过程并传递表参数
var myTable = new DataTable();
myTable.Columns.Add("Id", typeof(int));
myTable.Columns.Add("Name", typeof(string));

myTable.Rows.Add(1, "John");
myTable.Rows.Add(2, "Jane");

var parameter = new SqlParameter("@myTable", SqlDbType.Structured)
{
    TypeName = "dbo.MyTableType",
    Value = myTable
};

var result = dbContext.Database.ExecuteSqlRaw("EXEC dbo.MyStoredProcedure @myTable", parameter);