We are using NHibernate to access multiple databases on a single SQL Server using a single session factory. We used technique specified in the following post
viewtopic.php?f=25&t=962161.
Basically, we fully qualify the schema name to access different databases on same server. For example: If DomainObj1 exists on DB1 then in the mapping file we specify Schema="DB1.dbo" and if DomainObj2 exists on DB2 we specify Schema="DB2.dbo". It works fine on SQL server.
The problem is for component testing we use SQLCE instead of SQL server and I don't know how to use multiple SQLCE databases using single Session Factory (if it is possible at all). Can anyone suggest a solution for this problem. Any help is appreciated.
Thank you.
Syed