IN statement in Linq

Question

can anyone help me to write

Select * from students where studentid in 
(select studentXID from rel where parentXID = 123)

Please help me

Thanks in advance.

var q = db.table.Where(x => db.rel.Any(x2 => x2.parentXID == 123 && x.studentid == x2.studentXID)) — Tim Schmelter, Feb 16 '17 at 13:35

score 0 · Answer 1 · answered Feb 16 '17 at 14:19

0

In linq, it's easier to split statements like that into two parts

var relList = context.rel.Where(x => x.parentXID = 123);

var result = context.students.Where(x => relList.studentXID.Contains(x.studentid));

answered Feb 16 '17 at 14:19

Steven Ackley

Eric Lizotte · Answer 2 · 2017-02-16T14:08:40.557

-1

This should cover it

students.Where(s => rel.Any(r => r.studentXID == s.studentid && r.studentXID == 123))

edited Feb 16 '17 at 14:08

answered Feb 16 '17 at 13:37

Eric Lizotte

2 Answers2