Explicit construction of entity type 'rentalAlertUtilities.RentalAlertCityState' in q

[r0k3t]

Hi there,

OK - I am missing something here... Obviously there is a better way to do this cause while it doesn't throw an exception this is what I get

base {System.SystemException} = {"Explicit construction of entity type 'rentalAlertUtilities.RentalAlertCityState' in query is not allowed."}

I know that my list of contacts has a rentalAlertCityState object and I want to grab any properties that match that city and state. Hmm... maybe just looking at my code will show you what I am trying to do.

I am really stretching my limits of understanding here, but I guess that is how you learn right!

var matchingProperties = from p in properties
                     where int.Parse(p.Bedrooms) >= contact.MinBedrooms
                     && int.Parse(p.Bathrooms) >= contact.MinBathrooms
                     && p.RentRate >= contact.RentRangeMax
                     && p.RentRate <= contact.RentRangeMin
                     && p.DogsAllowed == contact.DogsAllowed
                     && p.CatsAllowed == contact.CatsAllowed
                     && contact.RentalAlertCityStates.Contains(new RentalAlertCityState { City = p.City, State = p.State })
                     select p;

Thanks for any advice!