Excel

Results 4 comments of Excel

Not sure if this is the same cause, but I also ran into a `NullReferenceException` in the `SqlNullabilityProcessor`. My query is roughly like this: ``` private async Task GetData(string? userId,...

> Are you sure about that, how are you seeing that? valuesExpression should correspond to `ids` variable in your query (the instance on which Contains is being called). SQL databases...

Reproduced. Looks like query splitting is a prerequisite. Program.cs: ```cs using Microsoft.EntityFrameworkCore; using Microsoft.Extensions.DependencyInjection; namespace QueryTest; internal static class Program { private static async Task Main() { using ServiceProvider services...

For the record, the reason we were doing `Select` > `ToListAsync` > `ToDictionary` instead of just `ToDictionaryAsync` is because the `ToDictionaryAsync` query wouldn't translate, but this version appeared to work...