Executing IQueryable list server side with Entity Framework

ekondur

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

allan

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

Allan

ekondur

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.

vpalhories

Good day ...

Any plans to support .NET Core 3.1?

Thanks.

--- Val

allan

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

vpalhories

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

ekondur

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.

ekondur

Hi again,
it support dotnetcore now @vpalhories , you can see details on:
https://datatables.net/forums/discussion/66395/now-on-efdatatable-supports-net-core/p1?new=1

ekondur

This package name changed, look at: DatatableJS