This question is locked. New answers and comments are not allowed.
I have a ORM project with only entities model in it. The connection string is stored in app.config of the project called MyConnectionString.
I then setup an empty WCF service project for the data service. Right clicked on the entities model in ORM project to "Add OpenAccess Service" into the WCF Service project. In the WCF service project the connection string is stored in its web.config, also called MyConnectionString.
Now I have 2 connection strings with same name in both projects. If I want to point the service to a different database I have to change the connectionstring details in both places before publish. This is a major restriction for me.
Is there a way I can get the ORM project to consume the same connectionstring in the web.config of the WCF service project, so that when I deploy the project I only need to change connectionstring details in one place, and without having to republish.
thanks in advance
I then setup an empty WCF service project for the data service. Right clicked on the entities model in ORM project to "Add OpenAccess Service" into the WCF Service project. In the WCF service project the connection string is stored in its web.config, also called MyConnectionString.
Now I have 2 connection strings with same name in both projects. If I want to point the service to a different database I have to change the connectionstring details in both places before publish. This is a major restriction for me.
Is there a way I can get the ORM project to consume the same connectionstring in the web.config of the WCF service project, so that when I deploy the project I only need to change connectionstring details in one place, and without having to republish.
thanks in advance