Is this many-to-one possible?

reisender · **Joined:** Wed Mar 04, 2009 3:26 pm **Posts:** 4

Hey!

I have these two persistent classes:

Code:

public class Item{
    public virtual Int32 {get;set;}
    ...
}

public class ItemUpdate{
    public virtual Item Item {get; set;}
    public virtual DateTime Updated {get; set;}
    ...
}

The ItemUpdate table in the db has a foreign key to Item, so I can have many updates for a particular Item... I COULD map this relationship with a set or a bag or else... but this list isn't needed but for audits.

Only the last update is significant, so, rather than this:

Code:

public class Item{
    public virtual Int32 {get;set;}
    public virtual IList<ItemUpdate> ItemUpdates;
    ...
}

I need something like this:

Code:

public class Item{
    public virtual Int32 {get;set;}
    public virtual ItemUpdate LastUpdate {get;set;}
    ...
}

Is it possible to map this kind of stuff? Thanks in advance!

santo2 · **Posted:** Tue Apr 07, 2009 4:59 am

[my post didn't come through correctly so now i created 2 replies: check following]

santo2 · **Posted:** Tue Apr 07, 2009 5:03 am

Hey,

You could fill it up yourself by getting a list with the criteria :
- ItemId = ..
- order by date desc
- set max result to 1

crit.AddOrder(Order.Desc("Date"));
crit.SetMaxResults(1);
crit.Add(Expression.Eq("ItemId",<id>);

item.LastUpdate = crit.List().First();