SQL 语句返回 dataTable



#region EF SQL 语句返回 dataTable
        /// <summary>
        /// EF SQL 语句返回 dataTable
        /// </summary>
        /// <param name="db"></param>
        /// <param name="sql"></param>
        /// <param name="parameters"></param>
        /// <returns></returns>
        public DataTable SqlQueryForDataTatable(string sql, SqlParameter[] parameters)
        {
            DataTable table = new DataTable();
            //创建连接字符串
            using (SqlConnection conn = new SqlConnection(commdb.Database.Connection.ConnectionString))
            {
                try
                {
                    if (conn.State != ConnectionState.Open)
                    {
                        conn.Open();
                    }
                    //创建执行命令
                    SqlCommand cmd = new SqlCommand();
                    cmd.Connection = conn;
                    cmd.CommandText = sql;
                    cmd.CommandType = CommandType.StoredProcedure;
                    //遍历参数
                    if (parameters.Length > 0)
                    {
                        foreach (var item in parameters)
                        {
                            cmd.Parameters.Add(item);
                        }
                    }

                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    adapter.Fill(table);
                }
                catch (Exception)
                {
                    table = new DataTable();
                }
                finally
                {
                    conn.Close();
                }
            }
            return table;
        }
        #endregion