public static IList <RoomAvailability> GetRooms(Criteria criteria) { using (var context = new DomainModel.Search.Context.SearchModelContext()) { var queryResult = context.RoomAvailabilities.Where(x => x.City.Equals(criteria.City, StringComparison.InvariantCultureIgnoreCase) && x.Date >= criteria.FromDate.Date && x.Date <= criteria.ToDate.Date && x.NoofAvailableRooms > 0); if (queryResult.Min(x => x.NoofAvailableRooms) > 0) { return(queryResult.ToList()); } else { return(new List <RoomAvailability>()); } }; }