public class FoodViewModel
{
    public int? Id { get; set; }
 
    [Query, StringLength(64, MinimumLength = 2) Required, 
        Display(Name ="name")]
    public string ProductName { get; set; }
 
    [Query, StringLength(32, MinimumLength = 2), Required,
        Display(Name = "package type")]
    public string Package { get; set; }
    [Range(0, 1000), Query,
        Display(Name = "unit price")]
    public decimal UnitPrice { get; set; }
    [Display(Name = "discontinued")]
    public bool IsDiscontinued { get; set; }
    [Query,
        Display(Name = "supplier")]
    public int SupplierId { get; set; }
    [Query,
        Display(Name = "supplier")]
    public string SupplierCompanyName { get; set; }
 
}
[RunTimeType]
public class FoodViewModelGrouping: FoodViewModel
{
    public int SupplierIdCount { get; set; }
    public int PackageCount { get; set; }
 
 
}

public class FoodController: ServerCrudController<FoodViewModel, FoodViewModel, int?>
{
    public FoodController(FoodRepository repository, 
            IStringLocalizerFactory factory, IHttpContextAccessor accessor, 
            IWebQueryProvider queryProvider) :
        base(factory, accessor)
    {
            
        Repository = repository;
        this.queryProvider = queryProvider;
    }
 
    public IWebQueryProvider queryProvider { get; private set; }
 
    public async Task<IActionResult> IndexInLine()
    {
        var query = queryProvider.Parse<FoodViewModel>();
 
        int pg = (int)query.Page;
        var grouping = query.GetGrouping<FoodViewModelGrouping>();
 
        var model = new FoodListViewModel
        {
            Query = query,
            Products =
                grouping == null ?
                    await Repository.GetPage(
                        query.GetFilterExpression(),
                        query.GetSorting() ??
                            (q => q.OrderBy(m => m.ProductName)),
                        pg, 5)
                    :
                    await Repository.GetPageExtended(
                        query.GetFilterExpression(),
                        query.GetSorting<FoodViewModelGrouping>() ??
                            (q => q.OrderBy(m => m.ProductName)),
                        pg, 5,
                        query.GetGrouping<FoodViewModelGrouping>())
        };
 
        return View(model);
    }
 
    [HttpGet]
    public async Task<ActionResult> GetSuppliers(string search)
    {
        var res = search == null || search.Length < 3 ?
            new List<AutoCompleteItem>() :
            await (Repository as FoodRepository).GetSuppliers(search, 10);
        return Json(res);
    }
}

tfoot .pagination, thead .pagination 
    {
        margin: 0;
        display: inline !important;
    }

public class FoodRepository : DefaultCRUDRepository<ApplicationDbContext, Food>
{
    private ApplicationDbContext db;
    public  FoodRepository(ApplicationDbContext db):
        base(db, db.Foods)
    {
        this.db = db;
    }
    public async Task<IEnumerable<AutoCompleteItem>> 
        GetSuppliers(string search, int maxpages)
    {
        return (await DefaultCRUDRepository.Create(db, db.Suppliers)
                .GetPage<AutoCompleteItem>(m => m.Display.StartsWith(search),
                m => m.OrderBy(n => n.Display), 1, maxpages))
                .Data;
    }
    static FoodRepository()
    {
        DefaultCRUDRepository<ApplicationDbContext, Supplier>
            .DeclareProjection(m => new AutoCompleteItem
            {
                Display = m.CompanyName,
                Value = m.Id
            });
    }