I suspect Diego wants to see the code (hql, linq etc) that you use to generate the code, not the SQL itself...
Many Thanks Richard From: [email protected] [mailto:[email protected]] On Behalf Of Diego Dias Sent: 14 April 2010 14:55 To: [email protected] Subject: Re: [nhusers] Mapping Nhibernate In previous messages, but here too: 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 2010/4/14 Diego Mijelshon <[email protected]> Where's the code that generates the query? Diego On Wed, Apr 14, 2010 at 10:49, Diego Dias <[email protected]> wrote: 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] <mailto: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] <mailto: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] <mailto: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. -- 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.
