Linq To Sql left join using multiple join clauses

Question

For some reason I am getting a syntax error on the below code. What I am trying to achieve is A LEFT JOIN with MULTIPLE JOIN CLAUSES. The syntax error occurs at the Keyword INTO foobar. VS 2012 says unexpected Token. Any help would be great, thank you !

 Dim results = From f In foo _
                   Join b In bar On new with {f.Type,f.ID} Equals New With {"Test",b.ID} into fooBar _
                   from x in foobar.DefaultEmpty() _ 
                   Where foo.id = 1

D Stanley · Accepted Answer · 2013-02-12 16:26:13Z

1

You want a Group Join:

Dim results = From f In foo _
               Group Join b In bar On 
                   New With {f.Type,f.ID} Equals New With {"Test",b.ID} _
                   Into fooBar = Group _
               from x in foobar.DefaultEmpty() _ 
               Where foo.id = 1

answered Feb 12, 2013 at 16:26

D Stanley

153k12 gold badges189 silver badges257 bronze badges

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

2 Comments

gh9 Over a year ago

@D Stanley, why would the have a Group Join msdn says it does the same thing as a left join. What is the difference and why does it work for me?

D Stanley Over a year ago

@gh9 That's the syntax VB uses - it has some other uses besides the equivalent of a LEFT JOIN (such as being able to select aggregates of the right hand side) so I guess they chose a more generic syntax.

spajce · Accepted Answer · 2013-02-12 16:22:16Z

0

Try to cast the f.ID or b.ID

 Dim results = From f In foo _
                   Join b In bar On new with {f.Type, CInt(f.ID)} Equals New With {"Test", CInt(b.ID)} into fooBar _
                   from x in foobar.DefaultEmpty() _ 
                   Where foo.id = 1

edited Feb 12, 2013 at 16:22

answered Feb 12, 2013 at 16:04

spajce

7,0905 gold badges31 silver badges46 bronze badges

1 Comment

gh9 Over a year ago

@ still get the unexpected token error right before INTO keyword

Collectives™ on Stack Overflow

Linq To Sql left join using multiple join clauses

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related