/// <summary> /// This is an internal API that supports the Entity Framework Core infrastructure and not subject to /// the same compatibility standards as public APIs. It may be changed or removed without notice in /// any release. You should only use it directly in your code with extreme caution and knowing that /// doing so can result in application failures when updating to a new Entity Framework Core release. /// </summary> public static T GetValueOrDefault <T>([NotNull] this DbDataRecord record, [NotNull] string name) { var idx = record.GetOrdinal(name); return(record.IsDBNull(idx) ? default : (T)record.GetValue(idx)); }
public static String GetTimeZoneAdjustedDateTimeString( DbDataRecord dataRecord, String fieldName, double timeZoneOffset, String formatPattern) { String result = String.Empty; log.Debug("GetTimeZoneAdjustedDateTimeString fieldname was " + fieldName); if ( (dataRecord != null) && (fieldName != null) ) { try { if (dataRecord.GetOrdinal(fieldName) > -1) { if (dataRecord[fieldName] != DBNull.Value) { result = Convert.ToDateTime(dataRecord[fieldName]).AddHours(timeZoneOffset).ToString(formatPattern); //if (CultureInfo.CurrentCulture.Name == "fa-IR") //{ // PersianDateHelper dc = new PersianDateHelper(); // result = dc.MtoSh(Convert.ToDateTime(result)); //} } } } catch (InvalidCastException) { } } return result; }
public static String GetTimeZoneAdjustedDateTimeString( DbDataRecord dataRecord, String fieldName, double timeZoneOffset) { String result = String.Empty; if ( (dataRecord != null) &&(fieldName != null) &&(dataRecord.GetOrdinal(fieldName) > -1) &&(dataRecord[fieldName] != DBNull.Value) ) { try { result = Convert.ToDateTime(dataRecord[fieldName]).AddHours(timeZoneOffset).ToString(); //if (CultureInfo.CurrentCulture.Name == "fa-IR") //{ // PersianDateHelper dc = new PersianDateHelper(); // result = dc.MtoSh(Convert.ToDateTime(result)); //} } catch (InvalidCastException){ } catch (ArgumentOutOfRangeException) { result = DateTime.MinValue.ToString(); } } return result; }