Hi all,

I'm trying to generate a query of the general form WHERE A AND B AND (C OR D OR E)

How can I achieve this? I tried this below but it's not quite correct - it's of the form WHERE A AND B OR C OR D OR E

var qf = new QueryFactory(); var q = qf.Job; q = q.Where(JobFields.JobTitle.Like('%' + criteria.Title + '%')); // Condition A q = q.Where(JobFields.JobLocation.Like('%' + criteria.Location + '%')); // Condition B q = q.OrWhere(JobFields.LokIdSector == 13); // Condition C q = q.OrWhere(JobFields.LokIdSector == 14); // Condition D q = q.OrWhere(JobFields.LokIdSector == 15); // Condition E

(where criteria is an object containing strings for Title and Location).

Any help much appreciated!

Thanks,

David

Example:

SELECT * FROM Customers WHERE Country = 'UK' AND (City = 'Cowes' OR ContactTitle = 'Sales Agent')

var q = qf.Customer
    .Where(CustomerFields.Country == "UK")
    .AndWhere(new PredicateExpression(CustomerFields.City == "Cowes" | CustomerFields.ContactTitle == "Sales Agent"));

QuerySpec offers nice extension methods for predicateexpression construction ->

var q = qf.Customer
            .Where(CustomerFields.Country == "UK")
            .AndWhere((CustomerFields.City == "Cowes").Or(CustomerFields.ContactTitle == "Sales Agent"));

so it has a quite natural flow.

Excellent - thanks to you both!

For anyone else reading, here's how I accomplished the nested OR statement in a loop using a PredicateExpression object:

                var qf = new QueryFactory();
                var q = qf.Job;
                q = q.Where(JobFields.JobTitle.Like('%' + criteria.Title + '%'));
                q = q.Where(JobFields.JobLocation.Like('%' + criteria.Location + '%'));

                PredicateExpression p = new PredicateExpression();

                // Add an or where clause for each sector id specified in the search criteria
                foreach (int sectorId in criteria.Sectors)
                {
                    p.AddWithOr(JobFields.LokIdSector == sectorId);

                }
                q = q.AndWhere(p);

                return (EntityCollection<JobEntity>)adapter.FetchQuery(q);

Thanks again!

David