Double IncludeFilter Fails | C# Online Compiler

Double IncludeFilter Fails by TheSanSan

// Entity Framework Plus
// Doc: https://entityframework-plus.net/query-include-filter
// @nuget: Microsoft.EntityFrameworkCore.SqlServer
// @nuget: Z.EntityFramework.Plus.EFCore
using System;
using System.Linq;
using Z.EntityFramework.Plus;
using Microsoft.EntityFrameworkCore;
using Microsoft.Data.SqlClient;
using System.Collections.Generic;

public class Program
{
	private static Guid _fact1;
	private static Guid _fact2;
	private static Guid _fact3;
	public static EntityContext context = new EntityContext();
	public static void Main()
	{
		context.Database.EnsureCreated();
		_fact1 = Guid.Parse("11111111-ABA9-90B8-4C00-37C288761F26");
		_fact2 = Guid.Parse("22222222-ABA9-90B8-4C00-37C288761F26");
		_fact3 = Guid.Parse("33333333-ABA9-90B8-4C00-37C288761F26");
		GenerateData();
		// Update: UPDATE all rows from the database using a LINQ Query without loading entities in the context.
		// LOAD blogs and related active posts and comments.
		using (var context = new EntityContext())
		{
			List<Fact> fullList = context.Facts.Where(x => x.FactId != Guid.Empty).Include(p => p.Patients).Include(p => p.Persons).Include(p => p.Addresses).ToList();
			Console.WriteLine("Full List - {0}", fullList.Count());
			foreach (var fact in fullList)
			{
				Console.WriteLine("Fact: {0} \tPatients: {1} \tPersons: {2} \tAddresses: {3}", fact.FactId, fact.Patients.Count(), fact.Persons.Count(),  fact.Addresses.Count());
			}
		}

		Console.WriteLine("");
		using (var context = new EntityContext())
		{
			var list = new List<Guid>{_fact1, _fact3};
			var doubleFilter = context.Facts.Where(b => list.Contains(b.FactId))
				.Include(p => p.Patients)
				.Include(p => p.Persons)
				.Include(p => p.Addresses)
				.ToList();
		
			foreach (var fact in doubleFilter)
            {
                fact.Patients = fact.Patients.Where(x => x.ValidTo == DateTime.MaxValue ).ToList();
                fact.Persons = fact.Persons.Where(x => x.ValidTo == DateTime.MaxValue ).ToList();
                fact.Addresses = fact.Addresses.Where(x => x.ValidTo == DateTime.MaxValue).ToList();
            }
			Console.WriteLine("Double Filtered List");
			foreach (var fact in doubleFilter)
			{
				Console.WriteLine("Fact: {0} \tPatients: {1} \tPersons: {2} \tAddresses: {3}", fact.FactId, fact.Patients.Count(), fact.Persons.Count(),  fact.Addresses.Count());
			}
		}

		Console.WriteLine("");
		using (var context = new EntityContext())
		{
			var list = new List<Guid>{_fact1, _fact3};
			var doubleFilter = context.Facts.Where(b => list.Contains(b.FactId))
				.IncludeFilter(p => p.Patients.Where(f => f.ValidTo == DateTime.MaxValue))
				// Seems only to fail when I add more than 1 IncludeFilter
				.IncludeFilter(p => p.Persons.Where(f => f.ValidTo == DateTime.MaxValue))
				.IncludeFilter(p => p.Addresses.Where(f => f.ValidTo == DateTime.MaxValue))
				.ToList();
			Console.WriteLine("Double Filtered List - filtred");
			foreach (var fact in doubleFilter)
			{
					Console.WriteLine("Fact: {0} \tPatients: {1} \tPersons: {2} \tAddresses: {3}", fact.FactId, fact.Patients.Count(), fact.Persons.Count(),  fact.Addresses.Count());
			}
		}
	//FiddleHelper.WriteTable("After Filtering", list);
	}

	public static void GenerateData()
	{
		using (var context = new EntityContext())
		{
			context.Facts.Add(new Fact()
			{FactId = _fact1, ValidTo = DateTime.MaxValue});
			context.Facts.Add(new Fact()
			{FactId = _fact2, ValidTo = DateTime.Now});
			context.Facts.Add(new Fact()
			{FactId = _fact3, ValidTo = DateTime.MaxValue});
			context.SaveChanges();
			context.Patients.Add(new Patient()
			{PatientId = Guid.NewGuid(), FactId = _fact1, Content = "Patient1 in Fact1", ValidTo = DateTime.MaxValue, });
			context.Patients.Add(new Patient()
			{PatientId = Guid.NewGuid(), FactId = _fact1, Content = "Patient1 in Fact1", ValidTo = DateTime.Now, });
			context.Patients.Add(new Patient()
			{PatientId = Guid.NewGuid(), FactId = _fact2, Content = "Patient2 in Fact2", ValidTo = DateTime.MaxValue, });
			context.Patients.Add(new Patient()
			{PatientId = Guid.NewGuid(), FactId = _fact2, Content = "Patient2 in Fact2", ValidTo = DateTime.Now, });
			context.Patients.Add(new Patient()
			{PatientId = Guid.NewGuid(), FactId = _fact3, Content = "Patient3 in Fact3", ValidTo = DateTime.MaxValue, });
			context.Persons.Add(new Person()
			{PersonId = Guid.NewGuid(), FactId = _fact1, Content = "Person1 in Fact1", ValidTo = DateTime.MaxValue, });
			context.Persons.Add(new Person()
			{PersonId = Guid.NewGuid(), FactId = _fact1, Content = "Person1 in Fact1", ValidTo = DateTime.Now, });
			context.Persons.Add(new Person()
			{PersonId = Guid.NewGuid(), FactId = _fact2, Content = "Person2 in Fact2", ValidTo = DateTime.Now, });
			context.Persons.Add(new Person()
			{PersonId = Guid.NewGuid(), FactId = _fact2, Content = "Person2 in Fact2", ValidTo = DateTime.MaxValue, });
			context.Persons.Add(new Person()
			{PersonId = Guid.NewGuid(), FactId = _fact3, Content = "Person3 in Fact3", ValidTo = DateTime.Now, });
			context.Addresses.Add(new Address()
			{AddressId = Guid.NewGuid(), FactId = _fact1, Content = "Address1 in Fact1", ValidTo = DateTime.MaxValue, });
			context.Addresses.Add(new Address()
			{AddressId = Guid.NewGuid(), FactId = _fact1, Content = "Address1 in Fact1", ValidTo = DateTime.Now, });
			context.Addresses.Add(new Address()
			{AddressId = Guid.NewGuid(), FactId = _fact2, Content = "Address2 in Fact2", ValidTo = DateTime.MaxValue, });
			context.Addresses.Add(new Address()
			{AddressId = Guid.NewGuid(), FactId = _fact3, Content = "Address3 in Fact3", ValidTo = DateTime.MaxValue, });
			context.Addresses.Add(new Address()
			{AddressId = Guid.NewGuid(), FactId = _fact3, Content = "Address3 in Fact3", ValidTo = DateTime.Now, });
			context.SaveChanges();
		}
	}

	public class EntityContext : DbContext
	{
		public EntityContext()
		{
		}

		protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
		{
			optionsBuilder.UseSqlServer(new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()));
			base.OnConfiguring(optionsBuilder);
		}

		public DbSet<Fact> Facts
		{
			get;
			set;
		}

		public DbSet<Patient> Patients
		{
			get;
			set;
		}

		public DbSet<Address> Addresses
		{
			get;
			set;
		}

		public DbSet<Person> Persons
		{
			get;
			set;
		}
	}

	public class Fact
	{
		public Guid FactId
		{
			get;
			set;
		}

		public DateTime ValidTo
		{
			get;
			set;
		}

		public IEnumerable<Patient> Patients
		{
			get;
			set;
		}

		public IEnumerable<Address> Addresses
		{
			get;
			set;
		}

		public IEnumerable<Person> Persons
		{
			get;
			set;
		}
	}

	public class Patient
	{
		public Guid PatientId
		{
			get;
			set;
		}

		public string Content
		{
			get;
			set;
		}

		public DateTime ValidTo
		{
			get;
			set;
		}

		public Guid FactId
		{
			get;
			set;
		}
	}

	public class Person
	{
		public Guid PersonId
		{
			get;
			set;
		}

		public string Content
		{
			get;
			set;
		}

		public DateTime ValidTo
		{
			get;
			set;
		}

		public Guid FactId
		{
			get;
			set;
		}
	}

	public class Address
	{
		public Guid AddressId
		{
			get;
			set;
		}

		public string Content
		{
			get;
			set;
		}

		public DateTime ValidTo
		{
			get;
			set;
		}

		public Guid FactId
		{
			get;
			set;
		}
	}
}

​x
 
// Entity Framework Plus
// Doc: https://entityframework-plus.net/query-include-filter
// @nuget: Microsoft.EntityFrameworkCore.SqlServer
// @nuget: Z.EntityFramework.Plus.EFCore
using System;
using System.Linq;
using Z.EntityFramework.Plus;
using Microsoft.EntityFrameworkCore;
using Microsoft.Data.SqlClient;
using System.Collections.Generic;
​
public class Program
{
    private static Guid _fact1;
    private static Guid _fact2;
    private static Guid _fact3;
    public static EntityContext context = new EntityContext();
    public static void Main()
    {
        context.Database.EnsureCreated();
        _fact1 = Guid.Parse("11111111-ABA9-90B8-4C00-37C288761F26");
        _fact2 = Guid.Parse("22222222-ABA9-90B8-4C00-37C288761F26");
        _fact3 = Guid.Parse("33333333-ABA9-90B8-4C00-37C288761F26");
        GenerateData();
        // Update: UPDATE all rows from the database using a LINQ Query without loading entities in the context.
        // LOAD blogs and related active posts and comments.
        using (var context = new EntityContext())
        {
            List<Fact> fullList = context.Facts.Where(x => x.FactId != Guid.Empty).Include(p => p.Patients).Include(p => p.Persons).Include(p => p.Addresses).ToList();
            Console.WriteLine("Full List - {0}", fullList.Count());
            foreach (var fact in fullList)
            {
                Console.WriteLine("Fact: {0} \tPatients: {1} \tPersons: {2} \tAddresses: {3}", fact.FactId, fact.Patients.Count(), fact.Persons.Count(),  fact.Addresses.Count());
            }
        }
​
        Console.WriteLine("");
        using (var context = new EntityContext())
        {
            var list = new List<Guid>{_fact1, _fact3};
            var doubleFilter = context.Facts.Where(b => list.Contains(b.FactId))
                .Include(p => p.Patients)
                .Include(p => p.Persons)
                .Include(p => p.Addresses)
                .ToList();
        
            foreach (var fact in doubleFilter)
            {
                fact.Patients = fact.Patients.Where(x => x.ValidTo == DateTime.MaxValue ).ToList();
                fact.Persons = fact.Persons.Where(x => x.ValidTo == DateTime.MaxValue ).ToList();
                fact.Addresses = fact.Addresses.Where(x => x.ValidTo == DateTime.MaxValue).ToList();
            }
            Console.WriteLine("Double Filtered List");
            foreach (var fact in doubleFilter)
            {
                Console.WriteLine("Fact: {0} \tPatients: {1} \tPersons: {2} \tAddresses: {3}", fact.FactId, fact.Patients.Count(), fact.Persons.Count(),  fact.Addresses.Count());
            }
        }
​
        Console.WriteLine("");
        using (var context = new EntityContext())
        {
            var list = new List<Guid>{_fact1, _fact3};
            var doubleFilter = context.Facts.Where(b => list.Contains(b.FactId))
                .IncludeFilter(p => p.Patients.Where(f => f.ValidTo == DateTime.MaxValue))
                // Seems only to fail when I add more than 1 IncludeFilter
                .IncludeFilter(p => p.Persons.Where(f => f.ValidTo == DateTime.MaxValue))
                .IncludeFilter(p => p.Addresses.Where(f => f.ValidTo == DateTime.MaxValue))
                .ToList();
            Console.WriteLine("Double Filtered List - filtred");
            foreach (var fact in doubleFilter)
            {
                    Console.WriteLine("Fact: {0} \tPatients: {1} \tPersons: {2} \tAddresses: {3}", fact.FactId, fact.Patients.Count(), fact.Persons.Count(),  fact.Addresses.Count());
            }
        }
    //FiddleHelper.WriteTable("After Filtering", list);
    }
​
    public static void GenerateData()
    {
        using (var context = new EntityContext())
        {
            context.Facts.Add(new Fact()
            {FactId = _fact1, ValidTo = DateTime.MaxValue});
            context.Facts.Add(new Fact()
            {FactId = _fact2, ValidTo = DateTime.Now});
            context.Facts.Add(new Fact()
            {FactId = _fact3, ValidTo = DateTime.MaxValue});
            context.SaveChanges();
            context.Patients.Add(new Patient()
            {PatientId = Guid.NewGuid(), FactId = _fact1, Content = "Patient1 in Fact1", ValidTo = DateTime.MaxValue, });
            context.Patients.Add(new Patient()
            {PatientId = Guid.NewGuid(), FactId = _fact1, Content = "Patient1 in Fact1", ValidTo = DateTime.Now, });
            context.Patients.Add(new Patient()
            {PatientId = Guid.NewGuid(), FactId = _fact2, Content = "Patient2 in Fact2", ValidTo = DateTime.MaxValue, });
            context.Patients.Add(new Patient()
            {PatientId = Guid.NewGuid(), FactId = _fact2, Content = "Patient2 in Fact2", ValidTo = DateTime.Now, });
            context.Patients.Add(new Patient()
            {PatientId = Guid.NewGuid(), FactId = _fact3, Content = "Patient3 in Fact3", ValidTo = DateTime.MaxValue, });
            context.Persons.Add(new Person()
            {PersonId = Guid.NewGuid(), FactId = _fact1, Content = "Person1 in Fact1", ValidTo = DateTime.MaxValue, });
            context.Persons.Add(new Person()
            {PersonId = Guid.NewGuid(), FactId = _fact1, Content = "Person1 in Fact1", ValidTo = DateTime.Now, });
            context.Persons.Add(new Person()
            {PersonId = Guid.NewGuid(), FactId = _fact2, Content = "Person2 in Fact2", ValidTo = DateTime.Now, });
            context.Persons.Add(new Person()
            {PersonId = Guid.NewGuid(), FactId = _fact2, Content = "Person2 in Fact2", ValidTo = DateTime.MaxValue, });
            context.Persons.Add(new Person()
            {PersonId = Guid.NewGuid(), FactId = _fact3, Content = "Person3 in Fact3", ValidTo = DateTime.Now, });
            context.Addresses.Add(new Address()
            {AddressId = Guid.NewGuid(), FactId = _fact1, Content = "Address1 in Fact1", ValidTo = DateTime.MaxValue, });
            context.Addresses.Add(new Address()
            {AddressId = Guid.NewGuid(), FactId = _fact1, Content = "Address1 in Fact1", ValidTo = DateTime.Now, });
            context.Addresses.Add(new Address()
            {AddressId = Guid.NewGuid(), FactId = _fact2, Content = "Address2 in Fact2", ValidTo = DateTime.MaxValue, });
            context.Addresses.Add(new Address()
            {AddressId = Guid.NewGuid(), FactId = _fact3, Content = "Address3 in Fact3", ValidTo = DateTime.MaxValue, });
            context.Addresses.Add(new Address()
            {AddressId = Guid.NewGuid(), FactId = _fact3, Content = "Address3 in Fact3", ValidTo = DateTime.Now, });
            context.SaveChanges();
        }
    }
​
    public class EntityContext : DbContext
    {
        public EntityContext()
        {
        }
​
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSqlServer(new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()));
            base.OnConfiguring(optionsBuilder);
        }
​
        public DbSet<Fact> Facts
        {
            get;
            set;
        }
​
        public DbSet<Patient> Patients
        {
            get;
            set;
        }
​
        public DbSet<Address> Addresses
        {
            get;
            set;
        }
​
        public DbSet<Person> Persons
        {
            get;
            set;
        }
    }
​
    public class Fact
    {
        public Guid FactId
        {
            get;
            set;
        }
​
        public DateTime ValidTo
        {
            get;
            set;
        }
​
        public IEnumerable<Patient> Patients
        {
            get;
            set;
        }
​
        public IEnumerable<Address> Addresses
        {
            get;
            set;
        }
​
        public IEnumerable<Person> Persons
        {
            get;
            set;
        }
    }
​
    public class Patient
    {
        public Guid PatientId
        {
            get;
            set;
        }
​
        public string Content
        {
            get;
            set;
        }
​
        public DateTime ValidTo
        {
            get;
            set;
        }
​
        public Guid FactId
        {
            get;
            set;
        }
    }
​
    public class Person
    {
        public Guid PersonId
        {
            get;
            set;
        }
​
        public string Content
        {
            get;
            set;
        }
​
        public DateTime ValidTo
        {
            get;
            set;
        }
​
        public Guid FactId
        {
            get;
            set;
        }
    }
​
    public class Address
    {
        public Guid AddressId
        {
            get;
            set;
        }
​
        public string Content
        {
            get;
            set;
        }
​
        public DateTime ValidTo
        {
            get;
            set;
        }
​
        public Guid FactId
        {
            get;
            set;
        }
    }
}

Unhandled exception. System.Exception: Must be a numerical value greater than or equal to 1
at Program.CheckIfValueIsValid(String settingName, String settingValue)
at Program.Main()
Command terminated by signal 6

Last Run:	8:04:48 pm
Compile:	0.005s
Execute:	0.18s
Memory:	5.09Mb
CPU:	0.185s

View IL Code