返回EF中带有联邦数据库的数据集
本文关键字:联邦数据库 数据集 EF 返回 | 更新日期: 2023-09-27 18:08:42
我想用Azure联邦数据库在EF中执行一个存储过程。我想执行带有过滤的存储过程。
DataSet dataToReturn = null; DataSet dataToReturn = null;
using (var temp = new DataSet())
{
var useFederationCommandText = BuildUSEFederation(fedID);
using (var connection = new SqlConnection(ATCommon.DSN))
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = useFederationCommandText;
command.ExecuteNonQuery();
}
SqlParameter[] sqlparams = {
new SqlParameter("@USERID",userId),
new SqlParameter("@BASESTARTDATE",baseStartDate),
new SqlParameter("@BASEENDDATE",baseEndDate),
new SqlParameter("@CASETYPEID",caseType),
new SqlParameter("@GROUPTYPE",groupType)
};
using (var dataAdapter = new SqlDataAdapter())
{
using (var command = new SqlCommand("TrendUserGraphTest"))
{
foreach (var param in sqlparams)
{
command.Parameters.Add(param);
}
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
//command.CommandText = strSql;
dataAdapter.SelectCommand = command;
dataAdapter.Fill(temp);
}
}
}
dataToReturn = temp;
}