EF Plus - aktualizacja wielu obiektów jednym zapytaniem

BaseModel.cs

public class BaseModel
{
    public BaseModel()
    {
        IsActive = true;
    }

    public int Id { get; set; }

    public bool IsActive { get; set; }
}

Category.cs

public class Category : BaseModel
{
    public string Name { get; set; }

    public virtual ICollection<Product> Products { get; set; }
}

DeleteWithEFPlus.cs

private static void DeleteWithEFPlus()
{
    using (var db = new DataContext())
    {
        using (var transaction = db.Database.BeginTransaction())
        {
            var category = db.Categories.FirstOrDefault(c => c.IsActive);

            if (category == null)
            {
                return;
            }

            category.IsActive = false;

            db.Products.Where(p => p.CategoryId == category.Id)
                .Delete();

            db.SaveChanges();

            transaction.Commit();
        }
    }
}

Product.cs

public class Product : BaseModel
{
    public string Name { get; set; }

    public int CategoryId { get; set; }

    public virtual Category Category { get; set; }
}

SoftDelete.cs

private static void SoftDelete()
{
    using (var db = new DataContext())
    {
        var category = db.Categories.FirstOrDefault(c => c.IsActive);

        if (category == null)
        {
            return;
        }

        category.IsActive = false;

        foreach (var product in category.Products)
        {
            product.IsActive = false;
        }

        db.SaveChanges();
    }
}

SoftDeleteWithEFPlus.cs

private static void SoftDeleteWithEFPlus()
{
    using (var db = new DataContext())
    {
        var category = db.Categories.FirstOrDefault(c => c.IsActive);

        if (category == null)
        {
            return;
        }

        category.IsActive = false;

        db.Products.Where(p => p.CategoryId == category.Id)
            .Update(p => new Product() { IsActive = false });

        db.SaveChanges();
    }
}

SoftDeleteWithEFPlusWithTransaction.cs

private static void SoftDeleteWithEFPlusWithTransaction()
{
    using (var db = new DataContext())
    {
        using (var transaction = db.Database.BeginTransaction())
        {
            var category = db.Categories.FirstOrDefault(c => c.IsActive);

            if (category == null)
            {
                return;
            }

            category.IsActive = false;

            db.Products.Where(p => p.CategoryId == category.Id)
                .Update(p => new Product() { IsActive = false });

            db.SaveChanges();

            transaction.Commit();
        }
    }
}