c# - LINQ left join using Castle Active Records? -


how can execute left join using linq , castle active records?

if tried following:

from account in accountrecord.queryable join s in schoolrecord.queryable on account equals s.account schools account.paymenttype == "s" select new { account = account, school = schools.elementat(0) }; 

but threw me following exception:

unable cast object of type 'remotion.data.linq.clauses.groupjoinclause' type 'remotion.data.linq.clauses.fromclausebase'.

executing following works (but not want, because need left join):

from account in accountrecord.queryable account.paymenttype == "s" school in schoolrecord.queryable school.account == account select new { account = account, school = school }; 

it seems not possible @ moment.

if or else find(s) working solution update answer.


Comments

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

c++ - Is it possible to compile a VST on linux? -

url - Querystring manipulation of email Address in PHP -