title: Adding a New Column to an Existing Table in Entity Framework
body: <p>I have added a new column to a table in my database. The table is already defined in the existing Entity Framework model. I've been through most of the items here on how to do this and it still fails. </p>
  
  <p>A little background, this entity model has not been  updated in at least 3 years. So aside from the column I'm adding I know there have been a number of other columns that have been added in that time, but never included. I took over the project about 9 months ago and have never been able to successfully update the model.</p>
  
  <p><strong>First attempt:</strong></p>
  
  <ul>
  <li>Opened the Model in Visual Studio</li>
  <li>Right Clicked on the Background</li>
  <li>Clicked on "Update Model From Database..."</li>
  <li>Clicked on the Refresh Tab</li>
  <li>Selected Tables</li>
  <li>Highlighted the specific table</li>
  <li>Clicked Finish</li>
  </ul>
  
  <p><strong>Result:</strong> </p>
  
  <ul>
  <li>Classes for Dozens of tables that were in my model were deleted</li>
  <li>The table in question was not updated</li>
  </ul>
  
  <p><strong>Second Attempt</strong></p>
  
  <ul>
  <li>Restored all Source</li>
  <li>Same as above but</li>
  <li>After opening the Update Wizard, Clicked the Delete Tab</li>
  <li>Selected Tables</li>
  <li>Clicked Finish</li>
  <li>All the Tables were deleted</li>
  <li>Saved the EF Model/Closed/Opened it</li>
  <li>Went back to the Update Wizard Add Tab</li>
  <li>Clicked Tables</li>
  <li>None of my tables were displayed when I expanded everything</li>
  <li>Checked the checkbox at the Tables level</li>
  </ul>
  
  <p><strong>Result</strong></p>
  
  <ul>
  <li>None of my tables were added back, but anything that was not
  originally included was added</li>
  </ul>
  
  <p><strong>Third Attempt</strong></p>
  
  <ul>
  <li>Restored all source</li>
  <li>Deleted the two .tt files</li>
  <li>Opened the Update Wizard</li>
  <li>Clicked Add for Everything</li>
  </ul>
  
  <p><strong>Result</strong></p>
  
  <ul>
  <li>Nothing was recreated, no .tt files or anything else.</li>
  </ul>
  
  <p><strong>Fourth Attempt</strong></p>
  
  <ul>
  <li>Restored Source</li>
  <li>Deleted Table from the EF Model</li>
  <li>Opened Update Wizard</li>
  <li>Clicked Add Tables</li>
  </ul>
  
  <p><strong>Results</strong></p>
  
  <ul>
  <li>Classes for Dozens of tables that were in my model were deleted</li>
  <li>The table in question was not added back</li>
  </ul>
  
  <p><strong>Final Attempt</strong></p>
  
  <ul>
  <li>Added entity manually to model</li>
  </ul>
  
  <p><strong>Result</strong></p>
  
  <ul>
  <li>Code all compiled and ran, but values were never retrieved from the DB or updated</li>
  </ul>
  
  <p>Any help or direction that could be provided would be greatly appreciated as I'm at a critical point and have to get the model updated.</p>