C# Entity Framework Core - OrderBy and Where don't work with `[ComplexType]`

[Andrey-2021]

project: https://github.com/Andrey-2021/RadzenDataGrid use MsSQL + Entity Framework Core

1. Description

When I don't use OrderBy the program is work. But When I use OrderBy i Have Exception in method protected async Task OnLoadDataAsync(LoadDataArgs args) OrderBy and Where don't work with [ComplexType]

first class:

public class PriceListService
{
    [Key]
    public int Id { get; set; }

    [Required]
    public PriceListServiceBase ServiceBase { get; set; } = new();
}

second class:

[ComplexType]
public class PriceListServiceBase
{
    public int Index { get; set; }
    public string? Code { get; set; }
    public string? ServiceName { get; set; }
}

2. Exception

Exception: Comparing complex types to null is not supported. I see in line query = query.OrderBy(args.OrderBy); args.OrderBy = 'np(ServiceBase.Index) desc'

3. Fiddle or Project

https://github.com/Andrey-2021/RadzenDataGrid

To Reproduce Steps to reproduce the behavior:

1. Load project https://github.com/Andrey-2021/RadzenDataGrid
2. Config db connection string 'DefaultConnection' in appsettings.json
3. Run project
4. Click button 'First step -> Add Data to Db'
5. try sort column Index or Code or Name in RadzenDataGrid we get an error: Exception: Comparing complex types to null is not supported.

[StefH]

Hello @Andrey-2021,

I did add your test project in this PR (https://github.com/zzzprojects/System.Linq.Dynamic.Core/pull/780) and when running on a InMemory database, it works fine. Can you use this example and connect it to your real database?

[Andrey-2021]

Hi! I connected real db, please reload progect from https://github.com/Andrey-2021/RadzenDataGrid

Yes, OrderBy work when I use List in memory instead of a real database. But I have error with real MsSQL DataBase

[StefH]

@Andrey-2021 I did use your connection-string in my PR, and it still works fine?

[Andrey-2021]

an Exception occurs when it is necessary to sort, try to sort the columns: Index or Code or Name

[StefH]

Please use my solution in the PR:

[Andrey-2021]

Thank you very much!!!!!!!!!!!!!! Ity's work with the setup using OwnsOne()