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);
}
