Update .edmx file when database connection string changes at runtime using C# pragmatically

Question

0.00/5 (No votes)

See more:

, +

I am not sure if there is a way to update edmx file automatically when database is changed.

current DbName = TestSolutionDB  with 4 tables (Country,State,Address,User)
Change DbName = ProjectDB with 4 tables(User,Project,Status,Activity)

When i replace the Connection string like 
data source=.;initial catalog ="TestSolution" To 
data source=.;initial catalog ="ProjectDB "

I need to update .edmx file (Country,State,Address,User) TO (User,Project,Status,Activity) Design, and tt.file 

These All Items can happened by pragmatically, Can give solution?

Thanks

What I have tried:

Yet i don't have any idea about this, i am newbie for this

Posted 21-Jul-17 13:12pm

Nithu Nithiya

Updated 23-Jul-17 21:06pm

Add a Solution

Comments

David_Wimbley 22-Jul-17 0:52am

I would strongly caution against this. Why would you need to do this? It seems to me this is an issue of you not keeping your DB server environments in sync and this is trying to automate that.

What happens if DB server 1 is correct and DB Server 2 is not. You change your connection string to DB Server 2 and just removed columns that breaks whatever environment DB server 1 is connected to. Or vice versa. Now if someone deploys the app but not your entities, you've just introduced a bug.

I think a proper deployment process of your DB schema is the better fix here. That along with having some DB server be the source schema where any changes from the source schema get propagated out to your other environments accordingly.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Satya Prakash Swain · Answer 1 · 2017-07-23T21:06:00

Solution 1

This may be a solution Unknown Class Dynamically Generated at runtime for Entity Framework, WCF OData and dynamic client consumption[^]

Posted 23-Jul-17 21:06pm

Satya Prakash Swain