My program (WCF service programming in C#) has to access multiple sql server groups and the databases within those groups (sql server). It looks like linq 2 sql definitely doesn't support this unless I create multiple dataclasses per database, and it looks like the entity framework is in the same boat.
How would you go about setting up your application that has to access multiple sql server groups that are not linked?
I suppose I could just use SqlConnection and SqlCommand and create some classes to handle it. If I go this route how would I go about populating my model classes with the result of the query? (I don't want to use datatables, but rather List)
I.E.
Server1
- database 1
- database 2
Server2
- database 3
- database 4
My program has to access database 1 and database 4, and they're not linked / will not be linked.