ef core left join with "in" conditions

Question

i have many ids of persons that i want see group is Assigned to this person، i have sql query like this

SELECT * 
FROM cor.[Group] AS g 
LEFT JOIN cor.PersonGroup AS pg ON 
g.Id=pg.GroupId  AND 
pg.PersonId IN (1,2)

and i want to give linq query for this i write this linq query

from g in _context.Groups join
                     pg in _context.PersonGroups.Where(pp =>personIds.Contains( pp.PersonId))
                    on g.Id equals pg.GroupId

But this is different from what I want

OK, I misunderstood. Perhaps you could edit your question to make that clearer? — ProgrammingLlama, Jun 25 '19 at 07:50
Possible duplicate of [LINQ to SQL - Left Outer Join with multiple join conditions](https://stackoverflow.com/questions/1122942/linq-to-sql-left-outer-join-with-multiple-join-conditions) — SᴇM, Jun 25 '19 at 07:54
@Mohammadhossein what is your exact problem with `in` condition? — SᴇM, Jun 25 '19 at 07:57
@SᴇM with this linq quey , generated two nested select , but i want one select — Mohammad hossein, Jun 25 '19 at 08:09

Sean Sailer · Answer 1 · 2019-06-26T13:28:23.260

2

Try the following:

var persons = from grp in _context.Groups
              join pg in _context.PersonGroups on grp.Id equals pg.GroupId
              where personIds.Contains(pg.PersonId)
              select pg;

edited Jun 26 '19 at 13:28

answered Jun 25 '19 at 13:48

Sean Sailer

343
1
12

ef core left join with "in" conditions

1 Answers1