How do I get all DbSets from a Context ? - C#

C#•4y ago•

1 reply

How do I get all DbSets from a Context ?

I have multiple DbSets where I query each set and parse the results like this:

  var result1 = _context.EXT_PRAMET_INSERTS.Where(x => x.MaterialID == MaterialID).ToList();
  var result2 = _context.EXT_DORMER.Where(x => x.MaterialID == MaterialID).ToList();
...

  var result1 = _context.EXT_PRAMET_INSERTS.Where(x => x.MaterialID == MaterialID).ToList();
  var result2 = _context.EXT_DORMER.Where(x => x.MaterialID == MaterialID).ToList();
...

How can I do the same using a loop where I iterate over each DbSet in the Context and use a query ?