dotnet / dotnet/EntityFramework.Docs

Write an EF Core FAQ or similar

Open
#3,274 6 comments 0 reactions 0 assignees View on GitHub
area-global
Dominant language
Mermaid
Stars
1.7k
Forks
2k
Avg merge
7d 23h
Merged PRs (30d)
16

Description

Like many developers, I understand the gist of the message `The LINQ expression could not be translated..` but it does not say which part of the expression doesn't work and the page also does not describe why some things work fine in C# but do not in VB.net.

For example, I have a where clause that does this (which works in C#)

`.Where(m => m.Email.ToLower() == model.Email.ToLower().Trim() && m.Deleted == false)`

(Deleted is nullable). When I try the same in VB.Net, even after removing the model.Email.ToLower().Trim(), I get the error about it not being able to run on the server. This is a table with 100s of 1000s of rows so I cannot run it in the client.

It would be nice to explain some of these issues in the article.

---
#### Document details

⚠ *Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.*

* ID: fd35b912-445c-e801-7f70-de73839db80d
* Version Independent ID: e558a081-5397-1e3f-1d58-abea3f72cad6
* Content: [Client vs. Server Evaluation - EF Core](https://docs.microsoft.com/en-gb/ef/core/querying/client-eval)
* Content Source: [entity-framework/core/querying/client-eval.md](https://github.com/dotnet/EntityFramework.Docs/blob/main/entity-framework/core/querying/client-eval.md)
* Product: **entity-framework**
* Technology: **entity-framework-core**
* GitHub Login: @smitpatel
* Microsoft Alias: **avickers**

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.