Thanks Roger - much appreciated.

On Jun 23, 6:01 pm, Roger Kratz <[email protected]> wrote:
> <<however is it possible to get total count for audit data>>
>
> You probably need something like...
> IAuditReader.CreateQuery()
>    .ForRevisionsOfEntity(typeof(YourType), false, true)
>    .AddProjection(AuditEntity.RevisionNumber().Count())
>    .Add(AuditEntity.Id().Eq(yourPOID))
>    .GetSingleResult<long>()
>
> ________________________________________
> Från: [email protected] [[email protected]] f&#246;r Pete 
> [[email protected]]
> Skickat: den 23 juni 2011 17:56
> Till: nhusers
> Ämne: [nhusers] NHibernate.Envers and Paging Audit Data
>
> Hi,
>
> I've been using NHibernate for a week or two and I've been using
> MultiCriteria to get the results and total count for paged results in
> one db trip.  I can see how to set the first result and max result for
> Envers, however is it possible to get total count for audit data, so
> that paging can be achieved?  Maybe I could use HQL for the count, but
> this would incur two trips to db.
>
> Many thanks in advance,
>
> Pete
>
> --
> 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 
> athttp://groups.google.com/group/nhusers?hl=en.

-- 
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.

Reply via email to