Update .Edmx file When i change Db connection string in c#

Question

I am not sure if there is a way to update edmx file automatically when database is changed. current DbName = TestSolutionDB with 4 tables (CountryStateAddressUser) Change DbName = ProjectDB with 4 tables(UserProjectStatusActivity) When i replace the Connection string like data source=.;initial catalog =TestSolution To data source=.;initial catalog =ProjectDB  I need to update .edmx file (CountryStateAddressUser) TO (UserProjectStatusActivity) Design and tt.file These All Items can happened by pragmatically Can give solution? Thanks

Felish Anand · Answer

Hello Tejas I was creating the Dynamic Project Solution  for that i need .edmx and Database file generated dynamically. so I move up with Code-First Approach. Have doubt in Code-First Approach  how to generate the database with out adding the data to the table

Tejas Trivedi · Answer

Hi Anand Rather than adding dynamic capabilities to edmx which is again overhead as it needs recompilation and hot swapping of the dlls which are already loaded in the application domain the simple apporach would be you should have edmx per database in this case two edmx file and create an instance of the entity framework proxy class based on the configuration settings. This would not only resolve what you want to achieve but also make your design and code cleaner. Hope this will help you out. Feel free to write if more information is required. Please don't forget to mark as answer if this helps.