Compiling a query results in client side evaluation
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 35/100
Research direction
Start with the provided C# reproduction using EF.CompileQuery and the SQL Server provider, then inspect the generated SQL for the compiled and uncompiled queries. Done means the compiled query produces the expected WHERE clause and no longer evaluates this predicate on the client.
Written by the indexing model from the issue text.
Description
A have a query that references values in a class. This works as expected when the query is not compiled. When the query is compiled it executes on the client. This can be seen by the lack of a where clause in the generated SQL. This works correctly in EF6.
Steps to reproduce
Run the provided code.
class MyKey
{
public string CompanyID;
}
private static void Repro(IceContext db)
{
var key = new MyKey() { CompanyID = "MyValue" };
// Not compiled it correctly evaluates on the server.
var result1 = (from row in db.SysUserComp
where row.Company == key.CompanyID
select row).FirstOrDefault();
// Compiled it evaluates on the client.
Expression<Func<IceContext, MyKey, SysUserComp>> expression =
(ctx, key_ex) =>
(from row in ctx.SysUserComp
where row.Company == key_ex.CompanyID
select row).FirstOrDefault();
var compiledQuery = EF.CompileQuery(expression);
var result2 = compiledQuery(db, key);
}
Further technical details
EF Core version: 2.1.1
Database Provider: Microsoft.EntityFrameworkCore.SqlServer
Operating system: Windows 10
IDE: Visual Studio 2017 15.8.9
- Dominant language
- C#
- Stars
- 14.8k
- Forks
- 3.4k
- Avg merge
- 2d 5h
- Merged PRs (30d)
- 134
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from dotnet/efcore
-
Difficulty 4/5 3-5 days Newbie friendliness 55/100
-
customer-reported
Difficulty 5/5 Over a week Newbie friendliness 38/100
-
area-cosmos area-vector-search
Difficulty 5/5 Over a week Newbie friendliness 25/100
-
area-cosmos
Difficulty 5/5 Over a week Newbie friendliness 25/100
-
area-tools needs-design
Difficulty 4/5 3-5 days Newbie friendliness 25/100
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 86/100
-
:watch: Not Triaged 11.0 fundamentals/subsvc
Difficulty 2/5 1-3 hours Newbie friendliness 92/100
dotnet/AspNetCore.Docs#37699 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
SubtitleEdit/subtitleedit#15108 · 1 comment ·
-
area/docs-content Bug pulumi/docs
Difficulty 1/5 1-3 hours Newbie friendliness 94/100
-
agentic-workflows untriaged
Difficulty 2/5 1-3 hours Newbie friendliness 76/100