CODEWITHSUNDEEP
c#type-conversionnullable
Widor
Widor

Reputation: 13275

Can I cast from DBNull to a Nullable Bool in one line?

I have a database query which will either return NULL or a boolean (bit) value.

I wish to store this value in a variable of type Nullable<bool> in C#.

I can't seem to find an acceptable mix of explict casts and conversions that do this in a simple way without Exceptions being thrown.

Can it be done in one readable line?

EDIT: Code as requested

private Nullable<bool> IsRestricted;
...//data access
IsRestricted = (bool?)DataBinder.GetPropertyValue(dataObj, "IsRestricted");

or perhaps

IsRestricted = (bool?)(bool)DataBinder.GetPropertyValue(dataObj, "IsRestricted");

Upvotes: 19

Views: 18289

Answers (5)

JB&#39;s
JB&#39;s

Reputation: 626

You can just do the following

bool? myNullableBoolean = SqlConvert.ToType<bool?>(reader["myNullableBooleanColumn"]);

Upvotes: 0

Ilya Palkin
Ilya Palkin

Reputation: 15737

I use extension methods for this issue.

var isRestricted = dataRecord.GetNullableValue<bool>("IsRestricted");

There is code of GetNullableValue method:

    public static Nullable<TValue> GetNullableValue<TValue>(
        this IDataRecord record, 
        string name) where TValue : struct
    {
        return record.GetValue<TValue, Nullable<TValue>>(name);
    }

And there is also a simple code for GetValue method:

        private static TResult GetValue<TValue, TResult>(
        this IDataRecord record,
        string name)
    {
        var result = record[name];
        return !result.Equals(DBNull.Value) ? (TResult)result : default(TResult);
    }

Upvotes: 0

Lajos Arpad
Lajos Arpad

Reputation: 76436

 while (reader.Read()) {
    bool? IsRestricted = (reader.IsDBNull(reader.GetOrdinal("IsRestricted"))) ? (null) : ((bool)reader.GetOrdinal("IsRestricted")));
 }

Upvotes: 0

giammin
giammin

Reputation: 18958

assuming you have a datareader dr:

bool? tmp = Convert.IsDBNull(dr["dbnullValue"]) ? null: (bool?) dr["dbnullValue"];

---ADDED----

or maybe you can use the ?? if you don't have to check for DBNull but i'm not sure compiler will like this (i cannot test it now)

bool? tmp = dr["dbnullValue"] ?? (bool?) dr["dbnullValue"];

Upvotes: 14

SLaks
SLaks

Reputation: 887305

You could write value as bool?.
This will return null if value is not of type bool.

Note that this is somewhat inefficient.

Upvotes: 6

Related Questions