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!

[r0k3t]

before this conversation gets derailed I would like to point out there are a couple of errors in the original code that don't have anything to do with what I was asking about, I didn't see them cause I was concentrating on the problem with the explicit construction of an entity.

Also - What I meant by "it doesn't cause an exception" was that noting fails - if you weren't debugging you might simply think you did not get back any results...

At any rate - for the moment disregarding the mismatch of the bedrooms and bathrooms (can't tell you for the life of me why they are varchars...) here is a working solution however it seems to me like the "Brute force and ignorance" solution

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

It seems as thought I should somehow be able to this with an anonymous function (lambda or anonymous method) but I am stumped.

Sorry for the confusion in my first post!

Thanks!