Hello I have this table strcture (can't change it)

TableA
IDA Ref
1 1
2 2

TableB
Ref Value1 Value 2
1 0 2
1 1 2
2 0 3

In want the collection of entity from Table B where TableA.Ref = TableB.Ref

EntityA.ListeEntityB

EntityA(IdA= 1) muste return 2 EntityB ((Value1=0, Value2=2);(Value1=1, Value2=2)


This mapping configuration does not work

<class name="EntityA" table="TableA">
<id name="Id" column="IDA" unsaved-value="0">
<generator class="native" />
</id>

<bag name="ListeEntityB" table="TableB">
<key column="Ref"></key>
<one-to-many class="EntityB" />
</bag>
</class>


So how can i make the association whith this ugly structure (can't change it), does hibernate requires an association table for collection ? How can i make the association without a unique index (Ref in Table B is not unique ??)

Thanks for your reply

I think NHibernate can't handle this. How should NHibernate know which Object to change without an unique identifier, if you update one?

Thanks for your response, I need to read only not update delete or insert