How to return a bool using execute scalar

Question

I have a stored procedure returning a boolean varialbe :

Here is my C# code that works when I try to return an int variable.But it doesnt work when I try it for bool.

DbCommand dbCommand = db.GetStoredProcCommand("spGetConfigureAlerts");
            object o = db.ExecuteScalar(dbCommand);
            bool item = o == null ? 0 : (bool)o;
            return item;

I have it as shown above , but on line three it says that :

Type of conditional expression cannot be determined because there is no implicit conversion between 'int' and 'bool'

How can I solve it ?

Note that your stp should select rather than return the value: http://stackoverflow.com/questions/520735/can-you-use-cmd-executescalar-when-the-sproc-uses-return-value — Jan Van Herck, Sep 14 '13 at 00:10

score 7 · Accepted Answer · answered Sep 13 '13 at 23:23

7

Why do you use 0 at all if you want to initialize a bool variable?

bool item = (o == null || DBNull.Value == o) ? false : (bool)o;

answered Sep 13 '13 at 23:23

Tim Schmelter

450,073
74
686
939

score 1 · Answer 2 · answered Sep 13 '13 at 23:23

1

bool item = o == null ? false : (bool)o;

answered Sep 13 '13 at 23:23

Dmitrii Dovgopolyi

6,231
2
27
44

score 0 · Answer 3 · answered Sep 13 '13 at 23:23

0

Try this:

bool item = o == null ? false : (bool)o;

answered Sep 13 '13 at 23:23

Hamlet Hakobyan

32,965
6
52
68

How to return a bool using execute scalar

3 Answers3