LINQ: Inner Join & Left Outer Join Q

R

Registered User

I am having trouble doing an inner join and a left outter join in
LINQ.

Table A has a primary key PKA
Table B has a primary key PKB and a column with the foreign key PKA

I have no problem doing this inner join where A.PKA == B.PKA but there
is a third table C which has a foreign key PKB. The left outer join is
on B.PKB and C.PKB where the select includes count of C records along
with values from A and B.

I have the SQL but I can't get my head around how to do the outer join
and get the count. Could someone provide an example and/or point me to
a suitable resource? MSDN just seems to muddy the waters on this
topic.

thank you
A.G.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quick LINQ question 1
To give inner join and Left outer Join 3
perform INNER JOIN on query results 2
LINQ left outer join 1
Left Outer Join Producing Incorrect Results 3
Simulating an outer non-equijoin in LINQ. 9
LINQ. Inner Join. 4
many-to-many and finding unmatched 2

Top