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
Post a Comment