// LLBLGen Pro Query Spec, nested queries with custom projections and entity queries.
var qf = new QueryFactory();
var q = qf.Customer
            .Where(CustomerFields.Country == "Germany")
            .Select(() => new
            {
                CompanyName = CustomerFields.CompanyName.ToValue<string>(),
                City = CustomerFields.City.ToValue<string>(),
                Orders = qf.Order
                                .CorrelatedOver(OrderEntity.Relations.CustomerEntityUsingCustomerId)

// LLBLGen Pro Query Spec, nested queries with custom projections. 
var qf = new QueryFactory();
var q = qf.Customer
                .Where(CustomerFields.Country == "Germany")
                .Select(() => new
                {
                    CustomerId = CustomerFields.CustomerId.ToValue<string>(),
                    Orders = qf.Order
                                    .CorrelatedOver(OrderEntity.Relations.CustomerEntityUsingCustomerId)
                                    .Select(() => new

// Linq to LLBLGen Pro 
LinqMetaData metaData = new LinqMetaData(adapter);
var q = from c in metaData.Customer
        select new
        {
            c.CustomerId,
            IsAmerican = (c.Country == "USA"),
            c.Country
        };
        

// In memory list of objects
var idList = new List<Pair<int, int>>();
idList.Add(new Pair<int, int>() { Value1 = 10254, Value2 = 13 });
idList.Add(new Pair<int, int>() { Value1 = 10254, Value2 = 14 });
idList.Add(new Pair<int, int>() { Value1 = 10254, Value2 = 15 });
 
// Linq to LLBLGen Pro
LinqMetaData metaData = new LinqMetaData(adapter);
var q = metaData.OrderDetail
                    .Where(od => idList.Contains(new Pair<int, int>() { Value1 = od.OrderId, Value2 = od.ProductId }));