public void FetchPage(DevExpress.Mvvm.Xpf.FetchPageAsyncArgs args) { args.Result = Task.Run <DevExpress.Xpf.Data.FetchRowsResult>(() => { const int pageTakeCount = 5; using (var session = new DevExpress.Xpo.Session()) { var queryable = session.Query <XPOIssues.Issues.Issue>().SortBy(args.SortOrder, defaultUniqueSortPropertyName: nameof(XPOIssues.Issues.Issue.Oid)).Where(MakeFilterExpression((DevExpress.Data.Filtering.CriteriaOperator)args.Filter)); var items = queryable.Skip(args.Skip).Take(args.Take * pageTakeCount).ToArray(); return(DetachedObjectsHelper.ConvertToDetachedObjects(items)); } }); }
public void FetchPage(DevExpress.Mvvm.Xpf.FetchPageAsyncArgs args) { const int pageTakeCount = 5; args.Result = Task.Run <DevExpress.Xpf.Data.FetchRowsResult>(() => { var context = new EFCoreIssues.Issues.IssuesContext(); var queryable = context.Issues.AsNoTracking() .SortBy(args.SortOrder, defaultUniqueSortPropertyName: nameof(EFCoreIssues.Issues.Issue.Id)) .Where(MakeFilterExpression((DevExpress.Data.Filtering.CriteriaOperator)args.Filter)); return(queryable.Skip(args.Skip).Take(args.Take * pageTakeCount).ToArray()); }); }