QueryObjects and filtering by fields from the linked tables

• EfCoreinAction-SecondEdition

  2 360 0.0 C#

  Supporting repo to go with book "Entity Framework Core in Action", second edition

I want to write a filter like here /BookServices/QueryObjects/BookListDtoFilter.cs (Query Object pattern) but applying to my situation. I have a Course table, which is linked to tables Module and Instructors as Course-Instructors like Many to one and Course to Modules like One- to- Many. One Module might have many videos (one -to - many). I need to filter courses by Instructor and by the Duration. How would i achieve that? I think that at first I probably need to alter CourseDTO class to include fields of interest there (Duration and Instructor's name) to be able to fill in them through linq queries in subsequent stages?

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project