public CSGenericRecord RunSingleQuery(string sql, CSParameterCollection parameters) { CSGenericRecord rec = new CSGenericRecord(); using (new CSTransaction(DB)) { using (ICSDbReader reader = DB.CreateReader(sql, parameters)) { if (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { rec[reader.GetName(i)] = (reader[i] is DBNull) ? null : reader[i]; } return(rec); } } } return(null); }
public CSGenericRecordList RunQuery(string sql, CSParameterCollection parameters) { CSGenericRecordList list = new CSGenericRecordList(); using (new CSTransaction(DB)) { using (ICSDbReader reader = DB.CreateReader(sql, parameters)) { while (reader.Read()) { CSGenericRecord record = new CSGenericRecord(); for (int i = 0; i < reader.FieldCount; i++) { record[reader.GetName(i)] = (reader[i] is DBNull) ? null : reader[i]; } list.Add(record); } } } return(list); }