title: EntityFramework Codefirst Updating from Database
body: <p>I know this isn't the designed method of using EntityFramework but I have a much easier time designing the database in SQL Management Studio to create indexes, link foreign keys, etc... all visually.  But I really want to use the automatic database updates for the future when deploying updates to customers.</p>
  <p>I designed the original database in SQL Management Studio then created the EntityFramework code first from that database.  But if I want to add another table so far, I end up dropping everything then regenerating the DB from SQL Management Studio.   This has been ok for the first part of my framework development but now things are starting to get a little more complex.</p>
  <p>I've tried to learn the code first mechanism but some of the more complex items have bit me and I don't have a lot of time to allot for this.  I was hoping there was a hybrid way of designing in SQL Management Studio then utilizing the database deployment functionality built into EntityFramework.</p>