public static class SqlHelper {//<summary>///EF SQL statements return dataTable//</summary> <param name= "db" >ef data context </param>///<param name= "SQL" > statements </param>///&L T;param name= "Parameters" > Parameters </param>//<returns></returns> public static DataTable Sq Lqueryfordatatatable (This Database db, String sql, sqlparameter[] parameters=null) {mysqlconnection con n = 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; } }
MySQL in EF returns to the DataTable public class library