asked on join in LINQ to SQL
How do we join two tables in LINQ to SQ?
table_A table_b
id id
acct acct
address job_position
table_A table_b
id id
acct acct
address job_position
ASP.NET
Last Comment
aibusinesssolutions
ASKER
Group join kind of like innerjoin?
ASKER
What is Into employees = Group ?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
employees is a temporary object to hold the join, I just named it employees, it can be anything.
Group Select New With {a.address, b.job_position} creates the group that you can enumerate through
Group Select New With {a.address, b.job_position} creates the group that you can enumerate through
If you want more examples of advanced joins or other LINQ to SQL samples, check this page out.
http://msdn.microsoft.com/en-us/vbasic/bb688085.aspx
http://msdn.microsoft.com/en-us/vbasic/bb688085.aspx
Dim q = From a In db.table_A _
Group Join b In db.table_B On a.id Equals b.id Into employees = Group _
Select New With {a.address, b.job_position}