I am trying to use a map for a many to many relationship. I have a Customer table, a CustomerOffer bridge table, and an Offer table. The CustomerOffer table has CustomerID and OfferID as a composite primary key.

I have successfully mapped this using a bag, but I want to use a map instead. I want to be able to access a customer offer by customer.Offer[offerID]. In other words, the index is the offerID. OfferID must be unique to a customer.

However, when I try to switch the bag to a map, I start to get errors. Here is what I think I need to do.



However, this give a "OfferID already mapped" error. If I remove the OfferID from the <many-to-many> tag, then I get a bad load error, the generated SQL doesn't get the left-hand OfferID in the join.

What is the correct way of doing this, or is it possible?

D.

Hi there, I'm trying to do the same thing with a map , but I'm keep getting the error : "Error mapping generic collection Techno_Fly.ContactCenter.Core.List.List_ListItems: expected 2 generic parameters, but the property type has 1"

How does your class look like ?? is there any good documentation already available about this ?? where ? can't seem to find it

grtz!