Executing IQueryable list server side with Entity Framework

Executing IQueryable list server side with Entity Framework

ekondurekondur Posts: 8Questions: 0Answers: 0

This extension provides you to execute Datatable js request on Entity Framework IQueryable queries.
With "ToDataResult(request)" extension function, data can get with server side pagination very simply.

public JsonResult GetDataResult(DataRequest request)
    {
        DataResult result = context.People.ToDataResult(request);
        return Json(result);
    }

Install the package and use it;

$ Install-Package EFDatatable.Data -Version 1.1.0

If you have MVC project you can also use this helper

Replies

  • allanallan Posts: 61,438Questions: 1Answers: 10,052 Site admin

    Just to confirm, is this the package you are referring to? It looks really useful!

    Allan

  • ekondurekondur Posts: 8Questions: 0Answers: 0

    Yes it is, thank you Allan.
    This version I've seperated helper and entitiy framework extension. So, it is executable datable js requests on EF context without using my helper.

  • vpalhoriesvpalhories Posts: 13Questions: 5Answers: 0

    Good day ...

    Any plans to support .NET Core 3.1?

    Thanks.

    --- Val

  • allanallan Posts: 61,438Questions: 1Answers: 10,052 Site admin

    Editor's .NET libraries support .NET Core 3.1. We do not yet support EF though, which is what this thread was originally asking.

    Are you having problems using Editor with.NET Core 3.1?

    Allan

  • vpalhoriesvpalhories Posts: 13Questions: 5Answers: 0

    Hey @allan,

    Sorry for the late response. In answer to your question, yes, I'm having issues. I get the following when I retrieve the NuGet package:

    Package 'EFDatatable 1.2.1' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8' instead of the project target framework '.NETCoreApp,Version=v3.1'. This package may not be fully compatible with your project.
    Checking compatibility of packages on .NETCoreApp,Version=v3.1.

    That package is obviously for .NET. I was looking for .NETCore version.

    Thanks.

    --- Val

  • ekondurekondur Posts: 8Questions: 0Answers: 0

    Hi @vpalhories ,
    Only EFDatatable.Data package supports .netcore. so you can use it just for data retreive.
    Install-Package EFDatatable.Data not EFDatatable. EFDatatable package has helper for client. I will also release core version for client soon.
    Regards.

  • ekondurekondur Posts: 8Questions: 0Answers: 0
    edited January 2021
  • ekondurekondur Posts: 8Questions: 0Answers: 0

    This package name changed, look at: DatatableJS

Sign In or Register to comment.