Here is what I figure I'll have to do.

I will have to do is create my sprocs/UDF's as a C# class library and always go and get ( pass it in to sproc ) the connection string when I need it rather than use the context connection attribute in a Sql Server project. Then I can compile the code and deploy it manually by using the CREATE ASSEMBLY command on the server.

Bummer. :(