I currently have a single-tenant application that uses fluent-nhibernate mappings to map C# objects to tables in my MySQL database.
As part of an effort to bring multi-tenancy to my application, I am considering having a single schema for each tenant. That is, I will have
n schemas with identical table structures,
n somewhere in the hundreds.
How can I rig up NHibernate, along with my fluent mappings, so that I can arbitrarily access the correct schema, and without having to replicate my C# objects to map to each schema?