public static MysqlDatas query(string query, Dictionary <string, object> parameters) { Mysql ins = Mysql.getInstance(); ins.mysqlConn.Open(); MySqlCommand cmd = ins.prepare(query, ins.mysqlConn, parameters); MySqlDataReader reader = cmd.ExecuteReader(); MysqlDatas list = ins.addToCollection(reader); ins.mysqlConn.Close(); return(list); }
public MysqlDatas addToCollection(MySqlDataReader reader) { MysqlDatas datas = new MysqlDatas(); List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); datas.hasRows = reader.HasRows; //string key = null; while (reader.Read()) { Dictionary <string, object> dict = new Dictionary <string, object>(); for (int i = 0; i < reader.FieldCount; i++) { if (!dict.Keys.Contains(reader.GetName(i))) { dict.Add(reader.GetName(i), reader.GetValue(i)); } } datas.datas.Add(dict); } return(datas); }