C#

private void dataPager_OnDemandLoading(object sender, Syncfusion.UI.Xaml.Controls.DataPager.OnDemandLoadingEventArgs args)
{
    List<Equipment> data;
    using (var _sqliteContext = new SQLiteContext())
    {
        data = _sqliteContext.Equipments.Include(x => x.CostCenter).Skip(args.StartIndex).Take(args.PageSize).ToList();
    }
    dataPager.LoadDynamicItems(args.StartIndex, data);
    //resetting cache for all pages.
    (dataPager.PagedSource as PagedCollectionView).ResetCache();
}

private void dataPager_OnDemandLoading(object sender, Syncfusion.UI.Xaml.Controls.DataPager.OnDemandLoadingEventArgs args)
        {
            BackgroundWorker worker = new BackgroundWorker();
            worker.WorkerReportsProgress = false;

            worker.DoWork += worker_DoWork;
            worker.RunWorkerAsync();

        }

void worker_DoWork(object sender, DoWorkEventArgs e)
        {
            List<Equipment> data;
            using (var _sqliteContext = new SQLiteContext())
            {
                data = _sqliteContext.Equipments.Include(x => x.CostCenter).Skip(args.StartIndex).Take(args.PageSize).ToList();
            }
            dataPager.LoadDynamicItems(args.StartIndex, data);
            //resetting cache for all pages.
            (dataPager.PagedSource as PagedCollectionView).ResetCache();
        }

private void dataPager_OnDemandLoading(object sender, Syncfusion.UI.Xaml.Controls.DataPager.OnDemandLoadingEventArgs args)
        {
            using (var _sqliteContext = new SQLiteContext())
            {
                dataPager.LoadDynamicItems(args.StartIndex, _sqliteContext.Equipments.Include(x => x.CostCenter).Skip(args.StartIndex).Take(args.PageSize));
                //resetting cache for all pages.
                (dataPager.PagedSource as PagedCollectionView).ResetCache();
            }
        }

Quote:

System.ObjectDisposedException: 'Cannot access a disposed context instance. A common cause of this error is disposing of a context instance that was resolved from dependency injection and then later trying to use the same context instance elsewhere in your application. This may occur if you are calling 'Dispose' on the context instance, or wrapping it in a using statement. If you are using dependency injection, you should let the dependency injection container take care of disposing context instances.
Object name: 'SQLiteContext'.'

Spire.Doc.Document document = new Spire.Doc.Document();

TypeLoadException: Could not load type 'spride' from assembly 'Spire.Pdf, Version=8.2.2.0