C#

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

CREATE TABLE [dbo].[Persons]
(
    Id                          INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
    RemoteId                    UNIQUEIDENTIFIER NOT NULL,
    ClientRepId                 INT NULL FOREIGN KEY (ClientRepId) REFERENCES Persons(Id),
    SupervisorId                INT NULL FOREIGN KEY (SupervisorId) REFERENCES Persons(Id),
    PersonType                  INT NOT NULL,
    Prefix                      INT NULL,
    FirstName                   VARCHAR(MAX),
    LastName                    VARCHAR(MAX),
    NickName                    VARCHAR(MAX),
    Suffix                      INT NULL,
    Title                       VARCHAR(MAX)
)

namespace CLOI.Entities
{
    public class PersonEntity : _EntityBase
    {
        private PersonType _PersonType;
        public PersonType PersonType
        {
            get { return _PersonType; }
            set
            {
                SetProperty<PersonType>("PersonType", ref _PersonType, value);
            }
        }

        private NamePrefix _Prefix;
        public NamePrefix Prefix
        {
            get { return _Prefix; }
            set
            {
                SetProperty<NamePrefix>("Prefix", ref _Prefix, value);
            }
        }

        private string _FirstName;
        public string FirstName
        {
            get { return _FirstName; }
            set
            {
                SetProperty<string>("FirstName", ref _FirstName, value);
            }
        }

        private string _LastName;
        public string LastName
        {
            get { return _LastName; }
            set
            {
                SetProperty<string>("LastName", ref _LastName, value);
            }
        }

        private string _NickName;
        public string NickName
        {
            get { return _NickName; }
            set
            {
                SetProperty<string>("NickName", ref _NickName, value);
            }
        }

        private NameSuffix _Suffix;
        public NameSuffix Suffix
        {
            get { return _Suffix; }
            set
            {
                SetProperty<NameSuffix>("Suffix", ref _Suffix, value);
            }
        }

        private string _Title;
        public string Title
        {
            get { return _Title; }
            set
            {
                SetProperty<string>("Title", ref _Title, value);
            }
        }

        public string FullName
        {
            get { return $"{FirstName} {LastName}"; }
        }

        private int _ClientRepId;
        public int ClientRepId
        {
            get { return _ClientRepId; }
            set
            {
                SetProperty<int>("ClientRepId", ref _ClientRepId, value);
            }
        }
    }
}

results = (from p in dc.Persons
            select new PersonEntity
            {
                RemoteId = p.RemoteId,
                ClientRepId = p.ClientRepId ?? 0,
                SupervisorId = p.SupervisorId ?? 0,
                PersonType = (PersonType)p.PersonType ?? PersonType.None,
                Prefix = (NamePrefix)p.Prefix ?? NamePrefix.None,
                FirstName = p.FirstName,
                LastName = p.LastName,
                NickName = p.NickName,
                Suffix = (NameSuffix)p.Suffix ?? NameSuffix.None,
                Title = p.Title,
                CreatedById = p.CreatedById,
                CreatedDT = p.CreatedDT,
                LastModifiedById = p.Id,
                LastModifiedDT = p.ModifiedByDT.Value,
                DeletedById = p.DeletedById,
                DeletedDT = p.DeletedByDT.Value
            }).Where(predicate).ToList();

Prefix = (NamePrefix)p.Prefix ?? NamePrefix.None,

Operator '??' cannot be applied to operands of type 'PersonType' and 'PersonType'