Complex Example

• FirstName = John AND LastName = Doe AND (State = CA OR State = NY)
• Customer is New OR Updated
• Ordered by LastName ASC, FirstName ASC, Credit DESC
• Skip the first 10 and take 5

Query props = new Query();
  //define the attribute based conditions
  //Users can pass in a string if they know the attribute name. R1 column name = attribute name.
  CompositeTest innerCompTest = new CompositeTest();
  innerCompTest.Operator = CompositeTest.OR;
  innerCompTest.Add(new AttributeTest("state", "CA", AttributeTest.EQUAL));
  innerCompTest.Add(new AttributeTest("state", "NY", AttributeTest.EQUAL));
  CompositeTest outerCompTest = new CompositeTest();
  outerCompTest.Operator = CompositeTest.OR;
  outerCompTest.Add(new AttributeTest("fname", "Jane", AttributeTest.EQUAL));
  outerCompTest.Add(new AttributeTest("lname", "Doe", AttributeTest.EQUAL));
  outerCompTest.Add(innerCompTest);
  //define the ordering
  SortCriteria sort = new SortCriteria();

  sort.Add("fname", SortOrder.ASCENDING);
  sort.Add("lname", SortOrder.ASCENDING);
  //set the Query object
  props.TestCriteria = outerCompTest;
  props.SortCriteria = sort;
  props.Skip = 10;
  props.Take = 5;
  Sybase.Collections.GenericList<Customer> customers2 = Customer.FindWithQuery(props);