Someone?
2010/4/13 Diego Dias <[email protected]>
> Hi, guys.
>
> I'm with a problem with the query that NHibernate generates. My
> mapping is like bellow and I'm using ActiveRecord to do mapping:
>
> 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
> "nhusers" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<nhusers%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"nhusers" 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/nhusers?hl=en.
