I have a table which is going to have about 15 sets of children, all of the same type. I don't want an extra mapped link table, and I don't want 15 many-to-many relationships.
The most efficient way of storing this in the database is as: <Parent entity> - ID: 1234 - Desription: "Fred" - Set1: "ID1,ID2,ID4" - Set2: "ID1,ID2,ID3,ID32 - Set3: "ID6" The identifiers in this case are natural keys (ISO country codes), so I'm not worried about leaving them packed inside of strings. Is it possible to have NHibernate load each set of collections via these backing fields? Can IUserCollectionType help me achieve this? -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
