Cache oraz Future z EF Plus

WithCache.cs

public class CacheDemo
{
    public void Run()
    {
        WithCache();
    }

    private void WithCache()
    {
        using (var db = new DataContext())
        {
            var categories = db.Categories.Where(c => c.IsActive).FromCache().ToList();

            Console.WriteLine($"Categories count: {categories.Count}");

            categories = db.Categories.Where(c => c.IsActive).FromCache().ToList();

            Console.WriteLine($"Categories count: {categories.Count}");
        }
    }
}

WithFuture.cs

public class FutureDemo
{
    public void Run()
    {
        WithFuture();
    }

    private void WithFuture()
    {
        using (var db = new DataContext())
        {
            var categoryQuery = db.Categories.Where(c => c.Id == 1).Future();

            var productQuery = db.Products.Where(c => c.Id == 1).Future();

            var category = categoryQuery.FirstOrDefault();

            var product = productQuery.FirstOrDefault();

            Console.WriteLine($"Category: {category.Name}, Product: {product.Name}");
        }
    }
}

WithoutCache.cs

public class CacheDemo
{
    public void Run()
    {
        WithoutCache();
    }

    private void WithoutCache()
    {
        using (var db = new DataContext())
        {
            var categories = db.Categories.Where(c => c.IsActive).ToList();

            Console.WriteLine($"Categories count: {categories.Count}");

            categories = db.Categories.Where(c => c.IsActive).ToList();

            Console.WriteLine($"Categories count: {categories.Count}");
        }
    }
}

WithoutCache.sql

SELECT [Extent1].[Id]       AS [Id],
       [Extent1].[Name]     AS [Name],
       [Extent1].[IsActive] AS [IsActive]
FROM   [dbo].[Categories] AS [Extent1]
WHERE  [Extent1].[IsActive] = 1

WithoutFuture.cs

public class FutureDemo
{
    public void Run()
    {
        WithoutFuture();
    }

    private void WithoutFuture()
    {
        using (var db = new DataContext())
        {
            var categoryQuery = db.Categories.Where(c => c.Id == 1);

            var productQuery = db.Products.Where(c => c.Id == 1);

            var category = categoryQuery.FirstOrDefault();

            var product = productQuery.FirstOrDefault();

            Console.WriteLine($"Category: {category.Name}, Product: {product.Name}");
        }
    }
}