/// <summary>
/// Returns the value in the given column converted to <see cref="Nullable{DateTime}"/>
/// </summary>
/// <param name="record">The data record</param>
/// <param name="name">The name of the column</param>
/// <returns>The value in the given column converted to <see cref="Nullable{DateTime}"/> </returns>
/// <remarks>
/// If the value in the column is <see cref="DBNull"/>, <c>null</c> is returned. Otherwise the value is
/// converted to a <see cref="DateTime"/> if possible.
/// </remarks>
public static DateTime?GetNullableDateTime(this IDbDataRecord record, string name)
{
if (record.IsDBNull(name))
{
return(null);
}
return(record.GetDateTime(name));
}
/// <summary>
/// Returns the value in the given column converted to <see cref="Nullable{DateTime}"/>.
/// </summary>
/// <param name="record">The data record.</param>
/// <param name="index">The zero-based column ordinal.</param>
/// <returns>The value in the given column converted to <see cref="Nullable{DateTime}"/>.</returns>
/// <remarks>
/// If the value in the column is <see cref="DBNull"/>, <c>null</c> is returned. Otherwise the value is
/// converted to a <see cref="DateTime"/> if possible.
/// </remarks>
public static DateTime?GetNullableDateTime(this IDbDataRecord record, int index)
{
if (record.IsDBNull(index))
{
return(null);
}
return(record.GetDateTime(index));
}
