title: Attempting to add a Yes/No data type Field in table in Visual Studio 2010
body: <p>Maybe someone can help me. As part of a college project I am attempting to design a number of tables within MS Visual Studio. We had previously designed these tables using Microsoft Access and one of the fields had a data type of Yes/No. In other words the data which was been saved to the particular field in the table would only contain a yes/No value.</p>
  
  <p>Is there any way to replicate such a data type in Microsoft Visual studio. We are using an SQL server database and I am able to create the table but the only thing I am unable to do is to set the value type to replicate the yes/No value in Access. I would have assumed there would be an option to set values as boolean data type but this option is not present.</p>
  
  <p>To clarify the version of Visual Studio is 2010 Professional and we are building the particular tables in C#.</p>
  
  <p>Can anyone advise on an alternative option to Yes/No which will still return a true/false value or even a 0/1 value would do fine. </p>