Select conditional some rows from DB by LINQ

See more:

C#

Hi every body


I need to select some first rows from a table by LINQ that has bellow condition:

Sum(NumberColumn) < SpecificNumber

For example:

IF(SpecificNumber == 40)
Show(3 first Rows) => because 10 + 5 + 20 < 40 But 10+5+20+15 > 40

or

IF(SpecificNumber == 20 )
Show(2 first rows) => because 10 + 5< 20 But 10+5+20 > 20

ID	Title	Number
1	X	10
2	Y	5
3	W	20
4	Z	15

Thank you for attention