I have a .net website project that is using table adapters. I have a connection string in the webconfig file that I use for test and production database connections. I simply comment out the connection I'm not using but both connections use the same name.
I'm experiencing an issue where the application is still using the test connection when I deploy to production even though the test connection string is commented out. Also, I have all of the table adapter connection modifiers set to Public. Has anyone
experienced this before? Does it has something to do with website projects? I'm very confused and occurs often.
WebConfig
<add name="AppConnectionString" connectionString="Data Source=prodserver;Initial Catalog=prodDB;User ID=produsername;Password=prodpassword" providerName="System.Data.SqlClient"/>
<!--<add name="AppConnect ...
Go to the complete details ...