πŸ™ˆ
πŸ™ˆ
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
how would i sum within each group
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
if you dont mind
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
but could you show me this bit
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
ight
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
sorry i am very bad at this
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
how
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
but whats do you mean by group it
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
await _context.Sales .GroupBy(a => a.ProductidFk) .OrderBydescending(a => a.Sum(a.Quantiysold)) .TolsitAsync(); i tried
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
sorry for not explaning properly
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
thank you however i want to sum the quantity which belongs to sales. productidfk also belongs to sales and prdoucts products. How do i make a query that will give the toal number of each product sold. Like product 1 total sold 5 product 2 toals solded 10
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
I get a invaild OperationExpectation. Reweite the query in a from that can be transalted or swithc to cliebt evaluation explicity but inserting a call to asEnumerbale, AsasyncaEnumbared, to list Or to ListAsynac
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
@ZZZZZZZZZZZZZZZZZZZZZZZZZ here is my the code i had var quantitysoledofeachproduct = await _context.Sales.GroupBy(a => a.ProductidFk) . OrderBydescending(a => a.Sum(a.Quantiysold)).TolsitAsync();
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
i am getting my code
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
out of stuff that is already there
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
ok i see it it becasue we are making a new lsit
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
I don’t get the new bit
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
How would you approach creating a query like this
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
What I want to do is return a list of the products and the total sold of each of the products by summing up the quantities where the product id is the same
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
I will tell you the details the query is based on _context sales. Sales has products products productid(fk) and quantity
112 replies
CC#
Created by πŸ™ˆ on 1/18/2024 in #help
Run Query in asp.net mvc
Hi @ZZZZZZZZZZZZZZZZZZZZZZZZZ I am struggling to get the original query working
112 replies