Building the following query I'm getting such an exception in
DbLinq\src\DbLinq\Data\Linq\Sugar\Implementation\QueryBuilder.cs
var res = from r in db.Roles
join l in db.RoleUserLinks on r.Id equals l.cRoleID
join us in db.Users on l.cUserID equals us.Id
*where r.cRole == "RP00"*
select us;
BTW moving the where in the initial from query execute with no problem:
var res = from r in db.Roles*.Where((r) => r.cRole == "RP00")*
join l in db.RoleUserLinks on r.Id equals l.cRoleID
join us in db.Users on l.cUserID equals us.Id
select us;
I'm try to debug the problem but with no success:
protected virtual void CompileRowCreator(BuilderContext
builderContext)
{
var reader = builderContext.CurrentSelect.Reader;
reader =
(LambdaExpression)SpecialExpressionTranslator.Translate(reader);
reader = (LambdaExpression)ExpressionOptimizer.Optimize(reader,
builderContext);
builderContext.ExpressionQuery.RowObjectCreator = *
reader.Compile()*;
}
Exception is thrown from reader.Compile(), but I can't understand the
difference between the two queries...
What am I missing?
Giacomo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---