Repository pattern not working as expected

[ju2pom]

repository.Database.GetCollection<Data>("Collection").FindAll().Where(x => x.Latitude.HasValue && x.Latitude.Value > 0 && x.Longitude.HasValue && x.Longitude.Value > 0) Returns some valid rows

repository.Query<Data>("Collection").Include(x => x.Latitude).Include(x => x.Longitude).Where(x => x.Latitude.HasValue && x.Latitude.Value > 0 && x.Longitude.HasValue && x.Longitude.Value > 0) Returns empty result

Longitude and Latitude are of type double?. I'm using LiteDB v4.1.4 Did I misunderstood anything with the repository pattern?

[mbdavid]

Hi @ju2pom, when you run a Where method after FindAll() you are running over Linq2Object (IEnumerable extensions), not by LiteDB.

[kosorin]

I’m also dealing with the same problem. I noticed LiteDB doesn't fully support Nullable type. Ommit HasValue and Value: Where(x => x.Latitude != null && x.Latitude > 0 && x.Longitude != null && x.Longitude> 0) or just Where(x => x.Latitude > 0 && x.Longitude > 0)

[mbdavid]

Hi @kosorin, try new in v5, please. Also, I made support for HasValue and Value properties.