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?
The database type bit is represented as a boolean on the server side, so the corresponding DbType value is DbType.Boolean.
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.
cmd.Parameters.Add("@isActive", SqlDbType.Bit).Value = False
null, as do nullable BIT fields in SQL. SQL Server, for instance, accepts 0/1/NULL only rather than true/false.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.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.
From http://msdn.microsoft.com/en-us/library/fhkx04c4, I would say DbType.Boolean
A simple type representing Boolean values of true or false.
SQLDbType which does not include a Boolean type