title: Dropping Columns referenced by other Tables
body: <p>Hi I have 3 Tables Cases, Programs, Violations, now all these Tables are related as ManyToMany with Notice Table, but earlier they were having OneToMany, but now they are related ManyToMany, hence I moved them all to the Associated Table to handle it, which is called as ManyToMany table which has PK, ParentyEntity, ParentEntityId (which is PK of Notices table), ChildEntity, ChildEntityId - I have to do it with Entity Framework Code First Migrations - hence I am trying to be very cautious here.
  What am I planning are
  1.Take backup of the Database
  2. Migrate Data from tables to ManyToMany table
  3. Record all the Foreign Key Constraints first (like generate scripts for those FKs references) then drop all those Foreign Keys
  4. Then Drop tables using Entity Framework Code First Migrations.</p>
  
  <p>Can somebody please help me if I am missing anything and are there any easy fool proof ways to do the same and how to drop columns using Entity Framework Migrations - I have lost touch with Code First approach, I understand its tough and needed very careful implementation - any suggestion any help would be very very helpful. Actually the Database has already have been implementing this - but they didn't drop the old columns and didn't delete the data from old columns - hence its creating or showing inconsistent Data, the old programmer has left it in between - need a lot of suggestions and support - thanks a lot.</p>