EF中的MySql返回 DataTable公用類庫

標籤：

public static class SqlHelper    {        /// <summary>        /// EF SQL 陳述式返回 dataTable        /// </summary>        /// <param name="db">ef資料內容</param>        /// <param name="sql">語句</param>        /// <param name="parameters">參數</param>        /// <returns></returns>        public static DataTable SqlQueryForDataTatable(this Database db, string sql, SqlParameter[] parameters=null)        {            MySqlConnection conn = new MySqlConnection();            conn.ConnectionString = db.Connection.ConnectionString;            if (conn.State != ConnectionState.Open)            {                conn.Open();            }            MySqlCommand cmd = new MySqlCommand();            cmd.Connection = conn;            cmd.CommandText = sql;            if (parameters!=null && parameters.Length > 0)            {                foreach (var item in parameters)                {                    cmd.Parameters.Add(item);                }            }            MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);            DataTable table = new DataTable();            adapter.Fill(table);            return table;        }    }

　　

EF中的MySql返回 DataTable公用類庫