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