Adding AsEnumerable will pull the entire table - is that really what you want. Rewrite the query so it can be evaluated on the server.
Linq Error when migrate entityframeworkcore 2.2 to 3.0
Hello,
i am migrating from netcore 2.1 to 3.1. of a solution hosted on Azure.
I have encountered many errors due to entityframeworkcore 3.
Queries such as DBe.BmsListaInfrastructure.Where (e => e.Amministration == Administration) .ToList ();
they create errors!
The solution is to insert AsEnumerable () (DBe.BmsListaInfrastructure.AsEnumerable (). Where (e => e.Amministrazioni == Administration) .ToList ();)
Do I have to change them all or is there a quick way to adapt them?
Thanks
2 answers
Sort by: Most helpful
-
-
Marco Salvatori 191 Reputation points
2020-12-17T14:25:01.817+00:00 is there a way to not rewrite the queries?
I have many ... I should retest everything ...
the problem is with 'singleordefault'...