August 29, 2008 05:58pm pdt

1. naspinski 50,450
2. Fernando... 39,600
3. CarlVerret 17,064
4. sjturner2 14,250
5. Ceiled 10,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. primeMov... 2,000
17. dstanley9 2,000
17. vb_jonas 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. SwissKnife 2,000
17. ad5qa 2,000
17. irps20001 2,000
17. Koocurrent 2,000
17. vs1784 2,000
17. burakiewicz 2,000
17. JimFive 2,000
17. ajitha75 2,000
17. Smart_Man 2,000
17. Rahu_ket... 2,000

1. naspinski 50,450
2. Fernando... 39,600
3. sjturner2 20,250
4. CarlVerret 17,064
5. Ceiled 10,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. Smart_Man 2,000
17. ajitha75 2,000
17. irps20001 2,000
17. vb_jonas 2,000
17. p_davis 2,000
17. renjurdevan 2,000
17. SteveH_UK 2,000
17. ad5qa 2,000
17. SwissKnife 2,000
17. cottsak 2,000
17. Rahu_ket... 2,000
17. vs1784 2,000
17. dstanley9 2,000
17. burakiewicz 2,000
17. primeMov... 2,000
17. JimFive 2,000
17. michtsoi 2,000
17. AaronNance 2,000
17. REA_AN... 2,000

06.16.2008 at 09:20AM PDT, ID: 23488705

	[x] Attachment Details

Linq - Join in memory query with fresh query

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

Tags: Linq

I would like to join and query an in memory query and a fresh linq query. I will try and explain.

I have a query in memory (CurrentItem.ItemClauses). I need to then join this to a fresh data base query (dbClause.LinksSpecificationClauses) so i can do a contains statement (on clauseid). Here is my code at the moment but it is very slow.

Thanks

Start Free Trial

         
             For Each TempClause In CurrentItem.ItemClauses
            Dim SpecID As Int32 = TempClause.SpecificationClauseID
            Dim lsc = (From s In dbClause.LinksSpecificationClauses _
                       Where s.SpecificationClauseID = SpecID).SingleOrDefault
            If lsc.ClauseID = ClauseID Then
                Return True
            End If
        Next

Keywords: Linq - Join in memory query with fres…

	Title
1	To Join or Not To Join
2	I'm trying to join a domain
3	update statement with inner join
4	Excel QueryTables SQL JOIN statemen…
5	Multiple JOINs
6	Update based on a join

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Linq - Join in memory query with fresh query

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

Tags: Linq

About this solution