September 7, 2008 03:10am 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

05.06.2008 at 04:41AM PDT, ID: 23379079

	[x] Attachment Details

The Order By not working in LINQ, also the query runs quite slow

Asked by cg_medistox in Language Integrated Query - LINQ, Microsoft Visual Basic.Net, Visual Studio 2008

Tags: VB.net, LINQ, http://www.every1preview.co.uk/

I am quite new to LINQ and quite nieve last week I thought it was an easy language aspect to get in to.

Anyway, i have a query that i wrote and for some reason the order by will not work on it, not only that, the query is returning all the rows from the database instead of the joined tables

I would expect because the tables are joined that only rows that refer to each other would return.

CapMans has approx 200 rows, CapDers has approx 70k rows and CarLeases has around 10 rows

All i want to return is the CapMans table but i need to know what rows are in the Leases table to see which Lease cars manufacturers show in the menu

The order by does not work, at all.

If you view the URL, the manufacturers menu down the side is the one i am trying to sort.Start Free Trial

         
             The query is in the code snippet
 
Dim Query = From mans In DB.CapMans _
                    Join Cars In DB.CapDers _
                    On mans.cman_code Equals Cars.cder_mancode _
                    Join Leases In DB.CarLeases _
                    On Leases.CapID Equals Cars.cder_ID _
                    Order By mans.cman_code _
                    Select mans Distinct

Keywords: The Order By not working in LINQ, als…

	Title
1	cornering in a car
2	Fast Query Slow Export
3	car safety
4	MS Access 97 (while large queries …
5	MISSING FILES CAUSING SLOW PC; …
6	Exchange server slow load all sudden.

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

The Order By not working in LINQ, also the query runs quite slow

Asked by cg_medistox in Language Integrated Query - LINQ, Microsoft Visual Basic.Net, Visual Studio 2008

Tags: VB.net, LINQ, http://www.every1preview.co.uk/

About this solution