("qrySeriePorEmpresaID", = ddlSede.SelectedItem.Value); ddlSerie.DataSource =3D SerieEmpresa; ddlSerie.DataBind(); I'm checking the queries requested in my SQL Server with Profiler and = the select "qryCursoPorID" lazyloaded on the result is executed (N + 1 = problem is taking place), despite the lazyload attribute. I don't use = any Curso property or anything, actually checking the SerieEmpresa = object right after the filling of that object brings me the whole object = tree. Lazyloaded is being completly ignored. I'm using DataMapper 1.5.1. Am I = doing something wrong or fogetting something ? thank you Anderson Fortaleza ------=_NextPart_000_0033_01C787F7.308FC9B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi, I have the following = ResultMap:

And the following = statement:

    <select=20 id=3D"qrySeriePorEmpresaID" resultMap=3D"rmSerie"=20 parameterClass=3D"int">
     =20 <![CDATA[
        SELECT = DISTINCT=20 Serie.SerieID, Serie.Descricao, Serie.Abreviacao, Serie.Sigla, = Serie.CursoID,=20 Serie.TurnoIntegral
        FROM = V_Serie=20 Serie
         JOIN V_Curso = Curso ON=20 (Serie.CursoID =3D=20 Curso.CursoID)
         JOIN=20 V_Empresa Empresa ON (Curso.EmpresaID =3D=20 Empresa.EmpresaID)
         = JOIN=20 V_Turma Turma ON (Turma.SerieID =3D=20 Serie.SerieID)
         JOIN=20 V_PeriodoLetivo PeriodoLetivo ON (Turma.PeriodoLetivoID =3D=20 PeriodoLetivo.PeriodoLetivoID)
      &nb= sp;=20 WHERE Empresa.EmpresaID =3D=20 #EmpresaID#
          = AND=20 Curso.TipoCurso =3D = 'N'
         =20 AND Ano =3D=20 YEAR(GETDATE())
         = AND=20 TurnoIntegral =3D 0
        ORDER = BY=20 Serie.Sigla
      ]]> =20
    </select>

I call the select statement in my=20 code:

IList<Serie> SerieEmpresa =3D=20 Mapper.Instance().QueryForList<Serie>("qrySeriePorEmpresaID",=20 ddlSede.SelectedItem.Value);

ddlSerie.DataSource =3D=20 SerieEmpresa;
ddlSerie.DataBind();

I'm checking the queries requested in = my SQL Server=20 with Profiler and the select "qryCursoPorID" lazyloaded on the result is = executed (N + 1 problem is taking place), despite the lazyload = attribute. I=20 don't use any Curso property or anything, actually checking the = SerieEmpresa=20 object right after the filling of that object brings me the whole object = tree.

Lazyloaded is being completly ignored. = I'm using=20 DataMapper 1.5.1. Am I doing something wrong or fogetting something=20 ?

thank you

Anderson = Fortaleza

------=_NextPart_000_0033_01C787F7.308FC9B0--