Hi! Im having a hard time understanding the structure and properties for LLBLGEN. One problem that I have is with a simple NOT IN script.

"select * from [Language] l where l.LanguageID NOT IN (select LanguageID from KnowledgeInfo where KnowledgeInfoGroupID = '0B1E207F-7021-4274-930C-057E57AD0DDA' and IsDeleted = 0)"

What I did was this:

var c0 = qf.KnowledgeInfo.Where(pred).Select(()=>new { LanguageId = KnowledgeInfoFields.LanguageId.ToValue<int>() }); var c1 = qf.Language.Where(!c0.Contains(LanguageFields.LanguageId));

But unfortuantely it says operan not supported for predicate.

Can you help me out?

var q1 = qf.Order
   .Where(OrderFields.ShipVia.Equal(3))
   .Select(OrderFields.CustomerId);

var q = qf.Customer
    .Where(CustomerFields.CustomerId.NotIn(q1));


using (var adapter = new DataAccessAdapter())
{
    var result = adapter.FetchQuery(q);
}