[Resolved] Compiled Connection String Problem

[Traveller]

I have a 3 Tier asp.net application. I have the dataset and table adapters separated into different projects. The WCF service that uses the table adapters is also in a separate project. The problem that I now have is that the connection string is being compiled into the DLL for the table adapter. When I deploy the web service, the connection string is compile with the table adapter DLL and placed in the WCF service's BIN folder. I opened up the DLL and confirmed that it is in the DLL since I could not find it anywhere else. I need it to be in an config file so that I can change it for different environments and so that I can encrypt it.

How do I configure the project to use a connection string either in the WCF service's web.config or some separate config file?