CodePaste Logo
New Snippet New Snippet Recent Snippets Recent Snippets My Snippets My Snippets Web Code Search Snippets Search
Sign inor Register
Language: C#

LINQ - Transpose / Sum of Multiple Columns

550 Views
Copy Code Show/Hide Line Numbers
var results = 
    from e in exposureGrouping
    group e by new { e.Category, e.Area } into g
    orderby g.Key.Category, g.Key.Area
    select new WorldwideExposure
    {
        Category = g.Key.Category,
        Area = g.Key.Area,
        Open_Market = g.Where(x => x.ClassCode == "OM").Sum(x => x.Usd_Gross_Exposure),
        North_American_Binders = g.Where(x => x.ClassCode == "NA").Sum(x => x.Usd_Gross_Exposure),
        MI_And_Reo = g.Where(x => x.ClassCode == "MI").Sum(x => x.Usd_Gross_Exposure),
        Other = g.Where(x => x.ClassCode == "OT").Sum(x => x.Usd_Gross_Exposure),
        Total = g.Sum(x => x.Usd_Gross_Exposure)
    };
by Cat
  June 16, 2010 @ 1:47am
Tags:

Add a comment


Report Abuse
brought to you by:
West Wind Techologies



If you find this site useful and use it frequently please consider making a donation to support this free service.
Donate