Entity Framework constrains on navigation properties
===

I want to limit model that are returned by a navigational property. For example, I am using an `AuditInfo` model to log the activity of a model. Once a model is deleted the `DeletedBy` and `Deleted` attributes are set. However since nothing is ever really "deleted" from the database, these models will still be populated in navigational properties referenced by other models.

**AuditInfo Class**

    public class AuditInfo
    {
        [Key]
        public int AuditInfoID { get; set; }

        //Other attributes
    
        public string DeletedBy { get; set; }
    
        public DateTime? Deleted { get; set; }
    }

**Class that has a navigational properties**

    public class BlogPost
    {
        //Other attributes
    
        //Only return Comment where Comment.AuditInfo.Deleted is NULL
        public IList<Comment> Comments { get; set; }
    }
    

**Class that is being audited**    

    public class Comment
    {
        //Other attributes

        public int AuditInfoID { get; set; }
    }

How would I set up a constrain so that only the non-deleted comments (Comment.AuditInfo.Deleted is NULL) from a BlogPost.Comments?