public static T GetValue <T>(this SqlDataReaderLRAP me, string columnName, T defaultIfNull) { if (!me.HasRows) { return(defaultIfNull); } return(me[columnName] == DBNull.Value ? defaultIfNull : (T)me[columnName]); }
public static T GetEnum <T>(this SqlDataReaderLRAP me, object defaultValue, string columnName) where T : struct, IConvertible { int value = Convert.ToInt32(me[columnName]); if (!Enum.IsDefined(typeof(T), value)) { return((T)defaultValue); } return((T)(object)value); }
public static T GetEnum <T>(this SqlDataReaderLRAP me, object defaultValue, int no) where T : struct, IConvertible { int value = me.GetInt32(no); if (!Enum.IsDefined(typeof(T), value)) { return((T)defaultValue); } return((T)(object)value); }
public static T ReadValue <T>(this SqlDataReaderLRAP reader, int ordinal, T defaultValueIfNull) { object value = reader[ordinal]; if (!(value is DBNull)) { return((T)value); } else { return(defaultValueIfNull); } }
public static T ReadValue <T>(this SqlDataReaderLRAP reader, string columnName, T defaultValueIfNull) { object value = reader[columnName]; if (!(value is DBNull)) { return((T)value); } else { return(defaultValueIfNull); } }
public static string GetInt32SafeToString(this SqlDataReaderLRAP me, int no, string defaultIfNull = "") { return(me.IsDBNull(no) ? defaultIfNull : me.GetInt32(no).ToString()); }
public static string ReadXml(this SqlDataReaderLRAP reader, string columnName, string defaultValueIfNull = "") { return(ReadValue <string>(reader, columnName, defaultValueIfNull)); }
public static DateTime GetDateTimeSafeToDateTime(this SqlDataReaderLRAP me, int no) { return(me.IsDBNull(no) ? DateTime.MinValue : me.GetDateTime(no)); }
public static string GetDateTimeSafeToString(this SqlDataReaderLRAP me, int no, string defaultIfNull = "") { return(me.IsDBNull(no) ? defaultIfNull : me.GetDateTime(no).ToLongDateString() + " : " + me.GetDateTime(no).ToLongTimeString()); }
public static int?GetInt32Nullable(this SqlDataReaderLRAP me, int no) { return(me.IsDBNull(no) ? (int?)null : (int?)me.GetInt32(no)); }
public static int ReadInt(this SqlDataReaderLRAP reader, string columnName, int defaultValueIfNull = -1) { return(ReadValue <int>(reader, columnName, defaultValueIfNull)); }
public static short ReadShort(this SqlDataReaderLRAP reader, string columnName, short defaultValueIfNull = -1) { return(ReadValue <short>(reader, columnName, defaultValueIfNull)); }
public static byte ReadByte(this SqlDataReaderLRAP reader, string columnName, byte defaultValueIfNull = 0) { return(ReadValue(reader, columnName, defaultValueIfNull)); }
public static T ReadValue <T>(this SqlDataReaderLRAP reader, int ordinal) { return(ReadValue <T>(reader, ordinal, default(T))); }
public static T ReadValue <T>(this SqlDataReaderLRAP reader, string columnName) { return(ReadValue <T>(reader, columnName, default(T))); }
public static int GetInt32SafeToInt(this SqlDataReaderLRAP me, int no, int defaultIfNull = -1) { return(me.IsDBNull(no) ? defaultIfNull : me.GetInt32(no)); }
public static Decimal GetDecimal(this SqlDataReaderLRAP me, int no, Decimal defaultIfNull = -1) { return(me.IsDBNull(no) ? defaultIfNull : me.GetDecimal(no)); }
public static byte[] ReadImage(this SqlDataReaderLRAP reader, string columnName, byte[] defaultValueIfNull = null) { return(ReadValue <byte[]>(reader, columnName, defaultValueIfNull)); }
public static DateTime?GetDateTimeNullable(this SqlDataReaderLRAP me, int no) { return(me.IsDBNull(no) ? (DateTime?)null : (DateTime?)me.GetDateTime(no)); }
public static long ReadLong(this SqlDataReaderLRAP reader, string columnName, long defaultValueIfNull = -1) { return(ReadValue <long>(reader, columnName, defaultValueIfNull)); }
public static decimal ReadDecimal(this SqlDataReaderLRAP reader, string columnName, decimal defaultValueIfNull = -1) { return(ReadValue <decimal>(reader, columnName, defaultValueIfNull)); }
public static bool ReadBoolean(this SqlDataReaderLRAP reader, string columnName, bool defaultValueIfNull = false) { return(ReadValue <bool>(reader, columnName, defaultValueIfNull)); }
public static string GetDateTimeSafeToString(this SqlDataReaderLRAP me, int no) { return(me.IsDBNull(no) ? DateTime.MinValue.ToString() : me.GetDateTime(no).ToString()); }
public static DateTime ReadDateTime(this SqlDataReaderLRAP reader, string columnName) { return(ReadValue <DateTime>(reader, columnName, DateTime.MinValue)); }
public static T GetValue <T>(this SqlDataReaderLRAP me, string columnName) { return(me[columnName] == DBNull.Value ? default(T) : (T)me[columnName]); }
public static DateTime ReadDateTime(this SqlDataReaderLRAP reader, string columnName, DateTime defaultValueIfNull) { return(ReadValue <DateTime>(reader, columnName, defaultValueIfNull)); }
public static T GetValue <T>(this SqlDataReaderLRAP me, int columnNumber, T defaultIfNull) { return(me.IsDBNull(columnNumber) ? defaultIfNull : (T)me[columnNumber]); }
public static int?ReadIntNullable(this SqlDataReaderLRAP reader, string columnName, int?defaultValueIfNull = null) { return(ReadValue <int?>(reader, columnName, defaultValueIfNull)); }