/// <summary>
/// Returns the first record from the query result.
/// </summary>
/// <returns>depending on T, single value or all fields values from the first record</returns>
public T Single <T>()
{
var res = new SingleDataReaderResult <T>(Read <T>);
using (var selectCmd = GetSelectCmd()) {
DataHelper.ExecuteReader(selectCmd, CommandBehavior.SingleRow, DataReaderRecordOffset, 1, res);
}
return(res.Result);
}
/// <summary>
/// Returns dictionary with first record values.
/// </summary>
/// <returns>dictionary with field values or null if query returns zero records.</returns>
public Dictionary <string, object> ToDictionary()
{
var res = new SingleDataReaderResult <Dictionary <string, object> >(ReadDictionary);
using (var selectCmd = GetSelectCmd()) {
DataHelper.ExecuteReader(selectCmd, CommandBehavior.SingleRow, DataReaderRecordOffset, 1, res);
}
return(res.Result);
}
/// <summary>
/// Returns all query results as <see cref="RecordSet"/>.
/// </summary>
public RecordSet ToRecordSet()
{
var res = new RecordSetDataReaderResult();
using (var selectCmd = GetSelectCmd()) {
DataHelper.ExecuteReader(selectCmd, CommandBehavior.Default, DataReaderRecordOffset, RecordCount, res);
}
return(res.Result);
}
/// <summary>
/// Returns a list with all query results.
/// </summary>
/// <returns>list with query results</returns>
public List <T> ToList <T>()
{
var res = new ListDataReaderResult <T>(Read <T>);
using (var selectCmd = GetSelectCmd()) {
DataHelper.ExecuteReader(selectCmd, CommandBehavior.Default, DataReaderRecordOffset, RecordCount, res);
}
return(res.Result);
}
/// <summary>
/// Returns the first record from the query result.
/// </summary>
/// <returns>depending on T, single value or all fields values from the first record</returns>
public T Single <T>()
{
T result = default(T);
using (var selectCmd = GetSelectCmd()) {
DataHelper.ExecuteReader(selectCmd, CommandBehavior.SingleRow, DataReaderRecordOffset, 1,
(rdr) => {
result = Read <T>(rdr);
});
}
return(result);
}
/// <summary>
/// Returns a list with all query results.
/// </summary>
/// <returns>list with query results</returns>
public List <T> ToList <T>()
{
var result = new List <T>();
using (var selectCmd = GetSelectCmd()) {
DataHelper.ExecuteReader(selectCmd, CommandBehavior.Default, DataReaderRecordOffset, RecordCount,
(rdr) => {
result.Add(Read <T>(rdr));
});
}
return(result);
}
/// <summary>
/// Returns dictionary with first record values.
/// </summary>
/// <returns>dictionary with field values or null if query returns zero records.</returns>
public Dictionary <string, object> ToDictionary()
{
Dictionary <string, object> result = null;
using (var selectCmd = GetSelectCmd()) {
DataHelper.ExecuteReader(selectCmd, CommandBehavior.SingleRow, DataReaderRecordOffset, 1,
(rdr) => {
result = ReadDictionary(rdr);
});
}
return(result);
}
