Hi,
Is it possible to use Expression.Sql to assign a value to a property?
I have mapped two tables to their respective classes, but now I need
an aggregate value from a column in a third table. To get a hold of
this
table I would need to join another 5 tables, this seems like too much
work
for a single column. I am therefore looking for other options, one
being
to use Expression.Sql. But I do not know if this is the best solution
or
even if it is possible.
This is a trimmed down version of the code I have today...
var deliveries = Session.CreateCriteria<ObjectDelivery>()
.Add(Restrictions.Between("LoadingDate",
filterStartDate, filterEndDate))
.AddOrder(new Order("LoadingDate", true))
.List<ObjectDelivery>();
What I would like to do is to add something similar to the following
line:
.Add(Expression.Sql("SELECT PropertyInObjectDelivery =
Count(tbl.Cloumn) FROM table AS tbl WHERE ..."))
That would add the Count aggregate value into the Property in
ObjectDelivery.
What is the best way to achieve something like 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.
