<<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ö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 at http://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.
