I have a datatable with 3 columns (hostid, name, value). The primary key for uniqueness in it is a combonation of hostid and name, since there are many non-unique hostid with unique name. Whenever I make a call to nhibernate to retrieve a list of all elements with a certain hostid, it returns a list of only the first element in the database that matches the criteria multiple times. Does anyone know how to fix this? I've included a part of the mapping file and source code where i make the calls.

Source:
ISessionFactory factory = getSessionFactory();
ISession session = factory.OpenSession();

//Create the search criteria.
ICriteria crit = session.CreateCriteria(typeof(WilHostProperty));
crit.Add(Expression.Eq("HostID", host.ID));
crit.

IList temp = crit.List();

foreach (WilHostProperty hostProp in crit.List())
{
try
{
host.Properties.Add(hostProp.Name, hostProp);
}
catch (Exception) { } //Occurs if item exists already
}



The mapping file:

<class name="WilHostProperty" table="WIL_HOST_PROPERTIES">
<id name="HostID" column="WIL_HOST_ID" type="Int32">
<generator class="native"/>
</id>
<property name="Name" column="NAME" type="String"/>
<property name="Value" column="VALUE" type="String"/>
</class>

Sounds like you want to use a composite identifier and consists of your hostid and name fields.

There's information in the documentation about composite identifiers here:

http://www.hibernate.org/hib_docs/nhibe ... ompositeid

Cheers,

Symon.