C# Sql Server 数据库 传递 表值参数

CREATE TYPE [dbo].[QuestionList] AS TABLE(
    [QuestionGroupCode] [nvarchar](26) NULL,
    [StudentCode] [nvarchar](50) NULL,
    [MajorQuestionID] [int] NULL,
    [MinorQuestionID] [int] NULL
)

CREATE PROCEDURE [dbo].[spIsQuestionValid]
    @Question AS QuestionList READONLY
AS
BEGIN
　　...
END

var dt = new DataTable();
dt.Columns.Add("QuestionGroupCode", typeof(string));
dt.Columns.Add("StudentCode", typeof(string));
dt.Columns.Add("MajorQuestionID", typeof(int));
dt.Columns.Add("MinorQuestionID", typeof(int));
var p = new SqlParameter("@Question", SqlDbType.Structured);
p.Value = dt;
p.TypeName = "QuestionList";