C# Online Compiler | .NET Fiddle

// Entity Framework Plus
// Doc: https://entityframework-plus.net/query-include-filter

// @nuget: EntityFramework
// @nuget: Z.EntityFramework.Plus.EF6

using System;
using System.Linq;
using System.Data.Entity;
using System.Collections.Generic;
using Z.EntityFramework.Plus;

public class Program
{
    public static void Main()
    {
        GenerateData();

        // Update: UPDATE all rows from the database using a LINQ Query without loading entities in the context.
        using (var context = new EntityContext())
        {
            // LOAD orders and the first 10 active related entities.
            var list = context.Orders.Where(o => !o.IsSoftDeleted).IncludeFilter(o => o.Items.Where(y => !y.IsSoftDeleted)
            .OrderBy(y => y.Date)
            .Take(4))
            .ToList();
			
			foreach(var order in list)
			{
				Console.WriteLine("Active order items in {0}: {1}", order.Name, order.Items.Count());
			}
        }
    }

    public static void GenerateData()
    {

        using (var context = new EntityContext())
        {
            context.Orders.Add(new Order() { Name = "Order_A", Date = DateTime.Now.AddDays(-4), IsSoftDeleted = true });
            context.Orders.Add(new Order() { Name = "Order_B", Date = DateTime.Now.AddDays(-5), IsSoftDeleted = true });

            context.SaveChanges();

            context.Items.Add(new InvoiceItem() { Date = DateTime.Now.AddDays(-4), IsSoftDeleted = false, Price = 35, OrderId = 1 });
            context.Items.Add(new InvoiceItem() { Date = DateTime.Now.AddDays(-4), IsSoftDeleted = false, Price = 22, OrderId = 1 });
            context.Items.Add(new InvoiceItem() { Date = DateTime.Now.AddDays(-5), IsSoftDeleted = false, Price = 37, OrderId = 2 });
            context.Items.Add(new InvoiceItem() { Date = DateTime.Now.AddDays(-5), IsSoftDeleted = true, Price = 7, OrderId = 2 });

            context.SaveChanges();
        }
    }

	public class EntityContext : DbContext
	{
		public EntityContext() : base(FiddleHelper.GetConnectionStringSqlServer())
		{

		}
		
		public DbSet<Order> Orders { get; set; }
        public DbSet<InvoiceItem> Items { get; set; }
    }

    public class Order
    {
        public int OrderId { get; set; }
		public string Name { get; set; }
        public DateTime Date { get; set; }
        public bool IsSoftDeleted { get; set; }
        public List<InvoiceItem> Items { get; set; }
    }

    public class InvoiceItem
    {
        public int InvoiceItemId { get; set; }
        public DateTime Date { get; set; }
        public bool IsSoftDeleted { get; set; }
        public int Price { get; set; }
        public int OrderId { get; set; }
    }
}

 
// Entity Framework Plus
// Doc: https://entityframework-plus.net/query-include-filter
​
// @nuget: EntityFramework
// @nuget: Z.EntityFramework.Plus.EF6
​
using System;
using System.Linq;
using System.Data.Entity;
using System.Collections.Generic;
using Z.EntityFramework.Plus;
​
public class Program
{
    public static void Main()
    {
        GenerateData();
​
        // Update: UPDATE all rows from the database using a LINQ Query without loading entities in the context.
        using (var context = new EntityContext())
        {
            // LOAD orders and the first 10 active related entities.
            var list = context.Orders.Where(o => !o.IsSoftDeleted).IncludeFilter(o => o.Items.Where(y => !y.IsSoftDeleted)
            .OrderBy(y => y.Date)

Cached Result

Product: Laptop, Category: Electronics, Price: $1,200.00, Stock: 10