Sql – linq2SQL + sum–Summing into results

linq-to-sql

I have a bunch of incidences in a table that are linked to a supplier

I need to sum the serverity score for those incidences by supplier

So basicly have
supplier1: 500
supplier2: 600

How do I do this?

DataAccess.IncidentRepository().GetItems().Where(i => i.IncidentDate.Year == 2006)

Best Answer

Hope this helps

DataAccess.IncidentRepository().GetItems()
          .Where(i => i.IncidentDate.Year == 2006)
          .GroupBy(i => i.Supplier)
          .Select(pGroup => 
                  new { Supplier = pGroup.Key, 
                        Score = pGroup.Sum(pArg => pArg.SeverityScore) });

Related Solutions

C# – Linq2sql inheritance cast

I am wondering why you even have the two different sub classes if it is a natural situation that you want to change from one type to the other. I think that you should refactor what you have and make the buyer and supplier one entity. Then if you have behavior that should be different based on whether or not the client is a buyer or supplier I would extract that into a seperate object which you can set or add to the client.

C# – Issue with Linq2sql query

I have no idea if this will work or not, but try changing:

let order = supplier==null
               ? null
               : e.Orders.Where(f => f.ClientId.Equals(supplier.Id))
                         .FirstOrDefault()

let order = e.Orders.Where( f => supplier != null
                                 && f.ClientId.Equals(supplier.Id) )
                    .FirstOrDefault()

since you say it works when the second part is evaluated.

Best Answer

Related Solutions

C# – Linq2sql inheritance cast

C# – Issue with Linq2sql query

Related Topic