c# - Filter by column from joined table -

i've started using simple.data orm. i've approached problem filtering column joined table.

my query looks this:

var candidates = db.dbo.candidates             .findallby(commonofferid: commonofferid, candidateid: null)             .select(                 db.dbo.candidates.id,                 db.dbo.candidates.email,                 db.dbo.candidateprofiles.candidateid             ).leftjoin(db.dbo.candidateprofiles).on(db.dbo.candidates.id == db.dbo.candidateprofiles.candidateid); 

i want select entities don't have ids in table. code not working. i'm getting exception, candidates doesn't have column candidateid.

is there way filter query value joined table?

it correct:

dbo.candidates         .findallby(commonofferid: commonofferid, candidateprofiles.candidateid: null)         .select(             db.dbo.candidates.id,             db.dbo.candidates.email,             db.dbo.candidateprofiles.candidateid         ).leftjoin(db.dbo.candidateprofiles).on(db.dbo.candidates.id == db.dbo.candidateprofiles.candidateid);