inner join using Linq Vb.net

Question

I'm trying to join two datatables of same keyfields.

table1

ID     Class    
----   -----
1       10  
2       9

table2

ID     Class
----   -----
1       8   
2       7

Result

ID      Class1    Class2
1        10       8
2        9        7

Pranay Rana · Accepted Answer · 2011-04-15 09:35:04Z

6

following is code for joining between user and userclients you can replace your table and get the result of join

Follwing image is for the c# but will give you idea in detail

enter image description here

Dim user = From u In Users Join uc In UserClients On u.Id = uc.UserId New From { _
    u.Id, _
    u.FirstName, _
    u.LastName, _
    uc.MobileNo, _
    uc.imeiNO, _
    uc.Id _
}

if you are beginner you can look this : SQL to LINQ ( Visual Representation )

edited Apr 15, 2011 at 9:35

answered Apr 15, 2011 at 9:29

Pranay Rana

177k37 gold badges244 silver badges267 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrei Andrushkevich · Accepted Answer · 2011-04-15 09:29:40Z

4

try something like this:

Dim test = From t1 in table1_
       Join t2 in table2 on t1.ID Equals t2.ID _
       Select  ID = t1.ID,
               Class1 = t1.Class,
               Class2 = t2.Class

answered Apr 15, 2011 at 9:29

Andrei Andrushkevich

9,9734 gold badges33 silver badges43 bronze badges

Collectives™ on Stack Overflow

inner join using Linq Vb.net

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related