I got following tables :

table Entity
EntityID SEQUENCE


table EntityTranslation
TranslationID
LanguageID
EntityID
Name

This way i got one entity which name is translated into several languages.

I designed following persistent objects

class Translation
{
string name;
}

class Entity
{
IList Translations;
Translation currentTranslation
}

It is strait forward to map translations of entity to Translations collection. But for every session there is current language specified. I want currentTranslation to be bound to the specific translation in EntityTranslation table and the LanguageID will be different for each session.

Im preety new to nhibernate and I'm unable to solve this problem. Could anyone please help me ?

Regards,
Piotr