Precompiled Queries fail for captured parameters

[vancodocton]

Type of issue

Code doesn't work

Description

Hello.

I tried to use precompiled queries in EF9 by following the instructions in this page. However, it always end up with:

    D:\packages\NuGet\cache\microsoft.entityframeworkcore.tasks\9.0.3\buildTransitive\Microsoft.EntityFrameworkCore.Tasks.targets(93,5): error : Query precompilation failed with errors:
    D:\packages\NuGet\cache\microsoft.entityframeworkcore.tasks\9.0.3\buildTransitive\Microsoft.EntityFrameworkCore.Tasks.targets(93,5): error : QueryPrecompilationError { SyntaxNode = context.Todos.OrderBy(b => b.Id).AsAsyncEnumerable(), Exception = System.InvalidOperationException: Dynamic LINQ queries are not supported when precompiling queries. }
    D:\packages\NuGet\cache\microsoft.entityframeworkcore.tasks\9.0.3\buildTransitive\Microsoft.EntityFrameworkCore.Tasks.targets(93,5): error :

when I run dotnet publish -r win-x64 -o publish

Here is my minimal repro:
https://github.com/vancodocton/NativeAot/tree/9813f8ec755f6149bc9209a54b288e44d2f89f5f

Page URL

https://learn.microsoft.com/en-us/ef/core/performance/nativeaot-and-precompiled-queries

Content source URL

https://github.com/dotnet/EntityFramework.Docs/blob/main/entity-framework/core/performance/nativeaot-and-precompiled-queries.md

Document Version Independent Id

d0be1f4d-9f8a-2547-ce96-8ed38a4be225

Platform Id

134032fb-f272-255a-1b6a-4858e71e1c88

Article author

@roji

[roji]

This issue is lacking enough information for us to be able to fully understand what is happening. Please attach a small, runnable project or post a small, runnable code listing that reproduces what you are seeing so that we can investigate.

[vancodocton]

This issue is lacking enough information for us to be able to fully understand what is happening. Please attach a small, runnable project or post a small, runnable code listing that reproduces what you are seeing so that we can investigate.

Here is it https://github.com/vancodocton/NativeAot.

I cannot publish successfully.

P/s: I've attached the repo link in the issue's description before. @roji

[PatrickNies]

Is there any news on this isue?

I've same issue with my queries.

[roji]

Due to other priorities we've not yet had time to investigate this (keep in mind that NativeAOT support is experimental and so bugfixes on it aren't top priority at the moment).

[KLuuKer]

@roji what he means is...
like me he is literally following the docs > https://learn.microsoft.com/en-us/ef/core/performance/nativeaot-and-precompiled-queries

trying to write a query EXACTLY the same as in the docs (but without the filter i guess like me)

IAsyncEnumerable<Blog> GetBlogs(BlogContext context)
    => context.Blogs.OrderBy(b => b.Id).AsAsyncEnumerable();

and this command that will compile the query+model
dotnet ef dbcontext optimize --precompile-queries --nativeaot

just throws a error with
QueryPrecompilationError { SyntaxNode = context.Blogs.OrderBy(b => b.Id).AsAsyncEnumerable(), Exception = System.InvalidOperationException: Dynamic LINQ queries are not supported when precompiling queries. }

i tried this with both .net 9.0.7 and the .net 10 preview 5

having set all the things correctly in the csproj

<PropertyGroup>
    <PublishAot>true</PublishAot>
    <InterceptorsNamespaces>$(InterceptorsNamespaces);Microsoft.EntityFrameworkCore.GeneratedInterceptors</InterceptorsNamespaces>
</PropertyGroup>
<ItemGroup>
  <PackageReference Include="Microsoft.EntityFrameworkCore.Tasks" Version="9.0.7">
    <PrivateAssets>all</PrivateAssets>
    <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
  </PackageReference>
  <PackageReference Include="Microsoft.CodeAnalysis.CSharp.Workspaces" Version="4.13.0" />
  <PackageReference Include="Microsoft.CodeAnalysis.Workspaces.MSBuild" Version="4.13.0" />
</ItemGroup>

[roji]

@KLuuKer I understand, but as I wrote we're currently prioritizing other things, and I likely won't have time to look at this in the coming weeks.

[SamMonoRT]

"Exception = System.InvalidOperationException: Dynamic LINQ queries are not supported when precompiling queries. }

Dynamic LINQ query support wasn't added in 9.0 for NativeAOT.

[jksware]

"Exception = System.InvalidOperationException: Dynamic LINQ queries are not supported when precompiling queries. }

Dynamic LINQ query support wasn't added in 9.0 for NativeAOT.

The query is indeed static, not dynamic.

IAsyncEnumerable<Blog> GetBlogs(BlogContext context)
    => context.Blogs.OrderBy(b => b.Id).AsAsyncEnumerable();

The issue seems to happen while trying to capture outer variables, since a simple workaround solves it:

static IAsyncEnumerable<Todo> GetAllTodosAsync(AppDbContext context)
{
    var localContext = context;
    return localContext.Todos.OrderBy(b => b.Id).AsAsyncEnumerable();
}

This compiles. And runs as intended if InvariantGlobalization is changed to false in the project settings.

The same is true for captures inside lambdas.

[roji]

Thanks for the additional information @jksware, that's helpful. IIRC I specifically worked (and tested) this for captures inside lambdas, so that's a bit surprising (but definitely possible).

In any case, am putting as a bug in the backlog - at some point we'll probably do a further push on NativeAOT support.