title: How to display bool values in a view and save the value to DB
body: <p>I have a table that has bit values (true/false)</p>
  
  <p>Table Definition:</p>
  
  <pre><code>CharacterID int 
  isActive    bit 
  UserId  uniqueidentifier
  </code></pre>
  
  <p>I have 2 problems:</p>
  
  <ol>
  <li>How to display the existing selected option in the edit view in a Dropdown</li>
  <li>I need to save the value (yes/No) as true and false in the database.</li>
  </ol>
  
  <p>Here is what I have attempted so far:</p>
  
  <pre><code>&lt;div class="editor-label"&gt;
      @Html.LabelFor(model =&gt; model.IsActive)
  &lt;/div&gt;
  &lt;div class="editor-field"&gt;
          @Html.DropDownList("", new SelectListItem[] { new SelectListItem() { Text = "Yes", Value = "true", Selected = Model.IsActive }, new SelectListItem() { Text = "No", Value = "false", Selected = !Model.IsActive }})
  &lt;/div&gt;
  </code></pre>