How to implement repository pattern for multiple database

Question

We currently have two presentation projects (classic ASP and ASP.NET, which uses the "NHibernate Best Practices with ASP.NET" (predecessor or Sharp architecture). We are now rewrite all the classic ASP with Silverlight + WCF(maybe RIA services).

We have the following database architecture: * one global data database - contains users and projects meta info * each project has its own database to store project-specific info - same schema

We were able to hack a bit to make multiple databases work in ASP.NET because "NHibernate Best Practices with ASP.NET" uses DAO factories, which we can hack a bit to create the connection string - base on the projectId - to pass to the factory to create the corresponding NHibernate session.

For the rewrite, we would like to use the repository pattern from Sharp architecture. But we couldn't figure out how to do the similar hack...

Any help is appreciated.

Answer 1

Have a look at the ncommon framework which provides a nice foundation for multi-database support in NHibernate as explained in this blog post.

Answer 2

I have hacked a little bit to Sharp Architecture and re-built it for multiple database in my post. Hope it will help you.

Answer 3

No matter what pattern you are using the ISessionFactory handles the connection. Use an IoC container with some form of named or optional parameters to specify the connection string.