Hi all

I have been using NHibernate for the last year on some basic projects, one of which has now exploded in terms of scope and now needs considerable refactoring.

The application is based on SQL CE as a data store, and I'd like to stick to this if possible.

What I want to do as part of my refactoring is have global data stored in one database, but all client specific data stored in its own database, so essentially each client ends up with its own database. Obviously, I'd also like to preserve any entity relationships between global data and client data, id possible.

I'm not even sure if this kind of approach is possible with NHibernate in conjunction with SQL CE. Can anyone point me in the direction of an example where this has been done?

I would very much appreciate any help you can provide.