Relationships between Profiles

  • Article

In Commerce Server 2002, explicit relationships between profiles are not supported. If you want to establish a relationship between profiles, you can follow one of two strategies:

  • Use a multivalued property that stores the primary key field of the related profile. An example of relating users and addresses would entail using the UserObject profile to store the AddressId values of the user shipping address, billing address, work address, and so on. This multivalued property can be written to and retrieved using the ProfileService object.
  • The second approach to establishing the relationship is by using the Commerce Server OLEDB query path. An example of this approach is to define a UserId property on the Address profile, then, using Commerce Server OLEDB queries, retrieve the recordset of addresses related to a particular user.

Copyright © 2005 Microsoft Corporation.
All rights reserved.