Poorna Soysa

💡.𝗡𝗘𝗧 𝗧𝗶𝗽 - 𝙄𝙢𝙥𝙡𝙚𝙢𝙚𝙣𝙩𝙞𝙣𝙜 𝙎𝙤𝙛𝙩 𝘿𝙚𝙡𝙚𝙩𝙚 𝙞𝙣 𝙀𝙁 𝘾𝙤𝙧𝙚

Soft delete looks simple on paper.

Until you hit production.

Then you start seeing:
🔸 Deleted records showing up in queries
🔸 Audit trails that make no sense
🔸 Bulk operations skipping your delete logic entirely
🔸 Raw SQL ignoring your global filters

I've seen teams spend days debugging issues that came from a poorly implemented soft delete.

So I wrote a practical guide on doing it properly in EF Core.

📌 What it covers:

🔸 Global query filters — EF Core hides deleted rows automatically
🔸 Interceptors vs SaveChanges override — when to use which
🔸 IgnoreQueryFilters() — for admin views and restore logic
🔸 Filtered indexes — because soft delete hits every query
🔸 Relationships — what happens to related data when a parent is deleted?

The goal was simple:
Keep the DbContext clean. Make soft delete predictable. No surprises in production.

If working with EF Core in real-world systems, this is something worth getting right early.

Full guide here: 👇
https://lnkd.in/gRcBPRPZ

💬 How are you handling soft delete in your projects? Comment below 👇

♻️ If you found this helpful, consider reposting to help others in the community.

👉 Follow me, Poorna Soysa, and hit the 🔔 on my profile so you don’t miss upcoming .NET tips and deep dives.