hello,

i'm looking the log file and it's so weird:

I try to load all the data of only one table with only properties tag, and in the log file i can see a lots of select not related to this table.
In fact it's like it's doing some select for each mapping file i have.

Does nhibernate query database for all mapping file at initialization ? Is it normal ?

Thanks

nHibernate will only query your database to retrieve entities you request and then following that eager/lazy loading based on your mapping and usage of the retrieved entities.

Can you give us an example?

yes, here are the log at the start up of the applicaton.
I only get all users of user table, which contains only properties:




#2008-03-09 18:47:35,553 [10] INFO NHibernate.Cfg.Environment
NHibernate 1.2.0.3001 (1.2.0.3001)
#2008-03-09 18:47:35,587 [10] INFO NHibernate.Cfg.Environment
nhibernate section not found in application configuration file
#2008-03-09 18:47:35,588 [10] INFO NHibernate.Cfg.Environment
Bytecode provider name : lcg
#2008-03-09 18:47:35,592 [10] INFO NHibernate.Cfg.Environment
Using reflection optimizer
#2008-03-09 18:47:35,612 [10] DEBUG NHibernate.Cfg.Configuration
connection.provider=NHibernate.Connection.DriverConnectionProvider
#2008-03-09 18:47:35,612 [10] DEBUG NHibernate.Cfg.Configuration
dialect=NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:35,612 [10] DEBUG NHibernate.Cfg.Configuration
connection.driver_class=NHibernate.Driver.SqlClientDriver
#2008-03-09 18:47:35,612 [10] DEBUG NHibernate.Cfg.Configuration
connection.connection_string=Server=PC-DE-RANDO\SQLEXPRESS;initial catalog=staffplan;Integrated Security=True

#2008-03-09 18:47:35,612 [10] DEBUG NHibernate.Cfg.Configuration
properties: System.Collections.Hashtable
#2008-03-09 18:47:35,613 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\User.hbm.xml
#2008-03-09 18:47:35,717 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:35,938 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.User -> usertable
#2008-03-09 18:47:35,978 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> idUser, type: Int32
#2008-03-09 18:47:35,998 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> nom, type: String
#2008-03-09 18:47:35,998 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: FirstName -> prenom, type: String
#2008-03-09 18:47:35,998 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Login -> login, type: String
#2008-03-09 18:47:35,998 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Password -> pass, type: String
#2008-03-09 18:47:35,999 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\CategoryContract.hbm.xml
#2008-03-09 18:47:36,000 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,000 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.CategoryContract -> CategoryContract
#2008-03-09 18:47:36,000 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,000 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> name, type: String
#2008-03-09 18:47:36,000 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\TypeContract.hbm.xml
#2008-03-09 18:47:36,001 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,002 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.TypeContract -> TypeContract
#2008-03-09 18:47:36,002 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,002 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> name, type: String
#2008-03-09 18:47:36,002 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdCategory -> IdCategory, type: Int32
#2008-03-09 18:47:36,018 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Category -> IdCategory, type: CategoryContract
#2008-03-09 18:47:36,018 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\CategoryProfession.hbm.xml
#2008-03-09 18:47:36,019 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,020 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.CategoryProfession -> CategoryProfession
#2008-03-09 18:47:36,020 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,020 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> name, type: String
#2008-03-09 18:47:36,020 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Profession.hbm.xml
#2008-03-09 18:47:36,021 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,021 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Profession -> profession
#2008-03-09 18:47:36,021 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> idProfession, type: Int32
#2008-03-09 18:47:36,021 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> nameProfession, type: String
#2008-03-09 18:47:36,021 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdCategory -> IdCategory, type: Int32
#2008-03-09 18:47:36,022 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: CategoryProfession -> IdCategory, type: CategoryProfession
#2008-03-09 18:47:36,022 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\CategoryTBD.hbm.xml
#2008-03-09 18:47:36,023 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,023 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.CategoryTBD -> CategoryTBD
#2008-03-09 18:47:36,023 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,023 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> name, type: String
#2008-03-09 18:47:36,023 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Resource.hbm.xml
#2008-03-09 18:47:36,024 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,025 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Resource -> CioMembre
#2008-03-09 18:47:36,025 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> idMembre, type: Int32
#2008-03-09 18:47:36,025 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> nom, type: String
#2008-03-09 18:47:36,025 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: FirstName -> prenom, type: String
#2008-03-09 18:47:36,025 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Alias -> Alias, type: String
#2008-03-09 18:47:36,025 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: TbdStatusInt -> tbdStatus, type: Int32
#2008-03-09 18:47:36,025 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: BeginExpFunctional -> beginExpFunctional, type: DateTime
#2008-03-09 18:47:36,025 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: BeginExpProfession -> BeginExpProfession, type: DateTime
#2008-03-09 18:47:36,025 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: BeginExpReal -> BeginExpReal, type: DateTime
#2008-03-09 18:47:36,025 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: BeginExpSG -> beginExpSG, type: DateTime
#2008-03-09 18:47:36,026 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: BeginExpSSII -> beginExpSSII, type: DateTime
#2008-03-09 18:47:36,028 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ValidationInt -> validation, type: Int32
#2008-03-09 18:47:36,028 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdCategoryTBD -> idCategoryTBD, type: Int32
#2008-03-09 18:47:36,028 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: CategoryTBD -> idCategoryTBD, type: CategoryTBD
#2008-03-09 18:47:36,028 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Month.hbm.xml
#2008-03-09 18:47:36,029 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,030 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Month -> month
#2008-03-09 18:47:36,030 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> idMonth, type: Int32
#2008-03-09 18:47:36,030 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: TheMonth -> month, type: Int32
#2008-03-09 18:47:36,030 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Year.hbm.xml
#2008-03-09 18:47:36,031 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,032 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Year -> annee
#2008-03-09 18:47:36,032 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> idannee, type: Int32
#2008-03-09 18:47:36,032 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: TheYear -> annee, type: Int32
#2008-03-09 18:47:36,032 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\LeavingReason.hbm.xml
#2008-03-09 18:47:36,032 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,033 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.LeavingReason -> LeavingReason
#2008-03-09 18:47:36,033 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,033 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> name, type: String
#2008-03-09 18:47:36,033 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdParent -> IdParent, type: Int32
#2008-03-09 18:47:36,033 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ParentReason -> IdParent, type: LeavingReason
#2008-03-09 18:47:36,033 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\EmployeeReason.hbm.xml
#2008-03-09 18:47:36,035 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,035 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.EmployeeReason -> EmployeeReason
#2008-03-09 18:47:36,035 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,035 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdCategory -> IdCategory, type: Int32
#2008-03-09 18:47:36,035 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdReason -> IdReason, type: Int32
#2008-03-09 18:47:36,036 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Reason -> IdReason, type: LeavingReason
#2008-03-09 18:47:36,036 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Category -> IdCategory, type: CategoryContract
#2008-03-09 18:47:36,036 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Contract.hbm.xml
#2008-03-09 18:47:36,037 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,038 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Contract -> Contract
#2008-03-09 18:47:36,039 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,039 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdEmployeeReason -> IdEmployeeReason, type: Int32
#2008-03-09 18:47:36,039 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdEmployeeContract -> IdEmployeeContract, type: Int32
#2008-03-09 18:47:36,039 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdRH -> IdRH, type: Int32
#2008-03-09 18:47:36,039 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Matricule -> Matricule, type: String
#2008-03-09 18:47:36,039 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: NumAO -> NumAO, type: String
#2008-03-09 18:47:36,039 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ValidationInt -> validation, type: Int32
#2008-03-09 18:47:36,039 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: DateEnter -> DateEnter, type: DateTime
#2008-03-09 18:47:36,039 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: DateLeave -> DateLeave, type: DateTime
#2008-03-09 18:47:36,039 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: RH -> IdRH, type: Resource
#2008-03-09 18:47:36,040 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: EmployeeContract -> IdEmployeeContract, type: TypeContract
#2008-03-09 18:47:36,040 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: EmployeeReason -> IdEmployeeReason, type: EmployeeReason
#2008-03-09 18:47:36,040 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\CoeffGlobal.hbm.xml
#2008-03-09 18:47:36,041 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,042 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.CoeffGlobal -> CoeffGlobal
#2008-03-09 18:47:36,042 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,042 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: TheCoeffGlobal -> TheCoeffGlobal, type: Decimal
#2008-03-09 18:47:36,042 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Version -> version, type: Int32
#2008-03-09 18:47:36,042 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdYear -> idYear, type: Int32
#2008-03-09 18:47:36,042 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdMonth -> idMonth, type: Int32
#2008-03-09 18:47:36,042 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdContract -> idContract, type: Int32
#2008-03-09 18:47:36,042 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdProfession -> idprofession, type: Int32
#2008-03-09 18:47:36,045 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Profession -> idprofession, type: Profession
#2008-03-09 18:47:36,045 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Year -> idYear, type: Year
#2008-03-09 18:47:36,046 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Month -> idMonth, type: Month
#2008-03-09 18:47:36,047 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Contract -> idContract, type: Contract
#2008-03-09 18:47:36,047 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Zone.hbm.xml
#2008-03-09 18:47:36,047 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,048 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Zone -> zone
#2008-03-09 18:47:36,048 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,048 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> name, type: String
#2008-03-09 18:47:36,048 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Location.hbm.xml
#2008-03-09 18:47:36,049 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,049 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Location -> Location
#2008-03-09 18:47:36,049 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,049 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> name, type: String
#2008-03-09 18:47:36,051 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\ZoneLocation.hbm.xml
#2008-03-09 18:47:36,052 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,052 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.ZoneLocation -> ZoneLocation
#2008-03-09 18:47:36,052 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,052 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdZone -> idzone, type: Int32
#2008-03-09 18:47:36,052 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdLocation -> idlocation, type: Int32
#2008-03-09 18:47:36,053 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Zone -> idzone, type: Zone
#2008-03-09 18:47:36,053 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Location -> idlocation, type: Location
#2008-03-09 18:47:36,053 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\RC.hbm.xml
#2008-03-09 18:47:36,054 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,055 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.RC -> RC
#2008-03-09 18:47:36,055 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,055 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Code -> code, type: String
#2008-03-09 18:47:36,055 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> name, type: String
#2008-03-09 18:47:36,055 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdZoneLocation -> idzone, type: Int32
#2008-03-09 18:47:36,055 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: CoeffInternal -> CoeffInternal, type: Double
#2008-03-09 18:47:36,055 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: CoeffExpatriates -> CoeffExpatriates, type: Double
#2008-03-09 18:47:36,055 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: CoeffContractors -> CoeffContractors, type: Double
#2008-03-09 18:47:36,055 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ZoneLocation -> idzone, type: ZoneLocation
#2008-03-09 18:47:36,055 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\TeamLeader.hbm.xml
#2008-03-09 18:47:36,057 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,057 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.TeamLeader -> teamleader
#2008-03-09 18:47:36,059 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,059 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: TypeLeader -> typeleader, type: Int32
#2008-03-09 18:47:36,059 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdRc -> idrc, type: Int32
#2008-03-09 18:47:36,059 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdRh -> idrh, type: Int32
#2008-03-09 18:47:36,059 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdLeader -> idleader, type: Int32
#2008-03-09 18:47:36,059 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdApplication -> idappli, type: Int32
#2008-03-09 18:47:36,059 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: RC -> idrc, type: RC
#2008-03-09 18:47:36,060 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: RH -> idrh, type: Resource
#2008-03-09 18:47:36,060 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Appli -> idappli, type: Application
#2008-03-09 18:47:36,061 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: GetTeamLeader -> idleader, type: TeamLeader
#2008-03-09 18:47:36,061 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Group.hbm.xml
#2008-03-09 18:47:36,061 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,062 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Group -> groups
#2008-03-09 18:47:36,062 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,062 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> name, type: String
#2008-03-09 18:47:36,066 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: GroupType -> GroupType, type: enumstring - GroupType
#2008-03-09 18:47:36,066 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\GroupeApplication.hbm.xml
#2008-03-09 18:47:36,067 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,068 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.GroupeApplication -> GroupeApplication
#2008-03-09 18:47:36,068 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,068 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> groupe, type: String
#2008-03-09 18:47:36,068 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Team.hbm.xml
#2008-03-09 18:47:36,068 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,069 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Team -> Equipe
#2008-03-09 18:47:36,069 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> idEquipe, type: Int32
#2008-03-09 18:47:36,069 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> nom_equipe, type: String
#2008-03-09 18:47:36,069 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Application.hbm.xml
#2008-03-09 18:47:36,070 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,070 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Application -> application
#2008-03-09 18:47:36,071 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> idApplication, type: Int32
#2008-03-09 18:47:36,071 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdBudget -> Budget_idBudget, type: Int32
#2008-03-09 18:47:36,071 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> nom_application, type: String
#2008-03-09 18:47:36,071 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdTeam -> Equipe_idEquipe, type: Int32
#2008-03-09 18:47:36,071 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdGroupeApplication -> groupe, type: Int32
#2008-03-09 18:47:36,071 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Team -> Equipe_idEquipe, type: Team
#2008-03-09 18:47:36,071 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: GroupeApplication -> groupe, type: GroupeApplication
#2008-03-09 18:47:36,071 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Priority.hbm.xml
#2008-03-09 18:47:36,072 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,074 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Priority -> Priority
#2008-03-09 18:47:36,074 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,074 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> nom, type: String
#2008-03-09 18:47:36,074 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\TbsType.hbm.xml
#2008-03-09 18:47:36,075 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,076 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.TbsType -> TbsType
#2008-03-09 18:47:36,079 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,079 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> nom, type: String
#2008-03-09 18:47:36,079 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Service.hbm.xml
#2008-03-09 18:47:36,080 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,080 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Service -> Service
#2008-03-09 18:47:36,080 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,080 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> nom, type: String
#2008-03-09 18:47:36,080 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ServiceType -> type, type: Int32
#2008-03-09 18:47:36,080 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdParent -> idparent, type: Int32
#2008-03-09 18:47:36,081 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ParentService -> idparent, type: Service
#2008-03-09 18:47:36,081 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\SubTbs.hbm.xml
#2008-03-09 18:47:36,082 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,082 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.SubTbs -> SubTbs
#2008-03-09 18:47:36,082 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,083 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdTbs -> idparent, type: Int32
#2008-03-09 18:47:36,083 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Code -> code, type: String
#2008-03-09 18:47:36,083 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdPriority -> idpriority, type: Int32
#2008-03-09 18:47:36,083 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: LibSubTbs -> mandays, type: String
#2008-03-09 18:47:36,083 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdType -> idtype, type: Int32
#2008-03-09 18:47:36,083 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: TbsType -> idtype, type: TbsType
#2008-03-09 18:47:36,083 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Priority -> idpriority, type: Priority
#2008-03-09 18:47:36,084 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Tbs -> idparent, type: Tbs
#2008-03-09 18:47:36,084 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Tbs.hbm.xml
#2008-03-09 18:47:36,085 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,085 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Tbs -> Tbs
#2008-03-09 18:47:36,085 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,085 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdST -> idsubsubservice, type: Int32
#2008-03-09 18:47:36,085 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Code -> code, type: String
#2008-03-09 18:47:36,085 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: LibTbs -> libtbs, type: String
#2008-03-09 18:47:36,086 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ST -> idsubsubservice, type: Service
#2008-03-09 18:47:36,086 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Right.hbm.xml
#2008-03-09 18:47:36,087 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,087 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Right -> myright
#2008-03-09 18:47:36,087 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,087 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Name -> name, type: String
#2008-03-09 18:47:36,089 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: RightType -> RightType, type: enumstring - GroupType
#2008-03-09 18:47:36,089 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\GroupRight.hbm.xml
#2008-03-09 18:47:36,090 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,091 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.GroupRight -> groupright
#2008-03-09 18:47:36,091 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,091 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdGroup -> idgroup, type: Int32
#2008-03-09 18:47:36,091 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdRight -> idright, type: Int32
#2008-03-09 18:47:36,091 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: read -> myread, type: Int32
#2008-03-09 18:47:36,091 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: write -> mywrite, type: Int32
#2008-03-09 18:47:36,092 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Group -> idgroup, type: Group
#2008-03-09 18:47:36,092 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Right -> idright, type: Right
#2008-03-09 18:47:36,092 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\UserGroup.hbm.xml
#2008-03-09 18:47:36,093 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,094 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.UserGroup -> UserGroup
#2008-03-09 18:47:36,103 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdUser -> iduser, type: Int32
#2008-03-09 18:47:36,103 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdGroup -> idgroup, type: Int32
#2008-03-09 18:47:36,147 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> iduser, idgroup, type: KeyUserGroup
#2008-03-09 18:47:36,148 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdUser -> iduser, type: Int32
#2008-03-09 18:47:36,148 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdGroup -> idgroup, type: Int32
#2008-03-09 18:47:36,148 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Group -> idgroup, type: Group
#2008-03-09 18:47:36,149 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: User -> iduser, type: User
#2008-03-09 18:47:36,149 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Work.hbm.xml
#2008-03-09 18:47:36,150 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,150 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Work -> work
#2008-03-09 18:47:36,150 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> idWork, type: Int32
#2008-03-09 18:47:36,151 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: DateEnter -> dateEnter, type: DateTime
#2008-03-09 18:47:36,151 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: DateLeave -> dateLeave, type: DateTime
#2008-03-09 18:47:36,151 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Discription -> discription, type: String
#2008-03-09 18:47:36,151 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ValidationInt -> validation, type: Int32
#2008-03-09 18:47:36,151 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdTeamLeader -> idTeamLeader, type: Int32
#2008-03-09 18:47:36,151 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: TeamLeader -> idTeamLeader, type: TeamLeader
#2008-03-09 18:47:36,151 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Coeff.hbm.xml
#2008-03-09 18:47:36,154 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,154 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Coeff -> coeff
#2008-03-09 18:47:36,155 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> idCoeff, type: Int32
#2008-03-09 18:47:36,155 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: TheCoeff -> coeff, type: Decimal
#2008-03-09 18:47:36,155 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Version -> version, type: Int32
#2008-03-09 18:47:36,155 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdYear -> idYear, type: Int32
#2008-03-09 18:47:36,155 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdMonth -> idMonth, type: Int32
#2008-03-09 18:47:36,155 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdWork -> idWork, type: Int32
#2008-03-09 18:47:36,155 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Year -> idYear, type: Year
#2008-03-09 18:47:36,155 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Month -> idMonth, type: Month
#2008-03-09 18:47:36,156 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Work -> idWork, type: Work
#2008-03-09 18:47:36,156 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\Matrice.hbm.xml
#2008-03-09 18:47:36,158 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,159 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.Matrice -> Matrice
#2008-03-09 18:47:36,159 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,159 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: LockNumber -> locknumber, type: Int32
#2008-03-09 18:47:36,160 [10] DEBUG NHibernate.Mapping.RootClass
Hello world
#2008-03-09 18:47:36,160 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: DateModification -> modification, type: DateTime
#2008-03-09 18:47:36,160 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdYear -> idannee, type: Int32
#2008-03-09 18:47:36,160 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Version -> version, type: Int32
#2008-03-09 18:47:36,160 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Budget -> budget, type: String
#2008-03-09 18:47:36,160 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdssLeader -> idssleader, type: Int32
#2008-03-09 18:47:36,160 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdApplication -> idapplication, type: Int32
#2008-03-09 18:47:36,160 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdSubTbs -> idsubtbs, type: Int32
#2008-03-09 18:47:36,160 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdRc -> idrc, type: Int32
#2008-03-09 18:47:36,160 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Lot -> lot, type: Int32
#2008-03-09 18:47:36,160 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Comment -> commentaire, type: String
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: C -> c, type: Int32
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Closed -> closed, type: Int32
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Delta -> delta, type: Int32
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Statut -> statut, type: Int32
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: GroupeOperation -> GroupeOperation, type: String
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: DeltaColonne -> deltacolonne, type: String
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: CommentaireArbitrage -> CommentaireArbitrage, type: String
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: LabelVersion -> LabelVersion, type: String
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Average -> Moyenne, type: Double
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: InternalStaff1 -> internalstaff1, type: Double
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Expatriates1 -> expatriates1, type: Double
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Contractors1 -> contractors1, type: Double
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Trainees1 -> trainees1, type: Double
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Vie1 -> vie1, type: Double
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Total1 -> total1, type: Double
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: InternalStaff2 -> internalstaff2, type: Double
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Expatriates2 -> expatriates2, type: Double
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Contractors2 -> contractors2, type: Double
#2008-03-09 18:47:36,161 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Trainees2 -> trainees2, type: Double
#2008-03-09 18:47:36,162 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Vie2 -> vie2, type: Double
#2008-03-09 18:47:36,162 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Total2 -> total2, type: Double
#2008-03-09 18:47:36,162 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: InternalStaff3 -> internalstaff3, type: Double
#2008-03-09 18:47:36,162 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Expatriates3 -> expatriates3, type: Double
#2008-03-09 18:47:36,162 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Contractors3 -> contractors3, type: Double
#2008-03-09 18:47:36,162 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Trainees3 -> trainees3, type: Double
#2008-03-09 18:47:36,162 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Vie3 -> vie3, type: Double
#2008-03-09 18:47:36,162 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Total3 -> total3, type: Double
#2008-03-09 18:47:36,162 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: InternalStaff4 -> internalstaff4, type: Double
#2008-03-09 18:47:36,162 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Expatriates4 -> expatriates4, type: Double
#2008-03-09 18:47:36,162 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Contractors4 -> contractors4, type: Double
#2008-03-09 18:47:36,162 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Trainees4 -> trainees4, type: Double
#2008-03-09 18:47:36,162 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Vie4 -> vie4, type: Double
#2008-03-09 18:47:36,162 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Total4 -> total4, type: Double
#2008-03-09 18:47:36,163 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Year -> idannee, type: Year
#2008-03-09 18:47:36,163 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ssLeader -> idssleader, type: TeamLeader
#2008-03-09 18:47:36,163 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Application -> idapplication, type: Application
#2008-03-09 18:47:36,163 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: SubTbs -> idsubtbs, type: SubTbs
#2008-03-09 18:47:36,164 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Rc -> idrc, type: RC
#2008-03-09 18:47:36,164 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\StaffPlan.hbm.xml
#2008-03-09 18:47:36,165 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,167 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.StaffPlan -> StaffPlan
#2008-03-09 18:47:36,167 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> idStaffPlan, type: Int32
#2008-03-09 18:47:36,167 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Version -> version, type: Int32
#2008-03-09 18:47:36,168 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: VersionCoeff -> versionCoeff, type: Int32
#2008-03-09 18:47:36,168 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdRC -> IdRC, type: Int32
#2008-03-09 18:47:36,168 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: VersionGlobalCoeff -> VersionGlobalCoeff, type: Int32
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Code -> code, type: enumstring - CodeChange
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdParent -> idParent, type: Int32
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: DirtyInt -> dirty, type: Int32
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ValidationInt -> validation, type: Int32
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdUser -> idUser, type: Int32
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdContract -> idContract, type: Int32
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdWork -> idWork, type: Int32
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: FamillyName -> famillyName, type: String
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: FirstName -> firstName, type: String
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: RC -> RC, type: String
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Matricule -> matricule, type: String
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: TbdStatusInt -> tbdStatus, type: Int32
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: AO -> AO, type: String
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: LeavingReason -> leavingReason, type: String
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ContractBeginDate -> contractBeginDate, type: DateTime
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ContractEndDate -> contractEndDate, type: DateTime
#2008-03-09 18:47:36,169 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ContractType -> contractType, type: String
#2008-03-09 18:47:36,170 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: DescriptionWork -> discriptionWork, type: String
#2008-03-09 18:47:36,170 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: WorkBeginDate -> workBeginDate, type: DateTime
#2008-03-09 18:47:36,170 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: WorkEndDate -> workEndDate, type: DateTime
#2008-03-09 18:47:36,170 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Board -> Board, type: String
#2008-03-09 18:47:36,170 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Board1 -> Board1, type: String
#2008-03-09 18:47:36,170 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Board2 -> Board2, type: String
#2008-03-09 18:47:36,170 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: RcObject -> IdRC, type: RC
#2008-03-09 18:47:36,170 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: TheWork -> idWork, type: Work
#2008-03-09 18:47:36,171 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: User -> idUser, type: User
#2008-03-09 18:47:36,171 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Contract -> idContract, type: Contract
#2008-03-09 18:47:36,171 [10] INFO NHibernate.Cfg.Configuration
Mapping file: C:\Developpement\Code Winform\_279846_StaffPlan\Rad.StaffPlan.Core\Mapping\RestrictedArea.hbm.xml
#2008-03-09 18:47:36,172 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,172 [10] INFO NHibernate.Cfg.HbmBinder
Mapping class: Rad.StaffPlan.Core.Domain.RestrictedArea -> RestrictedArea
#2008-03-09 18:47:36,172 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: ID -> id, type: Int32
#2008-03-09 18:47:36,172 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdGroupRight -> idgroupright, type: Int32
#2008-03-09 18:47:36,172 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: IdResource -> alias, type: Int32
#2008-03-09 18:47:36,173 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: RightType -> typeright, type: enumstring - RightType
#2008-03-09 18:47:36,173 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: Resource -> alias, type: Resource
#2008-03-09 18:47:36,175 [10] DEBUG NHibernate.Cfg.HbmBinder
Mapped property: GroupRight -> idgroupright, type: GroupRight
#2008-03-09 18:47:36,179 [10] INFO NHibernate.Cfg.Configuration
processing one-to-many association mappings
#2008-03-09 18:47:36,179 [10] INFO NHibernate.Cfg.Configuration
processing one-to-one association property references
#2008-03-09 18:47:36,179 [10] INFO NHibernate.Cfg.Configuration
processing foreign key constraints
#2008-03-09 18:47:36,183 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: TeamLeader
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: TypeContract
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: EmployeeReason
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Resource
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Group
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: User
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Team
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: GroupeApplication
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: ZoneLocation
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: CategoryProfession
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: SubTbs
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Application
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: TeamLeader
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Year
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: RC
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: LeavingReason
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: CategoryContract
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: CategoryTBD
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: CategoryContract
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Service
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: GroupRight
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Resource
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Contract
#2008-03-09 18:47:36,185 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Month
#2008-03-09 18:47:36,186 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Profession
#2008-03-09 18:47:36,186 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Year
#2008-03-09 18:47:36,186 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Tbs
#2008-03-09 18:47:36,186 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: TbsType
#2008-03-09 18:47:36,186 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Priority
#2008-03-09 18:47:36,186 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Service
#2008-03-09 18:47:36,186 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Group
#2008-03-09 18:47:36,186 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Right
#2008-03-09 18:47:36,186 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Work
#2008-03-09 18:47:36,186 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Contract
#2008-03-09 18:47:36,186 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: User
#2008-03-09 18:47:36,186 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: RC
#2008-03-09 18:47:36,187 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Location
#2008-03-09 18:47:36,187 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Zone
#2008-03-09 18:47:36,187 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: LeavingReason
#2008-03-09 18:47:36,187 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Application
#2008-03-09 18:47:36,187 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: RC
#2008-03-09 18:47:36,187 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Resource
#2008-03-09 18:47:36,187 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: TeamLeader
#2008-03-09 18:47:36,187 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Month
#2008-03-09 18:47:36,187 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Work
#2008-03-09 18:47:36,187 [10] DEBUG NHibernate.Cfg.Configuration
resolving reference to class: Year
#2008-03-09 18:47:36,201 [10] INFO NHibernate.Dialect.Dialect
Using dialect: NHibernate.Dialect.MsSql2005Dialect
#2008-03-09 18:47:36,204 [10] INFO NHibernate.Connection.ConnectionProviderFactory
Initializing connection provider: NHibernate.Connection.DriverConnectionProvider
#2008-03-09 18:47:36,205 [10] INFO NHibernate.Connection.ConnectionProvider
Configuring ConnectionProvider
#2008-03-09 18:47:36,211 [10] INFO NHibernate.Cfg.SettingsFactory
Optimize cache for minimal puts: False
#2008-03-09 18:47:36,211 [10] INFO NHibernate.Cfg.SettingsFactory
Connection release mode: auto
#2008-03-09 18:47:36,211 [10] INFO NHibernate.Cfg.SettingsFactory
Query translator: NHibernate.Hql.Classic.ClassicQueryTranslatorFactory
#2008-03-09 18:47:36,214 [10] INFO NHibernate.Cfg.SettingsFactory
Query language substitutions: {}
#2008-03-09 18:47:36,215 [10] INFO NHibernate.Cfg.SettingsFactory
cache provider: NHibernate.Cache.NoCacheProvider, NHibernate, Version=1.2.0.3001, Culture=neutral, PublicKeyToken=aa95f207798dfdb4
#2008-03-09 18:47:36,227 [10] INFO NHibernate.Impl.SessionFactoryImpl
building session factory
#2008-03-09 18:47:36,229 [10] DEBUG NHibernate.Impl.SessionFactoryImpl
instantiating session factory with properties: {hibernate.dialect=NHibernate.Dialect.MsSql2005Dialect, hibernate.connection.connection_string=Server=PC-DE-RANDO\SQLEXPRESS;initial catalog=staffplan;Integrated Security=True
, dialect=NHibernate.Dialect.MsSql2005Dialect, connection.driver_class=NHibernate.Driver.SqlClientDriver, hibernate.connection.driver_class=NHibernate.Driver.SqlClientDriver, hibernate.use_reflection_optimizer=true, connection.connection_string=Server=PC-DE-RANDO\SQLEXPRESS;initial catalog=staffplan;Integrated Security=True
, connection.provider=NHibernate.Connection.DriverConnectionProvider, hibernate.connection.provider=NHibernate.Connection.DriverConnectionProvider}
#2008-03-09 18:47:36,408 [10] DEBUG NHibernate.Impl.SessionFactoryObjectFactory
initializing class SessionFactoryObjectFactory
#2008-03-09 18:47:36,409 [10] DEBUG NHibernate.Impl.SessionFactoryObjectFactory
registered: dc062ca795e543b185aebed6ffc2788f(unnamed)
#2008-03-09 18:47:36,409 [10] INFO NHibernate.Impl.SessionFactoryObjectFactory
no name configured
#2008-03-09 18:47:36,535 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Team: SELECT team0_.idEquipe as idEquipe20_0_, team0_.nom_equipe as nom2_20_0_ FROM Equipe team0_ WHERE team0_.idEquipe=?
#2008-03-09 18:47:36,536 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Team: SELECT team0_.idEquipe as idEquipe20_0_, team0_.nom_equipe as nom2_20_0_ FROM Equipe team0_ WHERE team0_.idEquipe=?
#2008-03-09 18:47:36,536 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Team: SELECT team0_.idEquipe as idEquipe20_0_, team0_.nom_equipe as nom2_20_0_ FROM Equipe team0_ WHERE team0_.idEquipe=?
#2008-03-09 18:47:36,537 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Team: SELECT team0_.idEquipe as idEquipe20_0_, team0_.nom_equipe as nom2_20_0_ FROM Equipe team0_ WHERE team0_.idEquipe=?
#2008-03-09 18:47:36,539 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Month: SELECT month0_.idMonth as idMonth7_0_, month0_.month as month7_0_ FROM month month0_ WHERE month0_.idMonth=?
#2008-03-09 18:47:36,541 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Month: SELECT month0_.idMonth as idMonth7_0_, month0_.month as month7_0_ FROM month month0_ WHERE month0_.idMonth=?
#2008-03-09 18:47:36,541 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Month: SELECT month0_.idMonth as idMonth7_0_, month0_.month as month7_0_ FROM month month0_ WHERE month0_.idMonth=?
#2008-03-09 18:47:36,541 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Month: SELECT month0_.idMonth as idMonth7_0_, month0_.month as month7_0_ FROM month month0_ WHERE month0_.idMonth=?
#2008-03-09 18:47:36,560 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.GroupRight: SELECT groupright0_.id as id28_2_, groupright0_.idgroup as idgroup28_2_, groupright0_.idright as idright28_2_, groupright0_.myread as myread28_2_, groupright0_.mywrite as mywrite28_2_, group1_.id as id18_0_, group1_.name as name18_0_, group1_.GroupType as GroupType18_0_, right2_.id as id27_1_, right2_.name as name27_1_, right2_.RightType as RightType27_1_ FROM groupright groupright0_ left outer join groups group1_ on groupright0_.idgroup=group1_.id left outer join myright right2_ on groupright0_.idright=right2_.id WHERE groupright0_.id=?
#2008-03-09 18:47:36,561 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.GroupRight: SELECT groupright0_.id as id28_2_, groupright0_.idgroup as idgroup28_2_, groupright0_.idright as idright28_2_, groupright0_.myread as myread28_2_, groupright0_.mywrite as mywrite28_2_, group1_.id as id18_0_, group1_.name as name18_0_, group1_.GroupType as GroupType18_0_, right2_.id as id27_1_, right2_.name as name27_1_, right2_.RightType as RightType27_1_ FROM groupright groupright0_ left outer join groups group1_ on groupright0_.idgroup=group1_.id left outer join myright right2_ on groupright0_.idright=right2_.id WHERE groupright0_.id=?
#2008-03-09 18:47:36,561 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.GroupRight: SELECT groupright0_.id as id28_0_, groupright0_.idgroup as idgroup28_0_, groupright0_.idright as idright28_0_, groupright0_.myread as myread28_0_, groupright0_.mywrite as mywrite28_0_ FROM groupright groupright0_ WHERE groupright0_.id=?
#2008-03-09 18:47:36,561 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.GroupRight: SELECT groupright0_.id as id28_0_, groupright0_.idgroup as idgroup28_0_, groupright0_.idright as idright28_0_, groupright0_.myread as myread28_0_, groupright0_.mywrite as mywrite28_0_ FROM groupright groupright0_ WHERE groupright0_.id=?
#2008-03-09 18:47:36,561 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Application: SELECT applicatio0_.idApplication as idApplic1_21_2_, applicatio0_.Budget_idBudget as Budget2_21_2_, applicatio0_.nom_application as nom3_21_2_, applicatio0_.Equipe_idEquipe as Equipe4_21_2_, applicatio0_.groupe as groupe21_2_, team1_.idEquipe as idEquipe20_0_, team1_.nom_equipe as nom2_20_0_, groupeappl2_.id as id19_1_, groupeappl2_.groupe as groupe19_1_ FROM application applicatio0_ left outer join Equipe team1_ on applicatio0_.Equipe_idEquipe=team1_.idEquipe left outer join GroupeApplication groupeappl2_ on applicatio0_.groupe=groupeappl2_.id WHERE applicatio0_.idApplication=?
#2008-03-09 18:47:36,561 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Application: SELECT applicatio0_.idApplication as idApplic1_21_2_, applicatio0_.Budget_idBudget as Budget2_21_2_, applicatio0_.nom_application as nom3_21_2_, applicatio0_.Equipe_idEquipe as Equipe4_21_2_, applicatio0_.groupe as groupe21_2_, team1_.idEquipe as idEquipe20_0_, team1_.nom_equipe as nom2_20_0_, groupeappl2_.id as id19_1_, groupeappl2_.groupe as groupe19_1_ FROM application applicatio0_ left outer join Equipe team1_ on applicatio0_.Equipe_idEquipe=team1_.idEquipe left outer join GroupeApplication groupeappl2_ on applicatio0_.groupe=groupeappl2_.id WHERE applicatio0_.idApplication=?
#2008-03-09 18:47:36,562 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Application: SELECT applicatio0_.idApplication as idApplic1_21_0_, applicatio0_.Budget_idBudget as Budget2_21_0_, applicatio0_.nom_application as nom3_21_0_, applicatio0_.Equipe_idEquipe as Equipe4_21_0_, applicatio0_.groupe as groupe21_0_ FROM application applicatio0_ WHERE applicatio0_.idApplication=?
#2008-03-09 18:47:36,562 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Application: SELECT applicatio0_.idApplication as idApplic1_21_0_, applicatio0_.Budget_idBudget as Budget2_21_0_, applicatio0_.nom_application as nom3_21_0_, applicatio0_.Equipe_idEquipe as Equipe4_21_0_, applicatio0_.groupe as groupe21_0_ FROM application applicatio0_ WHERE applicatio0_.idApplication=?
#2008-03-09 18:47:36,562 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Profession: SELECT profession0_.idProfession as idProfes1_4_1_, profession0_.nameProfession as nameProf2_4_1_, profession0_.IdCategory as IdCategory4_1_, categorypr1_.id as id3_0_, categorypr1_.name as name3_0_ FROM profession profession0_ left outer join CategoryProfession categorypr1_ on profession0_.IdCategory=categorypr1_.id WHERE profession0_.idProfession=?
#2008-03-09 18:47:36,562 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Profession: SELECT profession0_.idProfession as idProfes1_4_1_, profession0_.nameProfession as nameProf2_4_1_, profession0_.IdCategory as IdCategory4_1_, categorypr1_.id as id3_0_, categorypr1_.name as name3_0_ FROM profession profession0_ left outer join CategoryProfession categorypr1_ on profession0_.IdCategory=categorypr1_.id WHERE profession0_.idProfession=?
#2008-03-09 18:47:36,563 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Profession: SELECT profession0_.idProfession as idProfes1_4_0_, profession0_.nameProfession as nameProf2_4_0_, profession0_.IdCategory as IdCategory4_0_ FROM profession profession0_ WHERE profession0_.idProfession=?
#2008-03-09 18:47:36,563 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Profession: SELECT profession0_.idProfession as idProfes1_4_0_, profession0_.nameProfession as nameProf2_4_0_, profession0_.IdCategory as IdCategory4_0_ FROM profession profession0_ WHERE profession0_.idProfession=?
#2008-03-09 18:47:36,563 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Zone: SELECT zone0_.id as id13_0_, zone0_.name as name13_0_ FROM zone zone0_ WHERE zone0_.id=?
#2008-03-09 18:47:36,563 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Zone: SELECT zone0_.id as id13_0_, zone0_.name as name13_0_ FROM zone zone0_ WHERE zone0_.id=?
#2008-03-09 18:47:36,563 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Zone: SELECT zone0_.id as id13_0_, zone0_.name as name13_0_ FROM zone zone0_ WHERE zone0_.id=?
#2008-03-09 18:47:36,563 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Zone: SELECT zone0_.id as id13_0_, zone0_.name as name13_0_ FROM zone zone0_ WHERE zone0_.id=?
#2008-03-09 18:47:36,564 [10] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader
Static select for entity Rad.StaffPlan.Core.Domain.Contract: SELECT contract0_.id as id11_8_, contract0_.IdEmployeeReason as IdEmploy2_11_8_, contract0_.IdEmployeeContract as IdEmploy3_11_8_, contract0_.IdRH as IdRH11_8_, contract0_.Matricule as Matricule11_8_, contract0_.NumAO as NumAO11_8_, contract0_.validation as validation11_8_, contract0_.DateEnter as DateEnter11_8_, contract0_.DateLeave as DateLeave11_8_, resource1_.idMembre as idMembre6_0_, resource1_.nom as nom6_0_, resource1_.prenom as prenom6_0_, resource1_.Alias as Alias6_0_, resource1_.tbdStatus as tbdStatus6_0_, resource1_.beginExpFunctional as beginExp6_6_0_, resource1_.BeginExpProfession as BeginExp7_6_0_, resource1_.BeginExpReal as BeginExp8_6_0_, resource1_.beginExpSG as beginExpSG6_0_, resource1_.beginExpSSII as beginEx10_6_0_, resource1_.validation as validation6_0_, resource1_.idCategoryTBD as idCateg12_6_0_, categorytb2_.id as id5_1_, categorytb2_.name as name5_1_, typecontra3_.id as id2_2_, typecontra3_.name as name2_2_, typecontra3_.IdCategory as IdCategory2_2_, categoryco4_.id as id1_3_, categoryco4_.name as name1_3_, employeere5_.id as id10_4_, employeere5_.IdCategory as IdCategory10_4_, employeere5_.IdReason as IdReason10_4_, leavingrea6_.id as id9_5_, leavingrea6_.name as name9_5_, leavingrea6_.IdParent as IdParent9_5_, leavingrea7_.id as id9_6_, leavingrea7_.name as name9_6_, leavingrea7_.IdParent as IdParent9_6_, categoryco8_.id as id1_7_, categoryco8_.name as name1_7_ FROM Contract contract0_ left outer join CioMembre resource1_ on contract0_.IdRH=resource1_.idMembre left outer join CategoryTBD categorytb2_ on resource1_.idCategoryTBD=categorytb2_.id left outer join TypeContract typecontra3_ on c

How are you querying the database and how does your mapping look?

Here is the mapping for the user table:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="Rad.StaffPlan.Core.Domain.User, Rad.StaffPlan.Core" table="usertable" lazy ="false">
<id name="ID" column="idUser" type="int" length="10">
<generator class="native">
<param name="sequence">iduser</param>
</generator>
</id>
<property name="Name" column="nom" type="String" length="255" not-null="true"/>
<property name="FirstName" column="prenom" type="String" length="255" not-null="true"/>
<property name="Login" column="login" type="String" length="255" not-null="true"/>
<property name="Password" column="pass" type="String" length="255" not-null="true"/>
</class>
</hibernate-mapping>

The function i use his



I don't know what "Static select for entity..." means...
Any explanations ?

How do you retrieve the data, which ICriterion do you send. Im pretty sure that you somehow ask for the data if you don't have a mapping that is requesting it. nHibernate don't fetch objects unless you instruct it to ;)

For this example i don't send any criteron as i want to get all the record of user table...

I have noticed that all the weird select are marked "Static select for entity...", do you know what it is ?

Ahh, sorry i overlooked that in the wealth of information. Static selects arent actually executed its nHibernates internal "query plan" for how to retrieve all the mapped types. So it doesn't have to generate the SQL string each time

okay , thanks ! :)

i have another question:

i have a mapping like this one:



If i do a



does nhibernate make one big query or is it doing several select (to retrieve collections for team and groupeapplication) ?
Is it necessary to do something like .SetFetchMode("Team", join) to have only 1 query ?

SetFetchMode is used to override the settings in your mappingfile.

So as you have no fetchmode or specifications for lazyloading in you mapping file it will do several selects in your case.

i have specify lazy in:


Not Enough ?

You have to specify it on you <many-to-one elements using lazy="false" and perhabs specify a fetchmode using feth="join" or fetch="select"

Are you sure ?

Because in the log file i have:

SELECT this_.idApplication as idApplic1_21_2_, this_.Budget_idBudget as Budget2_21_2_, this_.nom_application as nom3_21_2_, this_.Equipe_idEquipe as Equipe4_21_2_, this_.groupe as groupe21_2_, team2_.idEquipe as idEquipe20_0_, team2_.nom_equipe as nom2_20_0_, groupeappl3_.id as id19_1_, groupeappl3_.groupe as groupe19_1_
FROM application this_ left outer join Equipe team2_ on this_.Equipe_idEquipe=team2_.idEquipe
left outer join GroupeApplication groupeappl3_ on this_.groupe=groupeappl3_.id

Seems that is doing the join by itself..

As far as i remember fetch defaults to select, so if it isn't specified it should be executed by sequntial selects

Yeah, the documentation does say that the default fetch mode is select but this is not what I am seeing in my profiler either...it is joining the many-to-ones by default:

http://forum.hibernate.org/viewtopic.ph ... highlight=