EF Linq Error after change from dotnet Core 2.2.6 to 3.0.0

by

The reason is that implicit client evaluation has been disabled in EF Core 3.

What that means is that previously, your code didn’t execute the WHERE clause on the server. Instead, EF loaded all rows into memory and evaluated the expression in memory.

To fix this issue after the upgrade, first, you need to figure out what exactly EF can’t translate to SQL. My guess would be the call to GetValueOrDefault(), therefore try rewriting it like this:

.Where(x => x.BirthDate != null && x.BirthDate.Value.Month == DateTime.Now.Month)

More Related Contents:

  1. What are the correct version numbers for C#?
  2. AddTransient, AddScoped and AddSingleton Services Differences
  3. How do I get .NET Core projects to copy NuGet references to the build output?
  4. Using app.config in .Net Core
  5. How should I inject a DbContext instance into an IHostedService?
  6. Filter all queries (trying to achieve soft delete)
  7. Hangfire – Multi tenant, ASP.NET Core – Resolving the correct tenant
  8. How to add the same column to all entities in EF Core?
  9. Using Razor outside of MVC in .NET Core
  10. How to validate signature of JWT from jwks without x5c
  11. JWT on .NET Core 2.0
  12. Determine Operating System in .NET Core
  13. Publish .NET Core App As Portable Executable
  14. .NET Core and System.Drawing
  15. Inject service into Action Filter
  16. The SSL connection could not be established
  17. How to set json serializer settings in asp.net core 3?
  18. Replace service registration in ASP.NET Core built-in DI container?
  19. How do I resolve the issue the request matched multiple endpoints in .Net Core Web Api
  20. Entity Framework Core: `SqlNullValueException: Data is Null.` How to troubleshoot?
  21. Dependency Injection with classes other than a Controller class
  22. BeginInvoke not supported on .NET core? (PlatformNotSupported exception)
  23. How to get user information in DbContext using Net Core
  24. How should I manage DbContext Lifetime in MVC Core?
  25. .NET Core equivalent to Thread.Abort
  26. Net Core: Execute All Dependency Injection in Xunit Test for AppService, Repository, etc
  27. How to globally set default options for System.Text.Json.JsonSerializer?
  28. Reference external DLL in .NET Core project
  29. What Nuget packages must be referenced by an ASP.NET Core 6 application parts project
  30. No service for type ‘Microsoft.AspNetCore.Identity.UserManager`1[Microsoft.AspNetCore.Identity.IdentityUser]’ has been registered

Leave a Comment