返回EF中带有联邦数据库的数据集

本文关键字:联邦数据库 数据集 EF 返回 | 更新日期: 2023-09-27 18:08:42

我想用Azure联邦数据库在EF中执行一个存储过程。我想执行带有过滤的存储过程。

返回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;
                }