CODEWITHSUNDEEP
linqright-join
solarissf
solarissf

Reputation: 1277

right join on my linq query

I want to return ALL items from db.Accounts. How do I do a right join on the below linq query?

        var query = (
                     from tradeTbl in db.Trades
                     join acctTbl in db.Accounts on tradeTbl.AccountID equals acctTbl.AccountID

I've tried changing to 

        var query = (
                    from acctTbl in db.Accounts
                    join tradeTbl in db.Trades on acctTbl.AccountID equals tradeTbl.AccountID
                    where acctTbl.AccountActive == true

still not working... if I put that same query in SSMS and change it to LEFT JOIN it works in SSMS

Upvotes: 0

Views: 184

Answers (1)

Jeff Mercado
Jeff Mercado

Reputation: 134891

Just write it in terms of a left (outer) join by reversing the joined tables.

var query =
    from a in db.Accounts
    join t in db.Trades on a.AccountID equals t.AccountID into ts
    from t in ts.DefaultIfEmpty()
    select ...;

Upvotes: 1

Related Questions