Hi,

I guess I'm not sure how to filter on related entities with Linq to LLBLGen:

This: int value =3; var q = (from c in metaData.Assignment where c.Group2AssignmentItem.Where(o => o.GroupId== value) select c);

Produces: Error 5 Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<DAL.EntityClasses.Group2AssignmentEntity>' to 'bool'

Thanks for your hep, Patrick

Please use the latest build of the runtimes, and if you're not sure, please post the runtime lib version here (build nr. see guidelines in this forum how to obtain it).

Otis wrote:

Please use the latest build of the runtimes, and if you're not sure, please post the runtime lib version here (build nr. see guidelines in this forum how to obtain it).

So you seem to say that the code should be running if I had the right version?

I thought my syntax was wrong.

I updated my signature: LLBLGen 2.6 - June-6-2008, Runtime Library v2.6.08.0709, SQL 2005, C#, .NET 3.5, Adapter Template

Thanks, Patrick

The first thing always is to check whether the customer has teh right runtime library as it might be that it's already fixed so we can save each other some time

Your syntax is indeed wrong: var q = (from c in metaData.Assignment ** where c.Group2AssignmentItem.Where(o => o.GroupId== value)** select c);

the 'where' keyword requires a boolean expression. However c.Group2AssignmentItem.Where(o => o.GroupId== value) returns 0 or more entities. You should use .Any instead of .Where