Comment by klysm

LINQ is nice, but EF Core has some significant limitations and forces you down some pretty sub optimal design paths.