From the course: Practical Application Architecture with Entity Framework Core
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Queryable - Entity Framework Tutorial
From the course: Practical Application Architecture with Entity Framework Core
Queryable
- [Instructor] The Queryable Interface is the heart of LINQ. It allows us to easily build complex queries against the database. It also has some significant limitations and some places of concern that need to be covered. It is extremely flexible, but it can hide things from an application developer that might cause bugs or performance issues later on. It is good due to the level of flexibility that exists. Complex queries can be built in length very quickly without the need for a separate method, especially for one-use queries. It is bad for the same reason. Some complex queries will fail against the database because the functionality doesn't exist, in LINQ to Entities, which is the translation from LINQ to T-SQL that gets executed against the database. Let's look at an example of this. We'll start by adding a new method to the Order Service Interface, get last month's orders. Task, IlistOrder, Get Last Months Orders. Save the file and we'll add the implementation in the order…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.