This question already has answers here:

EF Core error Incorrect syntax near '$' but EF Core generated the query? (2 answers)
Closed last month.

I decided to switch my project from .NET6 to .NE 8 . My project database is SQL Server 2016.

At first everything was going well, but I ran into a bug:

var seferIds = tList.expedition.Select(r => r.Key).ToArray();
var sql = (from h in context.Line
           join v in context.Route on h.id equals v.lineId
           join s in context.Expedition on v.id equals s.routeId
           where seferIds.Contains(s.id)
           select new { h, v, s })
          .ToDictionary(r => r.s.id);

In this way, I cannot use Contains() in Linq queries I created with my database tables ( AsQueryable ).

I did some research and if I define it as

where seferIds.AsQueryable().Contains(s.id)

the error disappears. At the same time, I need to do an empty check in the form of seferIds.Any() in my code.

I looked to see if I would get the same error using SQL Server 2019 as the database and where seferIds.Contains(s.id) works there without any problems and there is no error.

As for my question, is this problem that .net8 is no longer compatible with the old database version? Is there another situation that I missed.

I would like to know if there is a different solution for this error.