Hello, I have the following situation:

I have a product with several translations, placed in the database under product and producttranslation tables.

Now, I would like to map a property for product for the current user's translation of the product. (If I want all the translations, we get those independently).

Since the database relation between this tables is not one-to-one but one-to-many, I was wondering if there's a possibility to force the one-to-one by giving an extra criterium to the relation mapping?

Tnx, Bert

You can't have a property of product that would return a different value based on the current user. Why don't you just have a method in product that returns a single translation given the current user's language?

Or have I misunderstood you?