In nHibernate, how can I change the database connection (different db) dynamically?

Question

If I want to do vertical partitioning of my db, how could I change the database connection dynamically on a per query basis?

i.e. userID > 100000 use db1, otherwise use db0.

Answer 1

See this.