We have two databases, Test and Production. The majority of the time the schemas are identical. Our EntityFramework project is mapped to Test (Database First). We simply change the connection string in the constructor at run-time to point to
either Test or Production and everything works great.
However, when we decided to add columns/properties to the Test schema for preliminary development and update the EntityFramework schema it will then fail to work with our Production database because it doesn't have those new columns yet. Is there a
way to instruct/setup EntityFramework to ignore certain columns/properties if they don't exist in the actual database?
We typically never delete old columns or tables, only add new ones.
Thanks