Hello,

I have a problem with a specific query that do not return as much results as expected. The problem is when I use where clause combined with a select on an EntitySet and FirstAndDefault (sample code below)

DataObjects.Net version: 4.6.4.1123

Model:

  [HierarchyRoot]
  public class MyEntity : Entity
  {
    [Field, Key]
    public int Id { get; private set; }

    [Field]
    [Association(PairTo = "Owner")]
    public EntitySet<MyItem> Items { get; set; }
  }

  [HierarchyRoot]
  public class MyItem : Entity
  {
    [Field, Key]
    public int Id { get; private set; }

    [Field]
    public MyEnum MyEnum { get; set; }

    [Field]
    public MyEntity Owner { get; set; }
  }

  public enum MyEnum
  {
    None,
    Value1
  }

Code:

new MyEntity();
var queryWhere = session.Query.All<MyEntity>().Where(e => e.Items.Select(i => i.MyEnum).FirstOrDefault() == MyEnum.None);

Returns 0 result, where 1 was expected.