Styjun

Would it be fair to use 1d30 (instead of rolling 2d20 and taking the higher die) for advantage rolls?

Does a non-singular matrix have a large minor with disjoint rows and columns and full rank?

Non-African Click Languages

Why is so much ransomware breakable?

What is the velocity distribution of the exhaust for a typical rocket engine?

Is it standard to have the first week's pay indefinitely withheld?

How could it be that 80% of townspeople were farmers during the Edo period in Japan?

Usage of the relative pronoun "dont"

Why does the U.S military use mercenaries?

Solenoid fastest possible release - for how long should reversed polarity be applied?

What color to choose as "danger" if the main color of my app is red

How can we delete item permanently without storing in Recycle Bin?

Is there any deeper thematic meaning to the white horse that Arya finds in The Bells (S08E05)?

Why is vowel phonology represented in a trapezoid instead of a square?

Why do academics prefer Mac/Linux?

Why are lawsuits between the President and Congress not automatically sent to the Supreme Court

Why do galaxies collide?

How long do Aarakocra live?

What formula to chose a nonlinear formula?

Cross products/avoiding using your hand for the right hand rule in E and M

How can I make dummy text (like lipsum) grey?

What is this rubber on gear cables

Cannot remove door knob -- totally inaccessible!

Working hours and productivity expectations for game artists and programmers

Group child list into single parent object - AdventureWorks query - Lambda Expression

Sorting a list using Lambda/Linq to objectsLeft join in Linq?convert a list of objects from one type to another using lambda expressionUsing Linq to group a list of objects into a new grouped list of list of objectsLinq doing a group in a lambda subselectObject grouping with linq or lambda expressionquery list with linq lambda expressionsUsing LINQ to group a list of objectsSelecting decimal and string anonymous types in single LINQ query that's groupedLeft join in linq to entities null error

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I am working with the AdventureWorks database and I am using the following query :

 SELECT c.CustomerID, c.AccountNumber, soh.SalesOrderID, soh.SalesOrderNumber, sod.UnitPrice, sod.ProductID, p.Name
FROM Sales.SalesOrderHeader soh
inner join sales.SalesOrderDetail sod on soh.SalesOrderID = sod.SalesOrderID
inner join sales.Customer c on c.CustomerID = soh.CustomerID
inner join Production.Product p on p.ProductID = sod.ProductID

I have code already that populates the data like this just as it comes back:

Based on that I am wanting to merge the child list objects into a single parent to end up with a one to many structure if that makes sense.

As of right now I am hoping to use a lambda expression to do this. I have tried the following code but I don't want to have to specify --> o.CustomerID, o.AccountNumber in the group by because i would have to specify ALL the properties of my Customer class to have access to the final select as you can see in the code.

 .GroupBy(o => new o.CustomerID, o.AccountNumber ).Select(group => new Customer2
 
 CustomerID = group.Key.CustomerID,
 AccountNumber = group.Key.AccountNumber,
 Orders = group.SelectMany(x => x.Orders).ToList()
 ).ToList();

I would like the end result to look like this for each customer:

I hope this makes sense and thanks in advance for the help.

c# linq group-by

share|improve this question

asked Mar 23 at 16:36

derralderral

5119

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What should the output look like ?
  
  – Kunal Mukherjee
  Mar 23 at 17:21
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It should look like the last image. Each customer should have a list of all their orders.
  
  – derral
  Mar 23 at 17:28
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  your code seems to be fine, now what does not work correctly?
  
  – Ashkan Mobayen Khiabani
  Mar 23 at 22:04
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I don't want to have to specify each object like customerid and accountnumber in the groupby in order to have access to them in the final select
  
  – derral
  Mar 23 at 23:12
  

  
  
  
  

add a comment | 

0

I am working with the AdventureWorks database and I am using the following query :

 SELECT c.CustomerID, c.AccountNumber, soh.SalesOrderID, soh.SalesOrderNumber, sod.UnitPrice, sod.ProductID, p.Name
FROM Sales.SalesOrderHeader soh
inner join sales.SalesOrderDetail sod on soh.SalesOrderID = sod.SalesOrderID
inner join sales.Customer c on c.CustomerID = soh.CustomerID
inner join Production.Product p on p.ProductID = sod.ProductID

I have code already that populates the data like this just as it comes back:

Based on that I am wanting to merge the child list objects into a single parent to end up with a one to many structure if that makes sense.

As of right now I am hoping to use a lambda expression to do this. I have tried the following code but I don't want to have to specify --> o.CustomerID, o.AccountNumber in the group by because i would have to specify ALL the properties of my Customer class to have access to the final select as you can see in the code.

 .GroupBy(o => new o.CustomerID, o.AccountNumber ).Select(group => new Customer2
 
 CustomerID = group.Key.CustomerID,
 AccountNumber = group.Key.AccountNumber,
 Orders = group.SelectMany(x => x.Orders).ToList()
 ).ToList();

I would like the end result to look like this for each customer:

I hope this makes sense and thanks in advance for the help.

c# linq group-by

share|improve this question

asked Mar 23 at 16:36

derralderral

5119

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What should the output look like ?
  
  – Kunal Mukherjee
  Mar 23 at 17:21
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It should look like the last image. Each customer should have a list of all their orders.
  
  – derral
  Mar 23 at 17:28
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  your code seems to be fine, now what does not work correctly?
  
  – Ashkan Mobayen Khiabani
  Mar 23 at 22:04
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I don't want to have to specify each object like customerid and accountnumber in the groupby in order to have access to them in the final select
  
  – derral
  Mar 23 at 23:12
  

  
  
  
  

add a comment | 

I am working with the AdventureWorks database and I am using the following query :

 SELECT c.CustomerID, c.AccountNumber, soh.SalesOrderID, soh.SalesOrderNumber, sod.UnitPrice, sod.ProductID, p.Name
FROM Sales.SalesOrderHeader soh
inner join sales.SalesOrderDetail sod on soh.SalesOrderID = sod.SalesOrderID
inner join sales.Customer c on c.CustomerID = soh.CustomerID
inner join Production.Product p on p.ProductID = sod.ProductID

I have code already that populates the data like this just as it comes back:

Based on that I am wanting to merge the child list objects into a single parent to end up with a one to many structure if that makes sense.

As of right now I am hoping to use a lambda expression to do this. I have tried the following code but I don't want to have to specify --> o.CustomerID, o.AccountNumber in the group by because i would have to specify ALL the properties of my Customer class to have access to the final select as you can see in the code.

 .GroupBy(o => new o.CustomerID, o.AccountNumber ).Select(group => new Customer2
 
 CustomerID = group.Key.CustomerID,
 AccountNumber = group.Key.AccountNumber,
 Orders = group.SelectMany(x => x.Orders).ToList()
 ).ToList();

I would like the end result to look like this for each customer:

I hope this makes sense and thanks in advance for the help.

c# linq group-by

share|improve this question

asked Mar 23 at 16:36

derralderral

5119

 SELECT c.CustomerID, c.AccountNumber, soh.SalesOrderID, soh.SalesOrderNumber, sod.UnitPrice, sod.ProductID, p.Name
FROM Sales.SalesOrderHeader soh
inner join sales.SalesOrderDetail sod on soh.SalesOrderID = sod.SalesOrderID
inner join sales.Customer c on c.CustomerID = soh.CustomerID
inner join Production.Product p on p.ProductID = sod.ProductID

 .GroupBy(o => new o.CustomerID, o.AccountNumber ).Select(group => new Customer2
 
 CustomerID = group.Key.CustomerID,
 AccountNumber = group.Key.AccountNumber,
 Orders = group.SelectMany(x => x.Orders).ToList()
 ).ToList();

share|improve this question

asked Mar 23 at 16:36

derralderral

5119

share|improve this question

asked Mar 23 at 16:36

derralderral

5119

asked Mar 23 at 16:36

derralderral

5119

asked Mar 23 at 16:36

derralderral

5119