/// <summary>
/// Returns the value in the given column converted to <see cref="Nullable{Decimal}"/>
/// </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{Decimal}"/> </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="Decimal"/> if possible.
/// </remarks>
public static decimal?GetNullableDecimal(this IDbDataRecord record, string name)
{
if (record.IsDBNull(name))
{
return(null);
}
return(record.GetDecimal(name));
}
/// <summary>
/// Returns the value in the given column converted to <see cref="Nullable{Decimal}"/>.
/// </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{Decimal}"/>.</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="Decimal"/> if possible.
/// </remarks>
public static decimal?GetNullableDecimal(this IDbDataRecord record, int index)
{
if (record.IsDBNull(index))
{
return(null);
}
return(record.GetDecimal(index));
}