Case sensitive comparison

[rodbeck]

Description

Hi,

By default, the lambda expression m => m.Title!.Contains(TitleFilter ?? string.Empty) is case sensitive, at least, nothing was returned when I searched for "road" or "road warrior" but movies were returned when I searched for "Road" for example.

I had to update the lambda expression to: context.Movie.Where(m => m.Title!.ToLower().Contains((TitleFilter ?? string.Empty).ToLower())); for it to work properly with the lowercase search.

Thanks!

Page URL

https://learn.microsoft.com/en-gb/aspnet/core/blazor/tutorials/movie-database-app/part-6?view=aspnetcore-9.0

Content source URL

https://github.com/dotnet/AspNetCore.Docs/blob/main/aspnetcore/blazor/tutorials/movie-database-app/part-6.md

Document ID

6d15bd42-ea91-ec59-1ebc-185653dc7ef4

Platform Id

bc8a6fac-a9c8-44e8-4883-26b69c934483

Article author

@guardrex

Metadata

• ID: 6d15bd42-ea91-ec59-1ebc-185653dc7ef4
• PlatformId: bc8a6fac-a9c8-44e8-4883-26b69c934483
• Service: aspnet-core
• Sub-service: blazor

Related Issues

[github-actions]

🏖️🌞 Summertime!! Woot!! 🏐⛵

Stand-by! ... A green dinosaur 🦖 will be along shortly to assist.

[guardrex]

Hello @rodbeck ... There's a section in the article that explains what's going on ...

The Contains method is run on the database, not in the C# code. The case sensitivity of the query depends on the database and the collation. For SQL Server, Contains maps to SQL LIKE, which is case insensitive. SQLite with default collation provides a mixture of case sensitive and case insensitive filtering, depending on the query. For information on making case insensitive SQLite queries, see the Additional resources section of this article.

Then, the links are down in the Additional resources section for more information ...

https://learn.microsoft.com/aspnet/core/blazor/tutorials/movie-database-app/part-6?view=aspnetcore-9.0&pivots=vs#additional-resources

[guardrex]

Actually, I think I will make a change where the examples are pegged to lowercase. That will at least make it clearer that the behavior depends on case sensitivity.