How to define a property whose type in database is bit?

Question

I have a column named source of type bit in my database. but I want to get set its value in my program. how can I do that? I know it was a simple doubt but I was little bit confused. Do I have to use byte as type while setting this or not?

Answer 1

Use bool for representation bit from database:

public bool MyBitDbProperty {get;set;}

If you use SqlDataReader than use reader.GetBoolean(position) for bit type.

If you use any rdbms(like linq to sql), bit will mapped to bool by default.

Answer 2

The bit database type will contain the values 0 and 1, and normally (you've not stated RDMS) corresponds nicely with the bool or Boolean types in c#.