我在ef2.0中使用了全局過濾builder.Entity<T>().HasQueryFilter(e => e.TenantId == _tenantId && !e.IsDeleted);這樣造成一個問題 在關(guān)聯(lián)載入include時關(guān)聯(lián)查詢也將應(yīng)用過濾條件,生成語句如下:SELECT *FROM `Message` AS `m`INNER JOIN (    SELECT *    FROM `User` AS `u`    WHERE (`u`.`IsDeleted` = 0) AND (`u`.`TenantId` = @___tenantId_0)) AS `t` ON `m`.`SenderId` = `t`.`Id`WHERE (`m`.`IsRead` = 0) AND (`m`.`ReceiverId` = @___mmsSession_UserId_0)而我的初衷是關(guān)聯(lián)查詢不應(yīng)該應(yīng)用過濾條件,因為用戶雖然刪除了,但是Message顯示的時候還是需要知道這個用戶的麻煩各位, 有什么好的處理方法嗎?