title: Created Entity Model can not be generated in database
body: <p>I needed to change the model of my database and I have done that via Entity Model Diagram as shown below. </p>
  
  <p><img src="https://i.stack.imgur.com/F4uXu.png" alt="Model Diagram"></p>
  
  <p>Here is the City mapping</p>
  
  <p><img src="https://i.stack.imgur.com/2vFxH.png" alt="City Mapping"></p>
  
  <p>I have deleted an association between Medical (this holds Hospitals and Clinics) and City because this association was completely wrong, I had to connect actually MedicalService and City. </p>
  
  <p>Then I have created a new entity called CityService. Since relation between MedicalService and City is many to many I have needed such a table. </p>
  
  <p>After that point, I was thinking all I had to do was "Generate Database from Model" but first I got an error as "entity type is not mapped", I have overcome this issue somehow (still I don't know how, it has been resolved somehow) then I have clicked again "Generate Database from Model" and it first deleted and droped everything and then created again. </p>
  
  <p>But on my database there isn't generated any table called CityService. Should I created it manually or did I do something wrong? Or at least, tell me your opinion if it normally has to work or not? I am pretty new to EF.</p>
  
  <p>I have manually created a table called CityService with the exact properties on the physical database. Then just for test purpose, I have added test1 scalar property to the CityService Entity and test2 scalar property to the City Entity, this time when I choosed "Generate Database from Model", it has done some changes to the web.config, I have saved and run the page and I got the following error:</p>
  
  <p><img src="https://i.stack.imgur.com/bxdJp.png" alt="error"></p>
  
  <p>and Inner Exception</p>
  
  <p><img src="https://i.stack.imgur.com/UyELf.png" alt="enter image description here"></p>