I have the entity configured to always be queried with with property "DELETED"='N'. In EF 6, I could do:...modelBuilder.Entity<MyEntity>().Map(m => m.Requires("DELETED").HasValue("N"))...SELECT `n`.`id`.
FROM `OtherEntity` AS `n`
LEFT JOIN `MyEntity` as ...