I use ICriteria and is query I get in sql profile. 2010/4/13 Markus Zywitza <[email protected]>
> What is the query (in HQL or LINQ)? > > -Markus > > 2010/4/13 Diego Dias <[email protected]> > >> 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]<castle-project-users%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/castle-project-users?hl=en. >> > > -- > 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]<castle-project-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/castle-project-users?hl=en. > -- 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.
