ErcanOPAK.com

The old way:

foreach (var user in users)
    user.IsActive = false;
await ctx.SaveChangesAsync();

The modern way:

await ctx.Users.Where(x => x.IsActive)
    .ExecuteUpdateAsync(set => set.SetProperty(p => p.IsActive, false));

⚡ Benefits

• 🚀 Single SQL statement

• 🧼 No tracking overhead

• 💾 Saves CPU + DB roundtrips

• 🧩 Perfect for batch jobs + cron workers