Entity Framework ?? ???? ??? ?? ????

Entity Framework ??? ??? ?? ????? ?? ????? ???? ?? ?? ???? ????. ??? ObjectContext ? ExecuteStoreQuery ???? ???? ?? ??? ??? ? ????.

? ???? ???? ?? ExecuteStoredProcedure ???? ????:

public IEnumerable<T> ExecuteStoredProcedure<T>(string procedureName, params object[] parameters)
{
    StringBuilder command = new StringBuilder();
    command.Append("EXEC ");
    command.Append(procedureName);
    command.Append(" ");

    // 為每個傳入的參數(shù)添加占位符
    for (int i = 0; i < parameters.Length; i++)
    {
        if (i > 0)
            command.Append(",");

        command.Append("{" + i + "}");
    }

    return this.context.ExecuteStoreQuery<T>(command.ToString(), parameters);
}

? ??? ???? ??? ?? ????? ??? ? "??? ?? ???? p6?? ??? ?? ??? ??? ???"? ?? ??? ??? ? ????. ? ??? ????? SqlDbType? Structured?? ???? SqlParameter.TypeName? ??????? ??? ?? ??(UDT) ???? ???? ???.

??? ??? ???? ???? ??? ??? ??? ??? ?? ??? ? ????.

??? ?? ?? ??

ObjectContext ???? ??? ?? ?? ???? ???? ? ????? ???? ? ????.

public static void ExecuteStoredProcedure(this ObjectContext context, string storedProcName, params object[] parameters)
{
    string command = "EXEC " + storedProcName + " @caseid, @userid, @warnings";

    context.ExecuteStoreCommand(command, parameters);
}

? ?? ???? ???? ??? ?? ????? ???? ?? ?? ????? ??? ? ????. ?? ?? ??? ????.

var entities = new NewBusinessEntities();

var dt = new DataTable();
dt.Columns.Add("WarningCode");
dt.Columns.Add("StatusID");
dt.Columns.Add("DecisionID");
dt.Columns.Add("Criticality");

dt.Rows.Add("EO01", 9, 4, 0);
dt.Rows.Add("EO00", 9, 4, 0);
dt.Rows.Add("EO02", 9, 4, 0);

var caseId = new SqlParameter("caseid", SqlDbType.Int);
caseId.Value = 1;

var userId = new SqlParameter("userid", SqlDbType.UniqueIdentifier);
userId.Value = Guid.Parse("846454D9-DE72-4EF4-ABE2-16EC3710EA0F");

var warnings = new SqlParameter("warnings", SqlDbType.Structured);
warnings.Value = dt;
warnings.TypeName = "dbo.udt_Warnings";

entities.ExecuteStoredProcedure("usp_RaiseWarnings_rs", userId, warnings, caseId);

????

? ?? ???? ??? ??? ?? ??? ??? ?? ?? ?? ??? ?????.

• ?? ???? ????? ???? ??? ?? ?? ???? ??? ????? ???? ???.
• UDT? ?? ?? ???? ???? ???? ???.

? ??? Entity Framework? ?? ????? ??? ?? ?? ??? ???? ??? ??????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!