I've created my first Windows-based .NET apps that connects to SQL Server.
- The development copy connects to my development SQL Server and works fine.
- If I paste the contents of the project's bin\Release folder over to a production machine, modify the connect string found in MyApp.exe.config, it works fine.
- I want to do it right, however, by publishing the project. How do I tell the publish process to use a different connect string? Do I temporarily the connect string in app.config to configure it for the production server and then publish the project? I doubt it.
- What is the accepted way of doing this?