Linq query across three levels of tables to generate sum?

Without trying to compile it, I think this will work the way you want. It assumes that you have the associations set up in the LINQ to SQL data context var transPerCategory = db. Categories .

Select( c => new { Name = c. CategoryName, Amount = c. Products .

Sum( p => p. Transactions . Sum( t => t.

TransactionAmount ) ) }).

Without trying to compile it, I think this will work the way you want. It assumes that you have the associations set up in the LINQ to SQL data context. Var transPerCategory = db.

Categories . Select( c => new { Name = c. CategoryName, Amount = c.

Products . Sum( p => p. Transactions .

Sum( t => t. TransactionAmount ) ) }).

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.