title: There is already an object named 'BookInvestments' in the database
body: <p>I know a lot of answer for this question is available here but I have tried all out and not working. Maybe because my issue is different..</p>
  <p>So i have an application already already in use with code-first approach. More than a year now. But there is the need to add some functionality which requires new fields to existing tables and also additional tables.</p>
  <p>I am done adding this on local system. I want to do migration for it but bringing error</p>
  <p><strong>There is already an object named 'BookInvestments' in the database</strong>  BookInvestment is an already existing table in the database by the way..</p>
  <ol>
  <li><p>I have deleted the migration table on the Database and issue persist.</p>
  </li>
  <li><p>Please note that the namespace of the application remains same</p>
  </li>
  <li><p>I have also deleted the files created in the migration folder on my visual studio in trying to create new migrations and update database but issue persist.</p>
  </li>
  <li><p>I have records in the database and I cannot discard it as client has to make use of it going forward as well.</p>
  </li>
  </ol>
  <p>Please what do you suggest I do?</p>