3.1.11.706 Final (SD.LLBLGen.Pro.DQE.SqlServer.NET20.dll) 3.1.12.0222 (SD.LLBLGen.Pro.ORMSupportClasses.NET20.dll 3.1.12.216 (SD.LLBLGen.Pro.LinqSupportClasses.NET35) DotNet 4.0 vs2010 project Adapter template

I think am doing something dumb but I can't see it at the moment. I get a

System.InvalidCastException: Unable to cast object of type 'System.Linq.Expressions.PropertyExpression' to type 'SD.LLBLGen.Pro.LinqSupportClasses.ExpressionClasses.SetExpression'.

when running this code to return an IQueryable<CustomerEntity> with an Orders Prefetch path filtered on where the employee is in Madrid:

var  = metaData.Customer.Select(a => a)
     .WithPath(b => b.Prefetch<OrderEntity>(c => c.Orders)
        .FilterOn(d => metaData.Employee.Any(e => e.EmployeeId ==d.EmployeeId &&  e.City == "Madrid")));

I think I have used the metadata.Entity syntax in a FilterOn before, so what am I doing wrong here?

The query must be executed correctly. You are using some old runtime libraries, please update to the latest one, as some improvements had been made around Linq aliasing.

Then, the query could be written in a clearer way, and easy to the framework and sql to produce:

var x = metaData.Customer.Select(a => a)
                .WithPath(b => b.Prefetch<OrderEntity>(c => c.Orders)
                    .FilterOn(o => o.Employee.City == "Madrid"));

            var results = x.ToList();

That worked. Thanks very much:-)