Linq to SQL Sum without group into

Question

I have something like this   var itemsInCart   from o in db OrderLineItems                   where o OrderId    currentOrder OrderId                   select new   o OrderLineItemId            o WishListItem Price    is there any way to do a   itemsCart Sum     not sure what to pass into the function   to get the sum of o WishListItem Price or do i have to get another iQueryable lt  T  from the database with group     into

User · Answer

I know this is an old question but why can't you do it like:

db.OrderLineItems.Where(o => o.OrderId == currentOrder.OrderId).Sum(o => o.WishListItem.Price);

I am not sure how to do this using query expressions.

User · Answer

Try this    var itemsInCart   from o in db OrderLineItems                   where o OrderId    currentOrder OrderId                   select o WishListItem Price   return Convert ToDecimal itemsInCart Sum       I think it s more simple

User · Answer

What about    itemsInCart AsEnumerable   Sum o  gt o Price     AsEnumerable makes the difference  this query will execute locally  Linq To Objects

User · Answer

Try   itemsCard ToList   Select c  gt c Price  Sum      Actually this would perform better   var itemsInCart   from o in db OrderLineItems               where o OrderId    currentOrder OrderId               select new   o WishListItem Price    var sum   itemsCard ToList   Select c  gt c Price  Sum      Because you ll only be retrieving one column from the database

User · Answer

you can   itemsCart Select c  c Price  Sum     To hit the db only once do   var itemsInCart    from o in db OrderLineItems                   where o OrderId    currentOrder OrderId                   select new   o OrderLineItemId            o WishListItem Price                      ToList    var sum   itemsCart Select c  gt c Price  Sum      The extra round-trip saved is worth it

[c#] Linq to SQL .Sum() without group ... into

Examples related to c#

Examples related to linq-to-sql

Examples related to .net-3.5