Good morning, guys.
I'm with a problem with the query that NHibernate generates. My mapping is
like bellow:
public class Matricula
{
[BelongsTo("IdTurma", NotNull=True)]
public Turma {get;set;}
}
public class Turma
{
[BelongsTo("IdCurso", NotNull=True)]
public Curso {get;set;}
}
public class Curso
{
[PrimaryKey("IdCurso", Generator=PrimaryKeyType.Identity)]
public int IdCurso{get;set;}
}
The problem is: The Nh generates the query with left where should be inner.
Between Matricula and Turma they makes inner, but between Turma and Curso
they makes left outer. What's problem? What's wrong?
My query:
SELECT this_.IdMatricula as IdMatric1_122_14_,
this_.IdTurma as IdTurma122_14_,
this_.IdUsuario as IdUsuario122_14_,
turma3_.IdTurma as IdTurma25_0_,
turma3_.idTurmaStatus as idTurmaS2_25_0_,
turma3_.IdCurso as IdCurso25_0_,
curso4_.IdCurso as IdCurso31_1_,
curso4_.idStatus as idStatus31_1_,
curso4_.IdTipoCurso as IdTipoC10_31_1_,
curso4_.IdOrganization as IdOrgan11_31_1_,
statuscurs5_.idStatus as idStatus54_2_,
statuscurs5_.strStatus as strStatus54_2_,
tipocurso6_.strDescricao as strDescr2_125_3_,
padraocomu7_.strNmPadrao as strNmPad2_103_4_,
organizati8_.Id_Organization as Id1_87_5_,
organizati8_.strTitle as strTitle87_5_,
cursoprese9_.IdCurso as IdCurso6_6_,
turmastatu10_.idTurmaStatus as idTurmaS1_91_7_,
usuario1_.IdUsuario as IdUsuario116_10_,
organizaca14_.idOrganizacao as idOrgani1_83_11_,
cargo15_.idCargo as idCargo7_12_,
matriculas16_.idMatriculaStatus as idMatric1_15_13_
FROM tracking.matriculas this_
inner join cursos.turmas turma3_ on this_.IdTurma=turma3_.IdTurma
left outer join schemadbo.cursos curso4_ on
turma3_.IdCurso=curso4_.IdCurso
left outer join schemadbo.status statuscurs5_ on
curso4_.idStatus=statuscurs5_.idStatus
left outer join schemadbo.tipos tipocurso6_ on
curso4_.IdTipoCurso=tipocurso6_.IdTipoCurso
left outer join schemadbo.PadraoComunicacao padraocomu7_ on
curso4_.IdPadraoComunicacao=padraocomu7_.IdPadrao
left outer join schemadbo.lms_cp_organizations organizati8_ on
curso4_.IdOrganization=organizati8_.Id_Organization
left outer join schemadbo.CursosPresenciais cursoprese9_ on
curso4_.IdCurso=cursoprese9_.IdCurso
left outer join schemadbo.turmasstatus turmastatu10_ on
turma3_.idTurmaStatus=turmastatu10_.idTurmaStatus
left outer join schemadbo.turmaspresenciais turmaprese11_ on
turma3_.IdTurma=turmaprese11_.idTurma
inner join schemadbo.matriculasresumo matricular12_ on
this_.IdMatricula=matricular12_.IdMatricula
inner join schemadbo.usuarios usuario1_ on
this_.IdUsuario=usuario1_.IdUsuario
left outer join schemadbo.Organizacoes organizaca14_ on
usuario1_.idOrganizacao=organizaca14_.idOrganizacao
left outer join schemadbo.cargos cargo15_ on
usuario1_.idCargo=cargo15_.idCargo
inner join schemadbo.matriculasstatus matriculas16_ on
this_.idMatriculaStatus=matriculas16_.idMatriculaStatus
WHERE this_.IdTurma = @p0
--
You received this message because you are subscribed to the Google Groups
"Castle Project Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en.
