September 6, 2008 02:56pm pdt

1. naspinski 52,450
2. Fernando... 44,300
3. CarlVerret 17,064
4. sjturner2 14,250
5. Ceiled 12,500
6. CMYScott 5,750
7. TheLearn... 5,172
8. Praesidium 4,664
9. GreenGho... 4,150
10. VBRocks 4,000
11. emoreau 3,050
12. gardavis 3,000
12. Dhaest 3,000
14. ZachSmith 2,600
15. boag2000 2,500
15. mark_wills 2,500
17. IndianOcean 2,000
17. vb_jonas 2,000
17. SwissKnife 2,000
17. vs1784 2,000
17. dstanley9 2,000
17. burakiewicz 2,000
17. primeMov... 2,000
17. JimFive 2,000
17. AaronNance 2,000
17. p_davis 2,000
17. REA_AN... 2,000
17. renjurdevan 2,000
17. cottsak 2,000
17. ad5qa 2,000
17. irps20001 2,000
17. Koocurrent 2,000
17. Rahu_ket... 2,000
17. ajitha75 2,000
17. Smart_Man 2,000

1. naspinski 52,450
2. Fernando... 44,300
3. sjturner2 20,250
4. CarlVerret 17,064
5. Ceiled 12,500
6. CMYScott 5,750
7. TheLearn... 5,172
8. Praesidium 4,664
9. GreenGho... 4,150
10. VBRocks 4,000
11. emoreau 3,050
12. gardavis 3,000
12. Dhaest 3,000
14. ZachSmith 2,600
15. mark_wills 2,500
15. boag2000 2,500
17. IndianOcean 2,000
17. Koocurrent 2,000
17. ajitha75 2,000
17. Rahu_ket... 2,000
17. p_davis 2,000
17. michtsoi 2,000
17. primeMov... 2,000
17. renjurdevan 2,000
17. ad5qa 2,000
17. SwissKnife 2,000
17. SteveH_UK 2,000
17. cottsak 2,000
17. vb_jonas 2,000
17. vs1784 2,000
17. dstanley9 2,000
17. burakiewicz 2,000
17. JimFive 2,000
17. AaronNance 2,000
17. REA_AN... 2,000
17. Smart_Man 2,000
17. irps20001 2,000

02.05.2008 at 03:06AM PST, ID: 23137624

	[x] Attachment Details

LINQ database query using max

Asked by hijiki7777 in Language Integrated Query - LINQ

In the code I find the maximum date from a table by using
DateTime maxDate = Result.Select(md => md.Date).Max();

However I want to find the next largest date.
In SQL it will be
SELECT MAX([Date]) FROM dbo.FundPrice WHERE [Date] < '2008/02/04'

I am unfamilier with the Linq syntax. I cannot seem to put in a WHERE clause, so how do I do it?Start Free Trial

Keywords: LINQ database query using max

	Title
1	Trying to do some MAX COUNTing
2	Date filter query timing out
3	maxdate query not getting oldest dates?
4	MySQL DATETIME
5	Access 2003: Max Date not work…
6	Access 2003: DesignView Filter f…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

LINQ database query using max

Asked by hijiki7777 in Language Integrated Query - LINQ

About this solution