NHibernateQueries
NHibernate Query Samples
SQL Function call
Vertrag v = null;
VertragServiceAktuell vsa = null;
Kostenart kav = null;
Kostenart kavsa = null;
var query = Session.QueryOver<BelegGruppe>()
.Inner.JoinAlias(x => x.Vertrag, () => v)
.Inner.JoinAlias(() => v.Kostenart, () => kav)
.Inner.JoinAlias(() => v.VertragServicesAktuell, () => vsa)
.Left.JoinAlias(() => vsa.Kostenart, () => kavsa)
.Where(x => x.Id == belegGruppeId)
.Where(() => vsa.Service.Id == serviceId)
.Select(Projections.SqlFunction("coalesce",
NHibernateUtil.String,
Projections.Property(() => kavsa.Nummer),
Projections.Property(() => kav.Nummer)));
return query.SingleOrDefault<string>();