Hello,
I developed my program with C # using linq for the query. And I ran into a problem while converting my sql query to linq.
I don't know what to do, can you tell me the right query, please ..
Here is my sql query:
SELECT bs.idBalancesortie, bs.datesortie, bs.c_num_debut,bs.c_num_fin,bs.nombredetickets, n.quotite, bs.montant,
SUM(bs.montant) OVER(ORDER BY bs.idNature ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as Cumul, bs.idNature
FROM BalanceSortie bs
LEFT JOIN Natures n on bs.idNature = n.idNature
order BY bs.idNature
[1]: /answers/storage/attachments/125424-res.jpg