I am currently working on a project that utilizes the DevExpress ASP.NET Core MVC GridView to display a large dataset. To enhance performance and improve the efficiency of data loading and rendering, I am looking to implement server-side pagination in .NET Core.

Could you please provide a code example or guidance on how to achieve server-side pagination with the DevExpress ASP.NET Core MVC GridView in a .NET Core application?

Our code script is here:

@(Html.DevExtreme().DataGrid<DevExtreme.NETCore.Demos.Models.DataGrid.Employee>()
        .ID("gridContainer")
        .ShowBorders(true)
        .Paging(p => p.Enabled(false))
        .Editing(e => e.Mode(GridEditMode.Popup)
            .AllowUpdating(true)
            .AllowAdding(true)
            .AllowDeleting(true)
            .Popup(p => p
                .Title("Employee Info")
                .ShowTitle(true)
                .Width(700)
                .Height(525)
            )
            .Form(f => f.Items(items => {
                items.AddGroup()
                    .ColCount(2)
                    .ColSpan(2)
                    .Items(groupItems => {
                        groupItems.AddSimpleFor(m => m.FirstName);
                        groupItems.AddSimpleFor(m => m.LastName);
                        groupItems.AddSimpleFor(m => m.Prefix);
                        groupItems.AddSimpleFor(m => m.BirthDate);
                        groupItems.AddSimpleFor(m => m.Position);
                        groupItems.AddSimpleFor(m => m.HireDate);

                        groupItems.AddSimpleFor(m => m.Notes)
                            .ColSpan(2)
                            .Editor(editor => editor.TextArea().Height(100));
                    });

                items.AddGroup()
                    .Caption("Home Address")
                    .ColCount(2)
                    .ColSpan(2)
                    .Items(groupItems => {
                        groupItems.AddSimpleFor(m => m.StateID);
                        groupItems.AddSimpleFor(m => m.Address);
                    });
            }))
        )
        .Columns(columns => {
            columns.AddFor(m => m.Prefix)
                .Width(70);

            columns.AddFor(m => m.FirstName);

            columns.AddFor(m => m.LastName);

            columns.AddFor(m => m.BirthDate);

            columns.AddFor(m => m.Position)
                .Width(170);

            columns.AddFor(m => m.HireDate);

            columns.AddFor(m => m.StateID)
                .Width(125)
                .Lookup(lookup => lookup
                    .DataSource(d => d.Mvc().Controller("DataGridStatesLookup").LoadAction("Get").Key("ID"))
                    .DisplayExpr("Name")
                    .ValueExpr("ID")
                );

            columns.AddFor(m => m.Address)
                .Visible(false);

            columns.AddFor(m => m.Notes)
                .Visible(false);
        })
        .DataSource(d => d.Mvc()
            .Controller("DataGridEmployees")
            .LoadAction("Get")
            .UpdateAction("Put")
            .InsertAction("Post")
            .DeleteAction("Delete")
            .Key("ID")
        )
    )

Now we need server side pagination, filtering, searching and sorting functionality in DevExpress v23.1.6. How can we create pagination number using got total record count from the controller and how can we customize our devexpress grid for pagination, filtering, searching and sorting in ASP.NET Core MVC app?