Hi,

I have a table linked to two others and I need to create two indexes for this table with one common column.

For instance: my ALERT table has a type which is mandatory in the index used when I retrieve alerts for a user and when I retrieve alerts for an automation module. The both sources can create/generate alerts.



I tried to specified two "index" attributes, and one index attribute with two columns separeated by a "," or ";". But id did not work.

My question : how can I specify for a column that it is part of two multiple column indexes?

Thank for help,
C-Rock

C-Rock,
Did you get any help or solve your problem about muliple indexes? I have a similar situation.
Riley

Hi Riley,

Unfortunately no, I just addressed my problem by a "design" workarround.

As far as I know, this approach is not possible with pure HBM configuration. You may be able to write an HQL query; I personally would prefer some other means. The most likely to work like you intend? Design your Alert class with two private fields, userId and moduleId. Map the two possible alert sources to those fields using Field access (it shouldn't matter that they're private as long as NHibernate looks for the correct name), then use a single property to expose them, with the simple rule that if the first is null or empty, return the second. If you need a setter, this becomes more complex, and I would recommend fully implementing properties for both backing fields and figuring out which to use in your BL code.