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 (#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()