我正在嘗試調(diào)用具有兩個參數(shù)的存儲過程：ID ：int數(shù)據(jù) ：table user defined type我想使用實(shí)體框架調(diào)用這個存儲過程。請幫我。
1 回答
蝴蝶刀刀
TA貢獻(xiàn)1801條經(jīng)驗(yàn) 獲得超8個贊
請檢查以下代碼：
public DataTable CallStoredProcedure(System.String procedureName, Dictionary<string, object> parameters)
{
var cmd = CreateStoredProcCallCommand(procedureName, true);
for (int i = 0; i < parameters.Count; i++)
{
var param = parameters.ElementAt(i);
if (param.Value.GetType() == typeof(DataTable))
AddTableValuedParameter(cmd, "@" + param.Key, 0, ParameterDirection.Input, param.Value);
else
AddParameter(cmd, "@" + param.Key, 2147483647, ParameterDirection.Input, param.Value);
}
var toReturn = new DataTable();
CreateAndSetupAdapter(cmd).Fill(toReturn);
return toReturn;
}
private DbCommand CreateStoredProcCallCommand(string storedProcedureToCall, bool openConnection)
{
var cmd = _factoryToUse.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = storedProcedureToCall;
return SetupCommand(cmd, openConnection);
}
private DbDataAdapter CreateAndSetupAdapter(DbCommand selectCommand)
{
var adapter = _factoryToUse.CreateDataAdapter();
adapter.SelectCommand = selectCommand;
return adapter;
}
private static void AddTableValuedParameter(DbCommand cmd, string parameterName, int length, ParameterDirection direction, object value)
{
SqlParameter param = new SqlParameter();
param.ParameterName = parameterName;
param.SqlDbType = SqlDbType.Structured;
param.Size = length;
param.Value = value;
param.Direction = direction;
cmd.Parameters.Add(param);
}
private static void AddParameter(DbCommand cmd, string parameterName, int length, ParameterDirection direction, object value)
{
var dummyParam = new EntityParameter() { Value = value };
var parameter = cmd.CreateParameter();
parameter.ParameterName = parameterName;
parameter.Direction = direction;
parameter.Size = length;
parameter.Value = value;
parameter.DbType = dummyParam.DbType;
cmd.Parameters.Add(parameter);
}
- 1 回答
- 0 關(guān)注
- 169 瀏覽
添加回答
舉報
0/150
提交
取消