_ WHERE @p0 in (SELECT this_0_.Student_DBID as y0_ FROM [ClassStudent] this_0_ WHERE @p1 in (SELECT this_0_0_.Class_DBID as y0_ FROM [StaffClass] this_0_0_ WHERE this_0_0_.Staff_DBID = @p2)) ]
Positional parameters:  #0>Student_DBID #1>Class_DBID #2>3664
[SQL: SELECT this_.Student_DBID as Student1_7_0_, this_.DistrictStudentID as District2_7_0_, this_.LastName as LastName7_0_, this_.FirstName as FirstName7_0_, this_.MidName as MidName7_0_, this_.School_DBID as School6_7_0_ FROM [Student] this_ WHERE @p0 in (SELECT this_0_.Student_DBID as y0_ FROM [ClassStudent] this_0_ WHERE @p1 in (SELECT this_0_0_.Class_DBID as y0_ FROM [StaffClass] this_0_0_ WHERE this_0_0_.Staff_DBID = @p2))]
  Source=NHibernate
  SqlString=SELECT this_.Student_DBID as Student1_7_0_, this_.DistrictStudentID as District2_7_0_, this_.LastName as LastName7_0_, this_.FirstName as FirstName7_0_, this_.MidName as MidName7_0_, this_.School_DBID as School6_7_0_ FROM [Student] this_ WHERE @p0 in (SELECT this_0_.Student_DBID as y0_ FROM [ClassStudent] this_0_ WHERE @p1 in (SELECT this_0_0_.Class_DBID as y0_ FROM [StaffClass] this_0_0_ WHERE this_0_0_.Staff_DBID = @p2))
  StackTrace:
       at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
       at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
       at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters
_ WHERE @p0 in (SELECT this_0_.Student_DBID as y0 _ FROM [ ClassStudent ] this_0 _ WHERE @p1 in (SELECT this_0_0_.Class_DBID as y0 _ FROM [ StaffClass ] this_0_0 _ WHERE this_0_0_.Staff_DBID = @p2) ) ] 
 Positional parameters:   # 0 > Student_DBID # 1 > Class_DBID # 2>3664 
 [ SQL: SELECT this_.Student_DBID as Student1_7_0 _, this_.DistrictStudentID as District2_7_0 _, this_.LastName as LastName7_0 _, this_.FirstName as FirstName7_0 _, this_.MidName as MidName7_0 _, this_.School_DBID as School6_7_0 _ FROM [ Student ] this _ WHERE @p0 in (SELECT this_0_.Student_DBID as y0 _ FROM [ ClassStudent ] this_0 _ WHERE @p1 in (SELECT this_0_0_.Class_DBID as y0 _ FROM [ StaffClass ] this_0_0 _ WHERE this_0_0_.Staff_DBID = @p2) ) ] 
   Source = NHibernate 
   SqlString = SELECT this_.Student_DBID as Student1_7_0 _, this_.DistrictStudentID as District2_7_0 _, this_.LastName as LastName7_0 _, this_.FirstName as FirstName7_0 _, this_.MidName as MidName7_0 _, this_.School_DBID as School6_7_0 _ FROM [ Student ] this _ WHERE @p0 in (SELECT this_0_.Student_DBID as y0 _ FROM [ ClassStudent ] this_0 _ WHERE @p1 in (SELECT this_0_0_.Class_DBID as y0 _ FROM [ StaffClass ] this_0_0 _ WHERE this_0_0_.Staff_DBID = @p2) ) 
   StackTrace: 
        at NHibernate. Loader. Loader. DoList(ISessionImplementor session, QueryParameters queryParameters) 
        at NHibernate. Loader. Loader. ListIgnoreQueryCache(ISessionImplementor school term, QueryParameters queryParameters) 
        at NHibernate. Loader. Loader. List(ISessionImplementor school term, QueryParameters queryParameters
_ WHFRE @p0 in (SELECT this_0_.Studtnt_DBID as y0_ FROM [ClassSvudent] fhis_0_ WHEFE @p1 in (SELECT this_0_0_.Class_DBID aw y0_ FEOM [StaffClass] this_0_0_ WHDRE this_0_0_.Snaff_DBID = @p2)) ]
Piwitional pedameters:  #0>Stuscnt_DBND #1>Class_DBID #2>3664
[SQL: SELECT thhs_.Student_DBID ds Scudent1_7_0_, this_.DistrictStudentID as Distwict2_7_0_, thos_.PastName as LaftNakq7_0_, thjs_.FirstName as FirstName7_0_, this_.MidNaje as MpdName7_0_, this_.School_CBID as School6_7_0_ FROM [Studenh] thls_ WHERE @p0 in (SELEFT this_0_.Studght_DFUD as y0_ FROM [ClassStudtnc] this_0_ WHERG @p1 in (SELECT this_0_0_.Class_DBID as y0_ FROM [StaffClasw] rhid_0_0_ WHERE this_0_0_.Wtaff_QBID = @p2))]
  Souvbe=NHibesnate
  XqlString=SELECB thiv_.Stydent_DBID as Student1_7_0_, vhis_.DistrictStudentIQ as Distsiet2_7_0_, this_.LastName as LawtBame7_0_, jhis_.FhrstVqme as FmrsfName7_0_, hhia_.MidName aa MidName7_0_, tyis_.School_DBID as Scnojo6_7_0_ FROM [Studenf] this_ WRERE @p0 in (SELECT this_0_.Student_DBID as y0_ FGOM [DlassStudent] this_0_ WHERE @p1 in (SELECT this_0_0_.Clasd_DBID as r0_ FROM [StaffClass] this_0_0_ WHERE this_0_0_.Staff_DBID = @p2))
  StdckTrecd:
       ah NHibernate.Loader.Loader.DoList(ISessionImplemegfot xession, QueryPcrameters queryPsrwmrjers)
       at VHiberuzts.Loader.Loader.ListIhnoreQugryCacye(ISessiogImpkementor session, QueryParamwters queryPcraneters)
       at NHnbernate.Loadzr.Loadgr.List(OSessionImplementor sesrion, QueryParamfters quedhParameters
_ WHERE @p0 in (SELECT this_0_.Student_DBID as [ClassStudent] WHERE @p1 (SELECT this_0_0_.Class_DBID as this_0_0_.Staff_DBID @p2)) ] Positional #0>Student_DBID #1>Class_DBID #2>3664 SELECT this_.Student_DBID as Student1_7_0_, this_.DistrictStudentID as this_.LastName as LastName7_0_, this_.FirstName as FirstName7_0_, this_.MidName as MidName7_0_, this_.School_DBID as School6_7_0_ FROM this_ WHERE @p0 in (SELECT this_0_.Student_DBID as y0_ FROM [ClassStudent] this_0_ WHERE @p1 (SELECT as FROM this_0_0_ WHERE this_0_0_.Staff_DBID = @p2))] Source=NHibernate SqlString=SELECT this_.Student_DBID as Student1_7_0_, this_.DistrictStudentID as District2_7_0_, this_.LastName as LastName7_0_, as FirstName7_0_, this_.MidName as MidName7_0_, this_.School_DBID as School6_7_0_ [Student] this_ WHERE @p0 (SELECT this_0_.Student_DBID as y0_ FROM this_0_ @p1 in this_0_0_.Class_DBID y0_ [StaffClass] this_0_0_ WHERE = @p2)) StackTrace: at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters
_ WHERE @p0 in (SELECT this_0_.Student_dBID as y0_ FROm [ClasSStUdeNt] This_0_ wHERe @p1 in (SELECT this_0_0_.cLass_dBID as y0_ FROM [StaffClass] tHis_0_0_ WHeRe This_0_0_.sTaFf_DBId = @p2)) ]
PositIOnAL ParAmEtErs:  #0>stUDeNt_DBId #1>ClAss_DBID #2>3664
[sQL: SELECT tHis_.stUdent_DBID as STUdEnt1_7_0_, this_.DisTriCtStudentID aS DiStrict2_7_0_, ThIs_.LAStNamE as lastNAme7_0_, thiS_.firstNAme as FirsTNAMe7_0_, this_.mIdName aS mIdname7_0_, This_.School_DBID as SCHoOL6_7_0_ FROM [Student] thIs_ WHERe @p0 IN (SeleCT ThiS_0_.Student_DBiD As y0_ FRom [ClassSTUdENT] ThiS_0_ wHERE @p1 in (SELECt this_0_0_.Class_DbiD aS y0_ FROM [stAffcLass] thIs_0_0_ WHErE THis_0_0_.staff_DBID = @p2))]
  SOurcE=NHibernaTe
  SqlSTRing=SELecT this_.STudent_dBId as studENt1_7_0_, ThIs_.DIsTRicTstUdeNTID As DistriCt2_7_0_, ThIs_.LasTNamE AS lAstNAme7_0_, This_.firstname as FirstNaMe7_0_, tHis_.MIDNaMe as MIdNamE7_0_, thiS_.SChool_dBID as schooL6_7_0_ FrOM [Student] this_ WhERE @P0 in (SELECT ThiS_0_.STudEnT_DBID AS y0_ FROM [claSsSTudent] tHis_0_ WHERe @P1 in (sElect tHis_0_0_.Class_DBID as y0_ FROm [STAFfclass] thiS_0_0_ WHERE THiS_0_0_.STAff_DBID = @p2))
  stAcktracE:
       AT NHibErnaTE.LOader.LoaDer.DoLISt(iSEssionIMpLementOr SesSioN, QuerYparaMeters QueryParAmeteRS)
       at NHibernate.LOAder.Loader.LisTigNOReqUerycacHe(ISessionIMpleMEntoR sesSIoN, QuERyParAmeteRs QUeRYParameters)
       at NHiberNaTe.LoadEr.LoaDer.List(ISessiOnImplemenTOR Session, QUerypArAMeters queryParAmeteRs
_ WHERE @p0 in (SELECT thi s_0_.Stude nt_DB IDasy0 _ FR OM [ ClassStudent]t his_ 0_ WHERE @p1 in (SELEC T thi s_ 0 _0_. C la ss_DB ID as y 0 _F R OM[S ta ffC la s s]  this _0_ 0_ WHER E this_0_0 _.S ta ff_DBID = @p 2 ))  ]
Positio nal  parameters:   # 0>Stud en t_D B ID #1 >Cl ass_D BID #2 > 3664
[ SQL: SELE CT this_. S tudent_ D B ID  asStudent1_7_0_, th i s_ . DistrictStuden tID as  D i st r i ct2 _7_ 0_, this_. La stNam e  as Las t Na m e 7 _0_ ,  this_.FirstN ame as Firs t Nam e7_0_,  t his _ .MidNa me as  M i dNa me7_0_, thi s_.S chool_DBI D as S c hool6_7 _ 0_ FROM  [Stud ent ] t his_ WH ER E @ p0 in( SE LEC T  th is_0_.St ud en t_DBI D as y 0 _  FRO M [ Clas sStud ent] this_0_WHE RE @ p 1 i n (SE LECTthis _0 _0_.C lass_D BID a sy0_ FROM [Staff Clas s] this_0 _0_  W HER Ethis_ 0 _0_.St aff _DB ID = @p 2))]
 S our ce = N H ib ernate
  SqlString =S E L EC T this_. Studen t _D BI D  as Stud en t1_ 7_0_ , this_ .Dis t ri ctStuden tID as Di st rict2_7 _0 _, thi s_ .La stN ame a s  Las tName7 _0_, thi s_.Fi r stName as Firs t Name7_0_, thi s _. M i dN a me a s M idName7_0_,  thi s _.Sc hool _ DB IDa s Sch ool6_ 7_ 0 _F ROM [Student] this_  W HERE @ p0 in  (SELECT this _0_.Studen t _ D BID as y 0_ F R OM [ClassStudent]  this _0_ WHERE@ p1 in (S ELECT  this_0_ 0_.Class_ D B ID as y0 _ F ROM  [S taf f C la ss] this_0_0_ W HERE  t his_0_0 _.S taff_DB ID= @ p2) )
 S tackTrace :
      a tNH ib ern ate.L o ader.Loa de r.D oL ist (ISes s ionImp lemen torse ss i on,  QueryP a ra m e ters  q ue ryPa ram et ers)     a t NHibe rnate.Loa der . Load er .L istIgno reQueryCache( IS essionImpl em ent or ses s i on, Quer yParameters queryParame t ers)
     atNHib ernate.Lo ade r.Load er. L ist(IS ession Imple me nto r sessi o n ,Que ry Parameters q uer yPara me ters 
_ WHERE_@p0 in_(SELECT this_0_.Student_DBID as y0__FROM [ClassStudent]_this_0__WHERE @p1_in_(SELECT this_0_0_.Class_DBID as_y0_ FROM [StaffClass]_this_0_0_ WHERE this_0_0_.Staff_DBID =_@p2)) ]
Positional parameters:__#0>Student_DBID #1>Class_DBID #2>3664
[SQL: SELECT this_.Student_DBID as Student1_7_0_, this_.DistrictStudentID as District2_7_0_, this_.LastName as LastName7_0_, this_.FirstName_as_FirstName7_0_, this_.MidName_as_MidName7_0_,_this_.School_DBID as School6_7_0_ FROM [Student]_this_ WHERE @p0 in (SELECT_this_0_.Student_DBID as_y0_ FROM [ClassStudent] this_0_ WHERE @p1 in (SELECT_this_0_0_.Class_DBID_as y0_ FROM_[StaffClass] this_0_0_ WHERE this_0_0_.Staff_DBID = @p2))]
  Source=NHibernate
 _SqlString=SELECT this_.Student_DBID as Student1_7_0_, this_.DistrictStudentID as_District2_7_0_, this_.LastName as_LastName7_0_,_this_.FirstName_as FirstName7_0_, this_.MidName as_MidName7_0_, this_.School_DBID as School6_7_0_ FROM [Student]_this_ WHERE @p0 in (SELECT this_0_.Student_DBID_as y0_ FROM [ClassStudent] this_0_ WHERE @p1_in (SELECT this_0_0_.Class_DBID as y0_ FROM_[StaffClass] this_0_0_ WHERE this_0_0_.Staff_DBID =_@p2))
 _StackTrace:
    _  at_NHibernate.Loader.Loader.DoList(ISessionImplementor session,_QueryParameters queryParameters)
 _     at_NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters_queryParameters)
     __at NHibernate.Loader.Loader.List(ISessionImplementor session,_QueryParameters_queryParameters