1 Reply Latest reply on May 4, 2007 11:26 PM by fhh

    Map multiple rows to one object?

    texan

      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.