Converting SQL data type BIT NOT NULL to C# type Byte through a SqlDataReader

Question

I have a simple piece of code

bool retrievalAttempted = Convert.ToBoolean(reader.GetByte(1));

where column 1 is of type BIT NOT NULL and yet I keep getting the exception

System.InvalidCastException: Specified cast is not valid.

What am I doing wrong here?

Tim Schmelter · Accepted Answer · 2017-03-15 15:08:19Z

6

If it's a bit-column you have to use reader.GetBoolean:

bool retrievalAttempted = reader.GetBoolean(1);

bit       Boolean       Bit       GetSqlBoolean       Boolean       GetBoolean

GetByte is only used for tinyint-columns.

answered Mar 15, 2017 at 15:08

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Diabolus · Accepted Answer · 2017-03-15 15:12:01Z

0

A bit is different than a byte !

Look at this link for sql server types vs .net types SQL Server Data Type Mappings

Diabolus

2692 silver badges16 bronze badges

answered Mar 15, 2017 at 15:09

Davidet

33 bronze badges