C#•2y ago

[EF Core/LINQ] Paginated Eager-Loaded One-to-Many

I can't seem to find (maybe my Googling is bad) the proper way - if it's possible - to limit the returns of an eager-loaded one-to-many collection.

var form = DbContext.Forms
  .Find(1)
  .Include(form => form.Submission);

var form = DbContext.Forms
  .Find(1)
  .Include(form => form.Submission);

var form = DbContext.Forms
  .Find(1)
  .Include(form => form.Submission);

var form = DbContext.Forms
  .Find(1)
  .Include(form => form.Submission);

In my case a form could have millions of them - is it possible to limit the data fetched via .Include()? Similar to how Take() and Skip() work on the main query?

[EF Core/LINQ] Paginated Eager-Loaded One-to-Many

Similar Threads

Similar Threads

Similar Threads