NHibernate HQL max and count values. How to access retrunded values from c# -
i trying max amount , number of records in single hql(fluent nhibernate). after how access c# code
following thing trying acheieve. please note have use createquery.
{ var maxoffer = session.createquery("select new map( max(amount) maxamount,count(*) total) offer o").list() ; object agg = maxoffer[0]; console.writeline(((object[])(agg))[0]); console.writeline(((object[])(agg))[1]); }
Comments
Post a Comment