Hi,

I have this LINQ statement which is not functioning as I expect:

            IQueryable<CustomerEntity> query = from customer in this.ObjectContext.CustomerEntitySet
                                               where ((customerNumber != string.Empty ? customer.cus_number.Contains(customerNumber) : true)
                                                  && (customerLastName != string.Empty ? customer.cus_lastname.Contains(customerLastName) : true))
                                               select customer;

The logic I am trying to get is:

Get all records where the customerNumber and customerLastName match.

so If I have Cazabon, 0001 and Charles, 0002 as my records (Last Name, Number) and the user searches for z, 2, I should get no records back. If the y search for z, 1 then Cazabon, 0001 should return. If they search for just c, then both records should return.

What is the correct way to do this?