private void Example1() { IQueryBuilder builder = null; var query = builder // Return the first 10 customers that have 'fred' as a rep using the 'customer_rep' index .Begin() .Assign("count").Literal(0) .BeginFor("customer") .OrderBy("customerId").Ascending() .FromTable("customers").UsingIndex("customer_rep") .Function(q => new[] { new Tuple <IColumnDefinition, CompareOperation, object>(q.Table["customers"].Column["rep_name"], CompareOperation.Equal, "fred") }) //.WhereColumns(new Tuple<string, CompareOperation, object>("rep_name", CompareOperation.Equal, "fred")) //.WhereColumn("rep_name", CompareOperation.Equal).Literal("fred") .If().Compare(CompareOperation.Equal).Variable("count").Literal(10).Break() .Assign("count").Unary(UnaryOperator.Increment).Variable("count") .BeginSelect() .Field("customerId").Alias("id") .Field("name").Alias("customerName") .EndSelect() .EndFor() .End() // Build the query .Build(); }