My application currently is two tiers with a Windows client deployed through ClickOnce connecting directly to the database. I am wondering how to manage connection strings during deployment to different environments and have a couple of questions.
Currently the connection string is an embedded resource within the AppHelper assembly. Is it possible to extract embedded text file from a dll. Should I encrypt that resource?
If I leave the file unencrypted and as an embedded resource how can I allow an administrator to modify the connection string to the appropriat environment.? Custom config app that builds the AppHelper.dll or maybe just have the admin use the .net compiler, MSBuild? Anyone have code or an example.