I am creating a globalized application and some of the dynamic content will be stored in a database. We were planning on storing the information for different locales in different database tables.

So if we provided English and Spanish translations of a product table we would have these 2 tables (English is the default):

Product
Product_es

Configuration resources would be responsible for indicating the correct database table from which dynamic content should be drawn.

My question is, how can I have NHibernate dynamically pull data from the correct table based on the user's culture? Is it possible to change the table for an object at runtime?

Is it even possible to work with Nhibernate and Localized data?

Thanks for any help.