DbType equivalent to SqlDbType.Bit

Question

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?

a boolean perhaps? Altough the DbType is Bit and the .NET type is bool, so what do you mean by "DbType equivalent to SqlDbType.Bit ?" — Freeman, Mar 06 '13 at 09:22
@Freeman wouldn't a boolean take true or false? and bit takes 1, 0.. — Aditi, Mar 06 '13 at 09:26

score 10 · Accepted Answer · answered Mar 06 '13 at 09:27

10

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

answered Mar 06 '13 at 09:27

Guffa

score 9 · Answer 2 · answered Mar 06 '13 at 09:26

9

A simple type representing Boolean values of true or false.

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.

answered Mar 06 '13 at 09:26

Would something like this work then - `cmd.Parameters.Add("@isActive", SqlDbType.Bit).Value = False` – MaylorTaylor Dec 17 '14 at 17:05
Is it most appropriate? C# does know `null`, as do nullable `BIT` fields in SQL. SQL Server, for instance, accepts `0/1/NULL` only rather than `true/false`. – dakab Nov 30 '15 at 17:30
@dakab - there are various issues here that I didn't include in my answer - such as the fact that SQL Server doesn't have an actual boolean data type (`bit` is described in documentation as a numeric type) and that, if SQL Server *were* to implement the proper (SQL Standard) boolean data type then, due to its use of three-valued logic, that type should support `true`, `false` and `unknown`, plus the (standard for every type) absence of a value via `null`. – Damien_The_Unbeliever Nov 30 '15 at 17:35

score 3 · Answer 3 · answered Mar 06 '13 at 09:27

3

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

answered Mar 06 '13 at 09:27

Alex

score 2 · Answer 4 · answered Mar 06 '13 at 09:28

2

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

answered Mar 06 '13 at 09:28

jordanhill123

This doesn't take into account that the OP was asking for `SQLDbType` which does not include a Boolean type – MaylorTaylor Dec 17 '14 at 17:04

4 Answers4