I am trying to make an aplication that persists the folowing objects:
Department; Professor; UniversityClass; Student. The relations between are given by the folowing image:
The problem apears when I want to remove a UniversityClass from one Department. In this model the UniversityClass can not exist if it is not in a department. When I remove a UniversityClass from the Department colection I want it to be deleted from DB as well. To achive this I am using:
cascade="all-delete-orphan" but it is not working. I am receiving the folowing exception: "You may not dereference an collection with cascade="all-delete-orphan""
NHibernate version: 1.0.
Mapping documents:
Department.hbm.xml
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="nhRegistration.BusinessObjects.Department, BusinessObjects"
table="department">
<id name="Id" column="deptid" unsaved-value="0">
<generator class="identity" />
</id>
<property name="Name" column="Name"/>
<set name="ClassesUntyped" inverse="true" cascade="all-delete-orphan">
<key column="deptid"/>
<one-to-many class="nhRegistration.BusinessObjects.UniversityClass,BusinessObjects"/>
</set>
<set name="ProfessorsUntyped" table="departmentprofessor">
<key column="deptid"/>
<many-to-many class="nhRegistration.BusinessObjects.IPerson, BusinessObjects"
column="personid"/>
</set>
</class>
</hibernate-mapping>
UniversityClass.hbm.xml
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="nhRegistration.BusinessObjects.UniversityClass, BusinessObjects"
table="universityclass">
<id name="Id" column="classId" unsaved-value="0">
<generator class="identity" />
</id>
<property name="Name" column="classname" />
<property name="StartDate" column="StartDate"/>
<many-to-one name="Department" not-null="true"
class="nhRegistration.BusinessObjects.Department,BusinessObjects"
column="deptid"/>
<many-to-one name="Professor" not-null="true"
class="nhRegistration.BusinessObjects.IPerson,BusinessObjects"
column="profid"/>
<set name="StudentsUntyped" table="StudentClass">
<key column="classid"/>
<many-to-many class="nhRegistration.BusinessObjects.IPerson, BusinessObjects"
column="personid"/>
</set>
</class>
</hibernate-mapping>
IPerson.hbm.xml
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="nhRegistration.BusinessObjects.IPerson, BusinessObjects" table="people">
<id name="Id" column="personid" unsaved-value="0">
<generator class="identity" />
</id>
<discriminator column="persontype" />
<property name="Name" column="Name"/>
<!--PROFESSOR-->
<subclass name="nhRegistration.BusinessObjects.Professor, BusinessObjects"
discriminator-value="professor">
<property name="Code" column="identifier" />
<set name="DepartmentsUntyped" table="departmentprofessor" lazy="false" inverse="true">
<key column="personid"/>
<many-to-many class="nhRegistration.BusinessObjects.Department,BusinessObjects"
column="deptid"/>
</set>
<set name="ClassesUntyped" lazy="false" inverse="true">
<key column="profid"/>
<one-to-many class="nhRegistration.BusinessObjects.UniversityClass,BusinessObjects"/>
</set>
</subclass>
<!--STUDENT-->
<subclass name="nhRegistration.BusinessObjects.Student, BusinessObjects"
discriminator-value="student">
<property name="Ssn" column="identifier"/>
<set name="ClassesUntyped" table="StudentClass" lazy="false" inverse="true">
<key column="personid"/>
<many-to-many class="nhRegistration.BusinessObjects.UniversityClass,BusinessObjects"
column="classid"/>
</set>
</subclass>
</class>
</hibernate-mapping>
Code between sessionFactory.OpenSession() and session.Close():
ITransaction tx = null;
ISession session = null;
try
{
session = NHdbManager.Factory.OpenSession();
tx = session.BeginTransaction();
Department dep = session.Load(typeof(Department),7) as Department;
UniversityClass uc = dep.Classes[0];
dep.Classes.Remove(uc);
uc.Department = null;
session.Delete(uc);
tx.Commit();
}
catch (Exception ex)
{
if (tx != null)
tx.Rollback();
throw new Exception("Object not saved. Error message: " + ex.Message);
}
finally
{
session.Close();
}
Full stack trace of any exception that occurs:
StackTrace " at NHibernate.Impl.SessionImpl.UpdateUnreachableCollection(PersistentCollection coll)\r\n at NHibernate.Impl.SessionImpl.FlushCollections()\r\n at NHibernate.Impl.SessionImpl.FlushEverything()\r\n at NHibernate.Impl.SessionImpl.Flush()\r\n at NHibernate.Transaction.AdoTransaction.Commit()\r\n at Test.Program.Test1() in D:\\Work\\2005WForm\\nhRegistration\\Test\\Program.cs:line 32" string
Name and version of the database you are using:
SQL Server 2000
Debug level Hibernate log excerpt:
2006-01-23 13:56:24,205 [2844] DEBUG NHibernate.Cfg.Environment [(null)] <(null)> - no hibernate settings in app.config/web.config were found
2006-01-23 13:56:24,237 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - searching for mapped documents in assembly: DataLayer
2006-01-23 13:56:24,237 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - Found mapping documents in assembly: DataLayer.Mapings.UniversityClass.hbm.xml
2006-01-23 13:56:24,299 [2844] INFO NHibernate.Dialect.Dialect [(null)] <(null)> - Using dialect: NHibernate.Dialect.MsSql2000Dialect
2006-01-23 13:56:24,330 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping class: nhRegistration.BusinessObjects.UniversityClass -> universityclass
2006-01-23 13:56:24,377 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Id -> classId, type: Int32
2006-01-23 13:56:24,393 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Name -> classname, type: String
2006-01-23 13:56:24,393 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: StartDate -> StartDate, type: DateTime
2006-01-23 13:56:24,393 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Department -> deptid, type: Department
2006-01-23 13:56:24,393 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Professor -> profid, type: IPerson
2006-01-23 13:56:24,408 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping collection: nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped -> StudentClass
2006-01-23 13:56:24,408 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: StudentsUntyped, type: ISet
2006-01-23 13:56:24,408 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - Found mapping documents in assembly: DataLayer.Mapings.IPerson.hbm.xml
2006-01-23 13:56:24,408 [2844] INFO NHibernate.Dialect.Dialect [(null)] <(null)> - Using dialect: NHibernate.Dialect.MsSql2000Dialect
2006-01-23 13:56:24,408 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping class: nhRegistration.BusinessObjects.IPerson -> people
2006-01-23 13:56:24,408 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Id -> personid, type: Int32
2006-01-23 13:56:24,408 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Name -> Name, type: String
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping subclass: nhRegistration.BusinessObjects.Professor -> people
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Code -> identifier, type: String
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping collection: nhRegistration.BusinessObjects.Professor.DepartmentsUntyped -> departmentprofessor
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: DepartmentsUntyped, type: ISet
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: ClassesUntyped, type: ISet
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping subclass: nhRegistration.BusinessObjects.Student -> people
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Ssn -> identifier, type: String
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping collection: nhRegistration.BusinessObjects.Student.ClassesUntyped -> StudentClass
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: ClassesUntyped, type: ISet
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - Found mapping documents in assembly: DataLayer.Mapings.Department.hbm.xml
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Dialect.Dialect [(null)] <(null)> - Using dialect: NHibernate.Dialect.MsSql2000Dialect
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping class: nhRegistration.BusinessObjects.Department -> department
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Id -> deptid, type: Int32
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: Name -> Name, type: String
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: ClassesUntyped, type: ISet
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - Mapping collection: nhRegistration.BusinessObjects.Department.ProfessorsUntyped -> departmentprofessor
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped property: ProfessorsUntyped, type: ISet
2006-01-23 13:56:24,424 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - processing one-to-many association mappings
2006-01-23 13:56:24,424 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Second pass for collection: nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped collection key: classid, element: personid, type: IPerson
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Second pass for collection: nhRegistration.BusinessObjects.Professor.DepartmentsUntyped
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped collection key: personid, element: deptid, type: Department
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Second pass for collection: nhRegistration.BusinessObjects.Professor.ClassesUntyped
2006-01-23 13:56:24,440 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - mapping collection: nhRegistration.BusinessObjects.Professor.ClassesUntyped -> universityclass
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped collection key: profid, one-to-many: UniversityClass
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Second pass for collection: nhRegistration.BusinessObjects.Student.ClassesUntyped
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped collection key: personid, element: classid, type: UniversityClass
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Second pass for collection: nhRegistration.BusinessObjects.Department.ClassesUntyped
2006-01-23 13:56:24,440 [2844] INFO NHibernate.Cfg.Binder [(null)] <(null)> - mapping collection: nhRegistration.BusinessObjects.Department.ClassesUntyped -> universityclass
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped collection key: deptid, one-to-many: UniversityClass
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Second pass for collection: nhRegistration.BusinessObjects.Department.ProfessorsUntyped
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Binder [(null)] <(null)> - Mapped collection key: deptid, element: personid, type: IPerson
2006-01-23 13:56:24,440 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - processing one-to-one association property references
2006-01-23 13:56:24,440 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - processing foreign key constraints
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Configuration [(null)] <(null)> - resolving reference to class: Department
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Configuration [(null)] <(null)> - resolving reference to class: IPerson
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Configuration [(null)] <(null)> - resolving reference to class: IPerson
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Configuration [(null)] <(null)> - resolving reference to class: UniversityClass
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Configuration [(null)] <(null)> - resolving reference to class: IPerson
2006-01-23 13:56:24,440 [2844] DEBUG NHibernate.Cfg.Configuration [(null)] <(null)> - resolving reference to class: Department
2006-01-23 13:56:24,455 [2844] INFO NHibernate.Dialect.Dialect [(null)] <(null)> - Using dialect: NHibernate.Dialect.MsSql2000Dialect
2006-01-23 13:56:24,455 [2844] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - use outer join fetching: True
2006-01-23 13:56:24,455 [2844] INFO NHibernate.Connection.ConnectionProviderFactory [(null)] <(null)> - Intitializing connection provider: NHibernate.Connection.DriverConnectionProvider
2006-01-23 13:56:24,455 [2844] INFO NHibernate.Connection.ConnectionProvider [(null)] <(null)> - Configuring ConnectionProvider
2006-01-23 13:56:24,471 [2844] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - Optimize cache for minimal puts: False
2006-01-23 13:56:24,471 [2844] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - Query language substitutions: {}
2006-01-23 13:56:24,471 [2844] INFO NHibernate.Cfg.SettingsFactory [(null)] <(null)> - cache provider: NHibernate.Cache.HashtableCacheProvider
2006-01-23 13:56:24,471 [2844] INFO NHibernate.Cfg.Configuration [(null)] <(null)> - instantiating and configuring caches
2006-01-23 13:56:24,471 [2844] INFO NHibernate.Impl.SessionFactoryImpl [(null)] <(null)> - building session factory
2006-01-23 13:56:24,471 [2844] DEBUG NHibernate.Impl.SessionFactoryImpl [(null)] <(null)> - instantiating session factory with properties: {hibernate.connection.driver_class=NHibernate.Driver.SqlClientDriver, hibernate.dialect=NHibernate.Dialect.MsSql2000Dialect, hibernate.connection.provider=NHibernate.Connection.DriverConnectionProvider, hibernate.connection.connection_string=Server=SRVNET;Database=nhRegistrationFlorin;User ID=sa;Password=as;Trusted_Connection=False}
2006-01-23 13:56:24,658 [2844] DEBUG NHibernate.Impl.SessionFactoryObjectFactory [(null)] <(null)> - initializing class SessionFactoryObjectFactory
2006-01-23 13:56:24,658 [2844] DEBUG NHibernate.Impl.SessionFactoryObjectFactory [(null)] <(null)> - registered: 1d3fd207fdb34835a3ca70b0beb7aa6e(unnamed)
2006-01-23 13:56:24,658 [2844] INFO NHibernate.Impl.SessionFactoryObjectFactory [(null)] <(null)> - no name configured
2006-01-23 13:56:24,658 [2844] DEBUG NHibernate.Impl.SessionFactoryImpl [(null)] <(null)> - Instantiated session factory
2006-01-23 13:56:24,674 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - opened session
2006-01-23 13:56:24,674 [2844] DEBUG NHibernate.Transaction.AdoTransaction [(null)] <(null)> - begin
2006-01-23 13:56:24,674 [2844] DEBUG NHibernate.Connection.DriverConnectionProvider [(null)] <(null)> - Obtaining IDbConnection from Driver
2006-01-23 13:56:24,721 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [Department#7]
2006-01-23 13:56:24,721 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [Department#7]
2006-01-23 13:56:24,721 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - object not resolved in any cache [nhRegistration.BusinessObjects.Department#7]
2006-01-23 13:56:24,721 [2844] DEBUG NHibernate.Persister.EntityPersister [(null)] <(null)> - Materializing entity: nhRegistration.BusinessObjects.Department#7
2006-01-23 13:56:24,737 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,752 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT department0_.deptid as deptid0_, department0_.Name as Name0_ FROM department department0_ WHERE department0_.deptid=:deptid
2006-01-23 13:56:24,752 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '7' to parameter: 0
2006-01-23 13:56:24,752 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT department0_.deptid as deptid0_, department0_.Name as Name0_ FROM department department0_ WHERE department0_.deptid=@p0
2006-01-23 13:56:24,752 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT department0_.deptid as deptid0_, department0_.Name as Name0_ FROM department department0_ WHERE department0_.deptid=@p0
2006-01-23 13:56:24,752 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,752 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,752 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 7
2006-01-23 13:56:24,768 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Initializing object from DataReader: 7
2006-01-23 13:56:24,768 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Hydrating entity: nhRegistration.BusinessObjects.Department#7
2006-01-23 13:56:24,768 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'Department 13' as column: Name0_
2006-01-23 13:56:24,768 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (1 rows)
2006-01-23 13:56:24,768 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,768 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,783 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,783 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 1
2006-01-23 13:56:24,783 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolving associations for: [nhRegistration.BusinessObjects.Department#7]
2006-01-23 13:56:24,783 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.Department.ClassesUntyped#7]
2006-01-23 13:56:24,783 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.Department.ProfessorsUntyped#7]
2006-01-23 13:56:24,783 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.Department.ClassesUntyped#7]
2006-01-23 13:56:24,783 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT classesunt0_.deptid as deptid__, classesunt0_.classId as classId__, classesunt0_.classId as classId1_, classesunt0_.profid as profid1_, classesunt0_.classname as classname1_, classesunt0_.StartDate as StartDate1_, classesunt0_.deptid as deptid1_, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM universityclass classesunt0_ left outer join people iperson1_ on classesunt0_.profid=iperson1_.personid WHERE classesunt0_.deptid=:deptid
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '7' to parameter: 0
2006-01-23 13:56:24,799 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT classesunt0_.deptid as deptid__, classesunt0_.classId as classId__, classesunt0_.classId as classId1_, classesunt0_.profid as profid1_, classesunt0_.classname as classname1_, classesunt0_.StartDate as StartDate1_, classesunt0_.deptid as deptid1_, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM universityclass classesunt0_ left outer join people iperson1_ on classesunt0_.profid=iperson1_.personid WHERE classesunt0_.deptid=@p0
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT classesunt0_.deptid as deptid__, classesunt0_.classId as classId__, classesunt0_.classId as classId1_, classesunt0_.profid as profid1_, classesunt0_.classname as classname1_, classesunt0_.StartDate as StartDate1_, classesunt0_.deptid as deptid1_, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM universityclass classesunt0_ left outer join people iperson1_ on classesunt0_.profid=iperson1_.personid WHERE classesunt0_.deptid=@p0
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result set contains (possibly empty) collection: [nhRegistration.BusinessObjects.Department.ClassesUntyped#7]
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - uninitialized collection: initializing
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: personid0_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '11' as column: classId1_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 4, 11
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'professor' as column: persontype0_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Initializing object from DataReader: 4
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Hydrating entity: nhRegistration.BusinessObjects.Professor#4
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'pCharles' as column: identifier0_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'Charles' as column: Name0_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Initializing object from DataReader: 11
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Hydrating entity: nhRegistration.BusinessObjects.UniversityClass#11
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: profid1_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'Class 1' as column: classname1_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.DateTimeType [(null)] <(null)> - returning '1/1/2006' as column: StartDate1_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid1_
2006-01-23 13:56:24,799 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid__
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Department.ClassesUntyped#7]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '11' as column: classId__
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [UniversityClass#11]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [UniversityClass#11]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.UniversityClass#11]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: personid0_
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '12' as column: classId1_
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 4, 12
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Initializing object from DataReader: 12
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Hydrating entity: nhRegistration.BusinessObjects.UniversityClass#12
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: profid1_
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'Class 2' as column: classname1_
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.DateTimeType [(null)] <(null)> - returning '1/1/2006' as column: StartDate1_
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid1_
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid__
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Department.ClassesUntyped#7]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '12' as column: classId__
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [UniversityClass#12]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [UniversityClass#12]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.UniversityClass#12]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (2 rows)
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 3
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolving associations for: [nhRegistration.BusinessObjects.Professor#4]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#4]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.Professor.ClassesUntyped#4]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#4]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT department0_.personid as personid__, department0_.deptid as deptid__, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM departmentprofessor department0_ inner join department department1_ on department0_.deptid=department1_.deptid WHERE department0_.personid=:personid
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '4' to parameter: 0
2006-01-23 13:56:24,815 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT department0_.personid as personid__, department0_.deptid as deptid__, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM departmentprofessor department0_ inner join department department1_ on department0_.deptid=department1_.deptid WHERE department0_.personid=@p0
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT department0_.personid as personid__, department0_.deptid as deptid__, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM departmentprofessor department0_ inner join department department1_ on department0_.deptid=department1_.deptid WHERE department0_.personid=@p0
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result set contains (possibly empty) collection: [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#4]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - uninitialized collection: initializing
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid0_
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 7
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: personid__
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#4]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid__
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [Department#7]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [Department#7]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.Department#7]
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (1 rows)
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 0
2006-01-23 13:56:24,815 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections were found in result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection fully initialized: [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.Professor.ClassesUntyped#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT classesunt0_.profid as profid__, classesunt0_.classId as classId__, classesunt0_.classId as classId1_, classesunt0_.profid as profid1_, classesunt0_.classname as classname1_, classesunt0_.StartDate as StartDate1_, classesunt0_.deptid as deptid1_, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM universityclass classesunt0_ left outer join department department1_ on classesunt0_.deptid=department1_.deptid WHERE classesunt0_.profid=:profid
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '4' to parameter: 0
2006-01-23 13:56:24,830 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT classesunt0_.profid as profid__, classesunt0_.classId as classId__, classesunt0_.classId as classId1_, classesunt0_.profid as profid1_, classesunt0_.classname as classname1_, classesunt0_.StartDate as StartDate1_, classesunt0_.deptid as deptid1_, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM universityclass classesunt0_ left outer join department department1_ on classesunt0_.deptid=department1_.deptid WHERE classesunt0_.profid=@p0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT classesunt0_.profid as profid__, classesunt0_.classId as classId__, classesunt0_.classId as classId1_, classesunt0_.profid as profid1_, classesunt0_.classname as classname1_, classesunt0_.StartDate as StartDate1_, classesunt0_.deptid as deptid1_, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM universityclass classesunt0_ left outer join department department1_ on classesunt0_.deptid=department1_.deptid WHERE classesunt0_.profid=@p0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result set contains (possibly empty) collection: [nhRegistration.BusinessObjects.Professor.ClassesUntyped#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - uninitialized collection: initializing
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid0_
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '11' as column: classId1_
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 7, 11
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: profid__
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Professor.ClassesUntyped#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '11' as column: classId__
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [UniversityClass#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [UniversityClass#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.UniversityClass#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid0_
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '12' as column: classId1_
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 7, 12
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: profid__
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Professor.ClassesUntyped#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '12' as column: classId__
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [UniversityClass#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [UniversityClass#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.UniversityClass#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (2 rows)
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections were found in result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection fully initialized: [nhRegistration.BusinessObjects.Professor.ClassesUntyped#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - done materializing entity [nhRegistration.BusinessObjects.Professor#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolving associations for: [nhRegistration.BusinessObjects.UniversityClass#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [IPerson#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [IPerson#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.IPerson#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [Department#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [Department#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.Department#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT studentsun0_.classid as classid__, studentsun0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM StudentClass studentsun0_ inner join people iperson1_ on studentsun0_.personid=iperson1_.personid WHERE studentsun0_.classid=:classid
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '11' to parameter: 0
2006-01-23 13:56:24,830 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT studentsun0_.classid as classid__, studentsun0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM StudentClass studentsun0_ inner join people iperson1_ on studentsun0_.personid=iperson1_.personid WHERE studentsun0_.classid=@p0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT studentsun0_.classid as classid__, studentsun0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM StudentClass studentsun0_ inner join people iperson1_ on studentsun0_.personid=iperson1_.personid WHERE studentsun0_.classid=@p0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result set contains (possibly empty) collection: [nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - uninitialized collection: initializing
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (0 rows)
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections were found in result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection fully initialized: [nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - done materializing entity [nhRegistration.BusinessObjects.UniversityClass#11]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolving associations for: [nhRegistration.BusinessObjects.UniversityClass#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [IPerson#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [IPerson#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.IPerson#4]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [Department#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [Department#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.Department#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT studentsun0_.classid as classid__, studentsun0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM StudentClass studentsun0_ inner join people iperson1_ on studentsun0_.personid=iperson1_.personid WHERE studentsun0_.classid=:classid
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '12' to parameter: 0
2006-01-23 13:56:24,830 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT studentsun0_.classid as classid__, studentsun0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM StudentClass studentsun0_ inner join people iperson1_ on studentsun0_.personid=iperson1_.personid WHERE studentsun0_.classid=@p0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT studentsun0_.classid as classid__, studentsun0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM StudentClass studentsun0_ inner join people iperson1_ on studentsun0_.personid=iperson1_.personid WHERE studentsun0_.classid=@p0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result set contains (possibly empty) collection: [nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - uninitialized collection: initializing
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (0 rows)
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections were found in result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection fully initialized: [nhRegistration.BusinessObjects.UniversityClass.StudentsUntyped#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - done materializing entity [nhRegistration.BusinessObjects.UniversityClass#12]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections were found in result set
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection fully initialized: [nhRegistration.BusinessObjects.Department.ClassesUntyped#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection initialized
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.Department.ProfessorsUntyped#7]
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT professors0_.deptid as deptid__, professors0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM departmentprofessor professors0_ inner join people iperson1_ on professors0_.personid=iperson1_.personid WHERE professors0_.deptid=:deptid
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '7' to parameter: 0
2006-01-23 13:56:24,830 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT professors0_.deptid as deptid__, professors0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM departmentprofessor professors0_ inner join people iperson1_ on professors0_.personid=iperson1_.personid WHERE professors0_.deptid=@p0
2006-01-23 13:56:24,830 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT professors0_.deptid as deptid__, professors0_.personid as personid__, iperson1_.personid as personid0_, iperson1_.persontype as persontype0_, iperson1_.Name as Name0_, iperson1_.identifier as identifier0_ FROM departmentprofessor professors0_ inner join people iperson1_ on professors0_.personid=iperson1_.personid WHERE professors0_.deptid=@p0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result set contains (possibly empty) collection: [nhRegistration.BusinessObjects.Department.ProfessorsUntyped#7]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - uninitialized collection: initializing
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '1' as column: personid0_
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'professor' as column: persontype0_
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Initializing object from DataReader: 1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - Hydrating entity: nhRegistration.BusinessObjects.Professor#1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'pRichard' as column: identifier0_
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.StringType [(null)] <(null)> - returning 'Richard' as column: Name0_
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid__
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Department.ProfessorsUntyped#7]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '1' as column: personid__
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [IPerson#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [IPerson#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.IPerson#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: personid0_
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 4
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid__
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Department.ProfessorsUntyped#7]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '4' as column: personid__
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [IPerson#4]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [IPerson#4]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.IPerson#4]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (2 rows)
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolving associations for: [nhRegistration.BusinessObjects.Professor#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - creating collection wrapper:[nhRegistration.BusinessObjects.Professor.ClassesUntyped#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT department0_.personid as personid__, department0_.deptid as deptid__, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM departmentprofessor department0_ inner join department department1_ on department0_.deptid=department1_.deptid WHERE department0_.personid=:personid
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - binding '1' to parameter: 0
2006-01-23 13:56:24,846 [2844] INFO NHibernate.Loader.Loader [(null)] <(null)> - SELECT department0_.personid as personid__, department0_.deptid as deptid__, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM departmentprofessor department0_ inner join department department1_ on department0_.deptid=department1_.deptid WHERE department0_.personid=@p0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.SQL [(null)] <(null)> - SELECT department0_.personid as personid__, department0_.deptid as deptid__, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM departmentprofessor department0_ inner join department department1_ on department0_.deptid=department1_.deptid WHERE department0_.personid=@p0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened Reader, open Readers :1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result set contains (possibly empty) collection: [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - uninitialized collection: initializing
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - processing result set
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid0_
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - result row: 7
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '1' as column: personid__
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - found row of collection: [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - reading row
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Type.Int32Type [(null)] <(null)> - returning '7' as column: deptid__
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - loading [Department#7]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - attempting to resolve [Department#7]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - resolved object in session cache [nhRegistration.BusinessObjects.Department#7]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - done processing result set (1 rows)
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Driver.NHybridDataReader [(null)] <(null)> - running NHybridDataReader.Dispose()
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed Reader, open Readers :0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Closed IDbCommand, open IDbCommands :0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Loader.Loader [(null)] <(null)> - total objects hydrated: 0
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections were found in result set
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection fully initialized: [nhRegistration.BusinessObjects.Professor.DepartmentsUntyped#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - 1 collections initialized
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection initialized
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - initializing collection [nhRegistration.BusinessObjects.Professor.ClassesUntyped#1]
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - checking second-level cache
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.SessionImpl [(null)] <(null)> - collection not cached
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Opened new IDbCommand, open IDbCommands :1
2006-01-23 13:56:24,846 [2844] DEBUG NHibernate.Impl.BatcherImpl [(null)] <(null)> - Building an IDbCommand object for the SqlString: SELECT classesunt0_.profid as profid__, classesunt0_.classId as classId__, classesunt0_.classId as classId1_, classesunt0_.profid as profid1_, classesunt0_.classname as classname1_, classesunt0_.StartDate as StartDate1_, classesunt0_.deptid as deptid1_, department1_.deptid as deptid0_, department1_.Name as Name0_ FROM universityclass classesunt0_ left outer join department department1_ on classesunt0_.deptid=department1_.deptid WHERE classesunt0_.profid=:profid
2006-01-23 13:56:24,846 [2844] DEBUG NHibe