I have a problem with the following,
queryOverList = Session.QueryOver<Actor>()
.Where(x => x.Number.IsLike(number + "%"))
.And(x => x.Country.Id == countryCodeId)
.And(x => x.IdNumber.IsLike(idNumber + "%"))
.WithSubquery
.WhereProperty(x => x.Id)
.In(detachedAddressQueryOver)
.WithSubquery
.WhereProperty(x => x.Id)
.In(detachedDerivedActorQueryOver)
.List();
my countryCodeId is an integer.
so if i do not pass any value, it would be 0. So when nothing is
passed in I want to return all for that countryCode condition since I
am not passing in any value. Buit instead it searched for 0 and return
me nothing. What can do with such int's