Change the database after creating the .edmx file

Question

Hi,

Due to a requirement I had to change the database after I created the .edmx file. Its not the changes to the database I wanted to change the database. first I tried changing the connection string. 

when the connection string is changed I can access the new database through the .edmx file. but the problem is when I tried to update the model from database it will try to update from the old database. 

I dont know why EF is using the old connection string for updating the model. Please give me suggestions

Thank you.

Answer 1

Hi,

Right-click in your EDMX file and select "Properties". Then look at "Connection String" property value to see where your model is connecting.

Best regards,

 

JAReyes.

Answer 2

There is no "Connection String" property in the properties window for the EDMX.  Using Visual Studio 2010.  Only properties in that window are:

• Build Action
• Copy to Output Directory
• Custom Tool
• Custom Tool Namespace
• File Name
• Full Path

So where to change the connection string?

Thanks!

Answer 3

Hi,

You can find the connection string in the App.config file located at your project root directory.

Regards,

JAReyes.

---

Please remember to Vote & "Mark As Answer" if this post is helpful to you.
Por favor, recuerda Votar y "Marcar como respuesta" si la solucion de esta pregunta te ha sido útil.

Answer 4

Double click on the .edmx file in solution explorer.  this will take you to the modelling window.  Right click and select properties.