millibyte
millibyte
PostsComments
CC#
Created by A Ka Sup on 2/15/2025 in #help
Left join 2 or more tables with 1-n relationship
I misunderstood. What do you actually want the data coming out to look like? Do you want A x 1 result rows like { IEnumerable<B.Stuff>, IEnumerable<C.Stuff2> }, or do you want to actually join every B against every C with a shared A?
7 replies
CC#
Created by A Ka Sup on 2/15/2025 in #help
Left join 2 or more tables with 1-n relationship
https://learn.microsoft.com/en-us/ef/core/modeling/relationships/navigations
7 replies
CC#
Created by A Ka Sup on 2/15/2025 in #help
Left join 2 or more tables with 1-n relationship
Going up from the many side to the 1 side of a relationship like this is generally a lot easier to express than drilling down in LINQ. In SQL, it’s the same JOINs either way
7 replies
CC#
Created by A Ka Sup on 2/15/2025 in #help
Left join 2 or more tables with 1-n relationship
context.TableC.Select(c => new { c.Stuff2, c.A.B.Stuff })
context.TableC.Select(c => new { c.Stuff2, c.A.B.Stuff })
7 replies
CC#
Created by A Ka Sup on 2/15/2025 in #help
Left join 2 or more tables with 1-n relationship
If you’re using Entity Framework — the idiomatic way is to use navigation properties to implicitly do the joins
7 replies
CC#
Created by Utku on 12/9/2024 in #help
Any way at all to make a button click action in multiple tabs at the same time in selenium?
I don't think you will be able to do this without switching tabs. Selenium requires focus for UI interactions just like regular browser usage I would investigate why it's slow for you to switch tabs -- run in headless if possible, check for reported performance issues with your version, etc.
3 replies