C
C#•2y ago
Cliff Karlsson

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 ?
1 Reply
Unknown User
Unknown User•2y ago
Message Not Public
Sign In & Join Server To View
Want results from more Discord servers?
Add your server
More Posts
Blazor Authentication passes GetAuthenticationStateAsync() three timesSo I've been trying to find a solution, and I don't even know where to start anymore. But here goes.System.Text.Json.Serialize returns emtpy mapHey! 👋 Any idea, why my System.Text.Json-Serialize returns an empty map? ``response = new Response(MAUI Webview target=_blank href redirects not working on androidI have an MAUI app that is essentially a `WebView` that hosts a wordpress website. My problem is tha❔ SQL Server | Can i use 'Case When' in Where Clause?i ususally do it by create the query into the string like this ```sql set @sql = 'select * from pers