Unable to translate lambda expression 'entDocEntity => ((entDocEntity.Interfaces != null) AndAlso entDocEntity.Interfaces.Any(entMlInterfaces => ((entMlInterfaces.Linked != null) AndAlso value(System.Collections.Generic.List`1[System.Guid]).Contains(entMlInterfaces.Linked.Id))))' because it requires to materialize entity of type 'Werp.Model.Models.Documents.DocEntity'.

The code:

var lst = new List<Guid>() { new Guid("b85c43db-15c2-416a-b512-02c5fa892d64") };
var d = Query.All<DocEntity>().Where(ent => ent.Interfaces != null && ent.Interfaces.Any(ent2 => ent2.Linked != null && lst.Contains(ent2.Linked.Id))).ToArray();

ent.Interfaces - is EntitySet<ent2> If I remove ent.Interfaces != null and ent2.Linked != null - then it translates normally. But this Expression is generated, and we need those "!= null" operands, because we use these expression in runtime not only for SQL queries

Updated at 16.07.2010 13:42:33

Well, I suppose you sould do it as you wish) As for me i would just not translate this into sql

This thread was imported from our support forum. The original discussion may contain more detailed answer.