I told sql server cannot understand config files because initially everything was in config file both in service and also in sql server project which is consuming that service but...

I have discussed about your suggestion with my manager.I have been allowed to do only in this way.Please Help.:-(.

For your clarity purpose I have given the service and th sqlclr...

We don't have any choice but to consume the wcf service from SQL Server Project only since we can't change the existing architecture.

Considering this scenario,please suggest.