应用nhibernate筛选器时执行左外部联接

我遇到的问题是,如果联接结果为空,筛选器将停止左外部联接的正常工作。

作为一个很简单的例子,我想把所有的音乐家,如果他们在一个乐队,那么他们的乐队

SELECT this_.Name, band2_.Name
FROM   Musicians this_
       left outer join [Band] band2_
         on this_.BandID = band2_.ID
WHERE  (band2_.IsDeleted = 0)

如果音乐家不在乐队里,他们就不会回来了。我想要的是

SELECT this_.Name, band2_.Name
FROM   Musicians this_
       left outer join [Band] band2_
         on this_.BandID = band2_.ID
WHERE  this_.ID = 4894 /* @p3 */
       (band2_.ID IS NULL OR band2_.IsDeleted = 0)

有可能和nhibernate在一起吗?

var projections = new[]
                {
                    Projections.Property("Musician.Name").As("MusicianName"),
                    Projections.Property("Band.Name").As("BandName")
                };

            return this.sessionProvider.GetSession().CreateCriteria<Musician>("Musician")
                .CreateCriteria("Musician.Band", "Band", JoinType.LeftOuterJoin)
                .SetProjection(projections)
                .Add(Restrictions.Eq("Musician.ID", parameters.MusicianId))
                .SetResultTransformer(Transformers.AliasToBean<MusicianDetailsResult>())
                .UniqueResult<MusicianDetailsResult>();

过滤器是用氟恩尼纤维酸盐定义的

this.WithName(FilterName).WithCondition("IsDeleted = 0")