Search⌘ K
AI Features

EF Core Like Operations and Global Filters

Explore how to perform pattern matching using EF Core's Like method and implement global filters to automatically exclude discontinued products in your queries. Learn to execute and test these methods, and understand how EF Core 6 enhances querying with functions like Random to refine data retrieval.

Pattern matching with Like

EF Core supports common SQL statements, including Like for pattern matching:

Step 1: In Program.Queries.cs, add a method named QueryingWithLike, as shown in the following code and note:

  • We have enabled logging.

  • We prompt the user to enter part of a product name and then use the EF.Functions.Like method to search anywhere in the ProductName property. ...