I have two database connections that connect to two separate SQL severs. The connection strings are stored in a separate ConnectionStrings.config file I have the following in my Web.config
<connectionStrings configSource="ConnectionStrings.config" />
I use LINQ to SQL and a DBML file is created. I finished dragging and dropping tables from the first db. When switched to the second connection and try to drag and drop tables to the surface, I got a warning "The objects you are adding to the designer use a different data conneciton than the designer is currently using. Do you want to replace the conneciton used by the designer?". Should I add a second DML and drag and drop the tables from the second db so I don't get problems with multiple connections? If say Person is a class in the first DBML and PersonPrivacyContent is on the second DMBL. How could I associate these two classes? If only one DBML is needed, how do I switch between two connections and execute LINQ queries in each db? Thank you.
View Complete Post