Is it possible to map multiple rows to one object? Here's a sample table:
User_Preference_Value ----------- user_id pref_id value
The combination of (user_id, pref_id) is not unique. A User can have multiple values for some preferences. I'd like to have a single UserPreference value whose compound key is (user_id, pref_id), with a collection of Strings for Value.
Is this possible?
I'd rather not have to create a User_Preference table with user_id/pref_id just to satisfy the mapping needs.