I have an object containing Projects. For example containing only 1 Project.
Then there are two other objects containing “Names” and “Identifiers” and there are multiple Identifiers and multiple Names for the same Project.
I want to map/query all into one object/table.
And I dont want to loop any table for example to add an enumerator to the keys because of performance and maintainability.
I want to do that in C# and preferable with LINQ.
The “objects” can be anything you like. Lists, DataTables, IQueryable, …
Originally, the “objects” come out of DbSets in a DbContext, so initially the “objects” are each a DbSet.
The solution shall be able to scale to multiple projects and to more then three tables/objects. So with objects containing “Descriptions”, “Durations”, “Dates”, “States”, …
Is this possible without looping to enumerate?

I tried .union, .selectmany, .zip, .concat, .groupby and looping the tables to add an enumerator to the keys.