/// <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>); ExecuteReader(res, 1); 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); ExecuteReader(res, 1); 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 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); }