Error with GridifyQueryable about gridify HOT 9 CLOSED

With sortBy = null in the model and

      var filteredQuery = query.GridifyQueryable(filter);
      var data = filteredQuery.Query.OrderBy(q => q.StartDate).ToList();

it works.

from gridify.

I'll try to make a repro project.

from gridify.

I successfully reproduced bug in my cleared solution. And after that I decided to update EntityFrameworkCore to a newer bugs patch version. Of course it works )).
So it's my fault and that thing I had to do first.
Thanks for your support.

from gridify.

Hello @vklymchuk, Looks like this is an Entity framework exception. In EF 3.x or up you have some limitations in server-side queries that you need to do on the client-side.

Please add an .OrderBy( q => q.StartDate ) on your query and remove SortBy = "" to make sure this is a Gridify issue not EF one.

from gridify.

//-----------------------------------------------------------------------------------------------------------------//

from gridify.

I am investigating the problem but I have not been able to simulate it yet,

      [Fact]
      public void ApplyOrdering_SortBy_DateTime()
      {
         var gq = new GridifyQuery {SortBy = "MyDateTime", IsSortAsc = true};
         var actual = _fakeRepository.AsQueryable()
            .ApplyOrdering(gq)
            .ToList();
         var expected = _fakeRepository.OrderBy(q => q.MyDateTime).ToList();

         Assert.Equal(expected, actual);
         Assert.Equal(expected.First().Id, actual.First().Id);
      }

what version of EntityFramework are you using?

from gridify.

Microsoft.EntityFrameworkCore 3.1.0

from gridify.

The same situation is in another service with different query. Both have inner joins and some left joins. Both make a new projection of all the tables to a ViewModel.

from gridify.

All Gridify is doing is simply replacing your text representation with an expression, so normally if Gridify generated expression can't be translated by EFCore, normal calls like .OrderBy must have the same problem. the weird part, in this case, is your manual OrderBy is working!
can you provide a small sample of your situation? I need to somehow reproduce the problem to find out what is wrong

from gridify.