I agree, I can't find a way to use 2 differents schemas in mssql with DAL. 2 connections are not a solution because it seems there is no way to explain to DAL wich schema you want to connect to per each connection, you can only specify database. How do you handle this? Schemas, like in postgres, are logical subsets of tables in a single database.
This is an important limitation for DAL. I think there should be a way in table definition to specify the schema, so that you can do queries that join tables of two different schemas in the same connection. Any other idea?
