CODEWITHSUNDEEP
c#enterprise-libraryenterprise-library-5sqldbtypedbtype
Aditi
Aditi

Reputation: 1198

DbType equivalent to SqlDbType.Bit

Does anyone know what is the DbType equivalent to SqlDbType.Bit?

I am trying to convert 

param[0] = new SqlParameter("@Status", SqlDbType.Bit);
param[0].Value = Status;

to

db.AddInParameter(dbCommand, "@Status", <DbType dbType>, Status);

but I don't know which DbType to use to represent a single Bit. Any ideas?

Upvotes: 9

Views: 30852

Answers (4)

jordanhill123
jordanhill123

Reputation: 4182

From http://msdn.microsoft.com/en-us/library/fhkx04c4, I would say DbType.Boolean A simple type representing Boolean values of true or false.

Upvotes: 2

Guffa
Guffa

Reputation: 700562

The database type bit is represented as a boolean on the server side, so the corresponding DbType value is DbType.Boolean.

Upvotes: 12

Alex
Alex

Reputation: 8937

http://msdn.microsoft.com/en-us/library/system.data.sqldbtype.aspx

enum SqlDbType - Bit: Boolean. An unsigned numeric value that can be 0, 1, or null.

Upvotes: 3

Damien_The_Unbeliever
Damien_The_Unbeliever

Reputation: 239764

DbType.Boolean:

A simple type representing Boolean values of true or false.

SqlDbType.Bit:

Boolean. An unsigned numeric value that can be 0, 1, or null.

Their description's don't quite match up, but since Bit is described as being a Boolean, it's the most appropriate match.

Upvotes: 10

Related Questions