Recording of my lectures at HTL Leonding 2021/22. You can find the course material on GitHub at https://github.com/rstropek/htl-leo-pro-5.
This week, we dive deeper into various aspects of Entity Framework Core. In the second hour, we implement a search API using C# LINQ with Entity Framework Core. Next, we implement the same functionality with raw SQL to learn how we could optimize SQL queries manually. The sample referenced in the video can be found at https://github.com/rstropek/htl-leo-pro-5/tree/master/homeworks/0300-search-api.
00:00:00 Intro
00:00:17 Preparing the project for adding the search logic
00:04:01 Building the search query with LINQ
00:10:12 Optimizing result using a query type
00:18:44 Building the search query using SQL
00:30:31 Wrapping up
