DbType is equivalent to SqlDbType.Bit

Question

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

I'm 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 one Bit. Any ideas?

Answer 1

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

Answer 2

DbType.Boolean :

A simple type representing the boolean values ​​true or false.

SqlDbType.Bit :

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

Their description is not entirely consistent, but since Bit described as a Boolean , this is the most appropriate match.

Answer 3

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

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

Answer 4

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