dotnet / dotnet/EntityFramework.Docs

Local queries are case sensitive

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

Description

Hi,

In working with local view of my data, I discovered an inconsistency. I wasn't able to find any documentation regarding this. Is this a bug or is it by design somehow?

```C#
dbContext.Platforms.SingleOrDefault(p => p.Id == "beleco").ShouldNotBeNull();
dbContext.Platforms.SingleOrDefault(p => p.Id == "Beleco").ShouldNotBeNull();
dbContext.Platforms.Load();
dbContext.Platforms.Local.SingleOrDefault(p => p.Id == "beleco").ShouldNotBeNull();
dbContext.Platforms.Local.SingleOrDefault(p => p.Id == "Beleco").ShouldNotBeNull(); // Fails!
```

EF Core version: 5.0.11
Database provider: Microsoft.EntityFrameworkCore.SqlServer
Target framework: .NET 5.0
Operating system: Windows
IDE: Jetbrains Rider 2021.2.1

Thanks!

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.