Ignore all entities with a IsDeleted flag-column set

Question

Our products have a IsDeleted flag, so the products stay in the database when deleting them. (They are just flagged as deleted)

It is annoying to always check the deleted flag when querying the server (where c.IsDeleted == False && ...). Is there a way to centralize this? In the DbContainer / Context or somewhere else?

Answer 1

Another solution is to use an extension method. This won't exactly centralize, but will encapsulate.

public static IQueryable<T> Undeleted(this IQueryable<T> queryable)
    where T : ISoftDeletable
{
    return queryable.Where(x => !x.IsDeleted);
}

Interface:

public interface ISoftDeletable
{
    bool IsDeleted { get; }
}

Usage:

var undeleteds = myEntitySet.Undeleted().ToArray();