public static void Connected() { MyCon _con = new MyCon(); _con.ConnectDB(); using (MySql.Data.MySqlClient.MySqlConnection connect = _con.db.connect()) { connect.Open(); string sql = String.Format("{0}", "SELECT * FROM Customer"); List <UserModel> tested = connect.Query <UserModel>(sql).ToList(); connect.Close(); Console.WriteLine(tested); } }
public static void Connected2() { MyCon _con = new MyCon(); MySql.Data.MySqlClient.MySqlDataReader rdr = null; _con.ConnectDB(); using (MySql.Data.MySqlClient.MySqlConnection connect = _con.db.connect()){ connect.Open(); string sql = String.Format("{0}", "SELECT * FROM Customer"); MySql.Data.MySqlClient.MySqlCommand cmd = connect.CreateCommand(); cmd.CommandText = sql; cmd.CommandTimeout = 600; rdr = cmd.ExecuteReader(); if (rdr.HasRows) { Console.WriteLine(rdr); } connect.Close(); } }