<class name="XManager.Business.Afspraak, XManager.Business" table="Afspraak" lazy="false" mutable="false">
<id name="Id" type="int">
  <generator class="identity" />
</id>   
<property name="StartDatum" column="StartDatum"/>
<property name="EindDatum" column="EindDatum"/>
<property name="Herhalend" column="Herhalend"/>
<property name="HerhaalInterval" column="HerhaalInterval"/>
<property name="Opmerking" column="Opmerking"/>
<property name="Status" column="Status"/>
<property name="ToevoegDatumTijd" column="ToevoegDatumTijd"/>
<property name="WijzigDatumTijd" column="WijzigDatumTijd"/>

<many-to-one name="Klant" column="KlantId" class="Klant"/>

<bag name="Behandelingen" table="AfspraakBehandelingen" lazy="false" cascade="all-delete-orphan">
  <key column="AfspraakId"/>
  <many-to-many class="Behandeling" column="BehandelingId"/>
</bag>

<class name="XManager.Business.Behandeling, XManager.Business" table="Behandeling" lazy="false" mutable="false">
<id name="Id" type="int">
  <generator class="identity" />
</id>
<property name="Naam" column="Naam"/>
<property name="Omschrijving" column="Omschrijving"/>
<property name="Duur" column="Duur"/>
<property name="Prijs" column="Prijs"/>
<property name="ToevoegDatumTijd" column="ToevoegDatumTijd"/>
<property name="WijzigDatumTijd" column="WijzigDatumTijd"/>

<many-to-one name="Categorie" column="CategorieId" class="Categorie"/>

USE [XManager]
GO
/****** Object:  Table [dbo].[Afspraak]    Script Date: 08/24/2009 23:14:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Afspraak](
   [Id] [int] IDENTITY(1,1) NOT NULL,
   [KlantId] [int] NOT NULL,
   [StartDatum] [datetime] NOT NULL,
   [EindDatum] [datetime] NOT NULL,
   [Herhalend] [bit] NOT NULL,
   [HerhaalInterval] [smallint] NULL,
   [Opmerking] [varchar](150) COLLATE Latin1_General_CI_AS NULL,
   [Status] [smallint] NOT NULL,
   [ToevoegDatumTijd] [datetime] NOT NULL,
   [ToevoegGebruikerId] [int] NULL,
   [WijzigDatumTijd] [datetime] NULL,
   [WijzigGebruikerId] [int] NULL,
CONSTRAINT [PK_Afspraak] PRIMARY KEY CLUSTERED
(
   [Id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[AfspraakBehandelingen]    Script Date: 08/24/2009 23:14:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AfspraakBehandelingen](
   [Id] [int] IDENTITY(1,1) NOT NULL,
   [AfspraakId] [int] NOT NULL,
   [BehandelingId] [int] NOT NULL,
CONSTRAINT [PK_AfspraakBehandelingen] PRIMARY KEY CLUSTERED
(
   [Id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Behandeling]    Script Date: 08/24/2009 23:14:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Behandeling](
   [Id] [int] IDENTITY(1,1) NOT NULL,
   [Naam] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
   [Omschrijving] [varchar](200) COLLATE Latin1_General_CI_AS NULL,
   [Duur] [smallint] NULL,
   [Prijs] [float] NOT NULL,
   [ToevoegDatumTijd] [datetime] NOT NULL,
   [ToevoegGebruikerId] [int] NULL,
   [WijzigDatumTijd] [datetime] NULL,
   [WijzigGebruikerId] [int] NULL,
   [CategorieId] [int] NOT NULL,
CONSTRAINT [PK_Behandeling] PRIMARY KEY CLUSTERED
(
   [Id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Afspraak]  WITH CHECK ADD  CONSTRAINT [FK_Afspraak_Klant] FOREIGN KEY([KlantId])
REFERENCES [dbo].[Klant] ([Id])
GO
ALTER TABLE [dbo].[Afspraak] CHECK CONSTRAINT [FK_Afspraak_Klant]
GO
ALTER TABLE [dbo].[AfspraakBehandelingen]  WITH CHECK ADD  CONSTRAINT [FK_AfspraakBehandelingen_Afspraak] FOREIGN KEY([AfspraakId])
REFERENCES [dbo].[Afspraak] ([Id])
GO
ALTER TABLE [dbo].[AfspraakBehandelingen] CHECK CONSTRAINT [FK_AfspraakBehandelingen_Afspraak]
GO
ALTER TABLE [dbo].[AfspraakBehandelingen]  WITH CHECK ADD  CONSTRAINT [FK_AfspraakBehandelingen_Behandeling] FOREIGN KEY([BehandelingId])
REFERENCES [dbo].[Behandeling] ([Id])
GO
ALTER TABLE [dbo].[AfspraakBehandelingen] CHECK CONSTRAINT [FK_AfspraakBehandelingen_Behandeling]
GO
ALTER TABLE [dbo].[Behandeling]  WITH CHECK ADD  CONSTRAINT [FK_Behandeling_Categorie] FOREIGN KEY([CategorieId])
REFERENCES [dbo].[Categorie] ([Id])
GO
ALTER TABLE [dbo].[Behandeling] CHECK CONSTRAINT [FK_Behandeling_Categorie]

2009-08-24 23:06:28,944 INFO NHibernate 2.1.0.1001 (2.1.0.1001)
2009-08-24 23:06:28,991 INFO hibernate-configuration section not found in application configuration file
2009-08-24 23:06:28,991 INFO Bytecode provider name : lcg
2009-08-24 23:06:28,991 INFO Using reflection optimizer
2009-08-24 23:06:29,100 DEBUG dialect=NHibernate.Dialect.MsSql2005Dialect
2009-08-24 23:06:29,100 DEBUG connection.provider=NHibernate.Connection.DriverConnectionProvider
2009-08-24 23:06:29,100 DEBUG connection.connection_string=Data Source=xxxxxxxxx;Initial Catalog=XManager;Integrated Security=True
2009-08-24 23:06:29,100 DEBUG show_sql=true
2009-08-24 23:06:29,100 DEBUG cache.provider_class=NHibernate.Cache.HashtableCacheProvider, NHibernate, Version=2.1.0.1001, Culture=neutral, PublicKeyToken=aa95f207798dfdb4
2009-08-24 23:06:29,100 DEBUG <-XManager.Business
2009-08-24 23:06:29,100 INFO Searching for mapped documents in assembly: XManager.Business
2009-08-24 23:06:29,100 INFO Mapping resource: XManager.Business.Mapping.Afspraak.hbm.xml
2009-08-24 23:06:29,209 INFO Using dialect: NHibernate.Dialect.MsSql2005Dialect
2009-08-24 23:06:32,584 INFO Mapping class: XManager.Business.Afspraak -> Afspraak
2009-08-24 23:06:32,663 DEBUG Mapped property: Id -> Id, type: Int32
2009-08-24 23:06:32,741 DEBUG Mapped property: StartDatum -> StartDatum, type: DateTime
2009-08-24 23:06:32,741 DEBUG Mapped property: EindDatum -> EindDatum, type: DateTime
2009-08-24 23:06:32,741 DEBUG Mapped property: Herhalend -> Herhalend, type: Boolean
2009-08-24 23:06:32,756 DEBUG Mapped property: HerhaalInterval -> HerhaalInterval, type: XManager.Business.AfspraakHerhaling
2009-08-24 23:06:32,756 DEBUG Mapped property: Opmerking -> Opmerking, type: String
2009-08-24 23:06:32,756 DEBUG Mapped property: Status -> Status, type: XManager.Business.AfspraakStatus
2009-08-24 23:06:32,756 DEBUG Mapped property: ToevoegDatumTijd -> ToevoegDatumTijd, type: DateTime
2009-08-24 23:06:32,756 DEBUG Mapped property: WijzigDatumTijd -> WijzigDatumTijd, type: DateTime
2009-08-24 23:06:32,788 DEBUG Mapped property: Klant -> KlantId, type: XManager.Business.Klant
2009-08-24 23:06:32,803 INFO Mapping collection: XManager.Business.Afspraak.Behandelingen -> AfspraakBehandelingen
2009-08-24 23:06:32,819 DEBUG Mapped property: Behandelingen, type: System.Collections.Generic.IList`1[[XManager.Business.Behandeling, XManager.Business, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]](XManager.Business.Afspraak.Behandelingen)
2009-08-24 23:06:32,834 INFO Mapping resource: XManager.Business.Mapping.Categorie.hbm.xml
2009-08-24 23:06:32,866 INFO Using dialect: NHibernate.Dialect.MsSql2005Dialect
2009-08-24 23:06:32,866 INFO Mapping class: XManager.Business.Categorie -> Categorie
2009-08-24 23:06:32,866 DEBUG Mapped property: Id -> Id, type: Int32
2009-08-24 23:06:32,866 DEBUG Mapped property: Naam -> Naam, type: String
2009-08-24 23:06:32,866 DEBUG Mapped property: Omschrijving -> Omschrijving, type: String
2009-08-24 23:06:32,866 INFO Mapping resource: XManager.Business.Mapping.Klant.hbm.xml
2009-08-24 23:06:32,881 INFO Using dialect: NHibernate.Dialect.MsSql2005Dialect
2009-08-24 23:06:32,881 INFO Mapping class: XManager.Business.Klant -> Klant
2009-08-24 23:06:32,881 DEBUG Mapped property: Id -> Id, type: Int32
2009-08-24 23:06:32,881 DEBUG Mapped property: Voornaam -> Voornaam, type: String
2009-08-24 23:06:32,881 DEBUG Mapped property: Achternaam -> Achternaam, type: String
2009-08-24 23:06:32,881 DEBUG Mapped property: Adres -> Adres, type: String
2009-08-24 23:06:32,881 DEBUG Mapped property: Telefoon -> Telefoon, type: String
2009-08-24 23:06:32,881 DEBUG Mapped property: Gsm -> Gsm, type: String
2009-08-24 23:06:32,881 DEBUG Mapped property: Fax -> Fax, type: String
2009-08-24 23:06:32,881 DEBUG Mapped property: Email -> Email, type: String
2009-08-24 23:06:32,881 DEBUG Mapped property: Beroep -> Beroep, type: String
2009-08-24 23:06:32,881 DEBUG Mapped property: GeboorteDatum -> GeboorteDatum, type: DateTime
2009-08-24 23:06:32,881 DEBUG Mapped property: Rijksregisternummer -> RijksregisterNummer, type: String
2009-08-24 23:06:32,881 DEBUG Mapped property: ToevoegDatumTijd -> ToevoegDatumTijd, type: DateTime
2009-08-24 23:06:32,881 DEBUG Mapped property: WijzigDatumTijd -> WijzigDatumTijd, type: DateTime
2009-08-24 23:06:32,881 DEBUG Mapped property: Gemeente -> GemeenteId, type: XManager.Business.Gemeente
2009-08-24 23:06:32,881 INFO Mapping resource: XManager.Business.Mapping.Behandeling.hbm.xml
2009-08-24 23:06:32,897 INFO Using dialect: NHibernate.Dialect.MsSql2005Dialect
2009-08-24 23:06:32,913 INFO Mapping class: XManager.Business.Behandeling -> Behandeling
2009-08-24 23:06:32,913 DEBUG Mapped property: Id -> Id, type: Int32
2009-08-24 23:06:32,913 DEBUG Mapped property: Naam -> Naam, type: String
2009-08-24 23:06:32,913 DEBUG Mapped property: Omschrijving -> Omschrijving, type: String
2009-08-24 23:06:32,913 DEBUG Mapped property: Duur -> Duur, type: Int32
2009-08-24 23:06:32,913 DEBUG Mapped property: Prijs -> Prijs, type: Double
2009-08-24 23:06:32,913 DEBUG Mapped property: ToevoegDatumTijd -> ToevoegDatumTijd, type: DateTime
2009-08-24 23:06:32,913 DEBUG Mapped property: WijzigDatumTijd -> WijzigDatumTijd, type: DateTime
2009-08-24 23:06:32,913 DEBUG Mapped property: Categorie -> CategorieId, type: XManager.Business.Categorie
2009-08-24 23:06:32,913 INFO Mapping resource: XManager.Business.Mapping.Gemeente.hbm.xml
2009-08-24 23:06:32,928 INFO Using dialect: NHibernate.Dialect.MsSql2005Dialect
2009-08-24 23:06:32,928 INFO Mapping class: XManager.Business.Gemeente -> Gemeente
2009-08-24 23:06:32,928 DEBUG Mapped property: Id -> Id, type: Int32
2009-08-24 23:06:32,928 DEBUG Mapped property: Gemeentenaam -> Naam, type: String
2009-08-24 23:06:32,928 DEBUG Mapped property: Postcode -> Postcode, type: String
2009-08-24 23:06:32,928 DEBUG properties: System.Collections.Generic.Dictionary`2[System.String,System.String]
2009-08-24 23:06:32,944 INFO checking mappings queue
2009-08-24 23:06:32,944 INFO processing one-to-many association mappings
2009-08-24 23:06:32,944 DEBUG Second pass for collection: XManager.Business.Afspraak.Behandelingen
2009-08-24 23:06:32,959 DEBUG Mapped collection key: AfspraakId, element: BehandelingId, type: XManager.Business.Behandeling
2009-08-24 23:06:32,959 INFO processing one-to-one association property references
2009-08-24 23:06:32,959 INFO processing foreign key constraints
2009-08-24 23:06:32,959 DEBUG resolving reference to class: XManager.Business.Klant
2009-08-24 23:06:32,959 DEBUG resolving reference to class: XManager.Business.Behandeling
2009-08-24 23:06:32,959 DEBUG resolving reference to class: XManager.Business.Afspraak
2009-08-24 23:06:32,959 DEBUG resolving reference to class: XManager.Business.Gemeente
2009-08-24 23:06:32,959 DEBUG resolving reference to class: XManager.Business.Categorie
2009-08-24 23:06:33,022 INFO Using dialect: NHibernate.Dialect.MsSql2005Dialect
2009-08-24 23:06:33,038 INFO Using dialect defined converter
2009-08-24 23:06:33,038 INFO Initializing connection provider: NHibernate.Connection.DriverConnectionProvider
2009-08-24 23:06:33,038 INFO Configuring ConnectionProvider
2009-08-24 23:06:33,038 INFO Transaction factory: NHibernate.Transaction.AdoNetTransactionFactory
2009-08-24 23:06:33,038 INFO Optimize cache for minimal puts: False
2009-08-24 23:06:33,038 INFO Connection release mode: auto
2009-08-24 23:06:33,038 INFO Default batch fetch size: 1
2009-08-24 23:06:33,038 INFO echoing all SQL to stdout
2009-08-24 23:06:33,038 INFO Statistics: disabled
2009-08-24 23:06:33,038 INFO Deleted entity synthetic identifier rollback: disabled
2009-08-24 23:06:33,053 INFO Query translator: NHibernate.Hql.Classic.ClassicQueryTranslatorFactory
2009-08-24 23:06:33,053 INFO Query language substitutions: {}
2009-08-24 23:06:33,053 INFO cache provider: NHibernate.Cache.HashtableCacheProvider, NHibernate, Version=2.1.0.1001, Culture=neutral, PublicKeyToken=aa95f207798dfdb4
2009-08-24 23:06:33,053 DEBUG Wrap result sets: disabled
2009-08-24 23:06:33,053 INFO Batcher factory: NHibernate.AdoNet.NonBatchingBatcherFactory, NHibernate, Version=2.1.0.1001, Culture=neutral, PublicKeyToken=aa95f207798dfdb4
2009-08-24 23:06:33,053 INFO Named query checking : enabled
2009-08-24 23:06:33,116 INFO building session factory
2009-08-24 23:06:33,116 DEBUG Session factory constructed with filter configurations : {}
2009-08-24 23:06:33,116 DEBUG instantiating session factory with properties: {use_reflection_optimizer=True, hibernate.search.default.directory_provider=NHibernate.Search.Store.FSDirectoryProvider, NHibernate.Search, hibernate.search.default.indexBase=~/Index, dialect=NHibernate.Dialect.MsSql2005Dialect, connection.provider=NHibernate.Connection.DriverConnectionProvider, connection.connection_string=Data Source=xxxxxxxxxxxxxxxx;Initial Catalog=XManager;Integrated Security=True, show_sql=true, cache.provider_class=NHibernate.Cache.HashtableCacheProvider, NHibernate, Version=2.1.0.1001, Culture=neutral, PublicKeyToken=aa95f207798dfdb4}
2009-08-24 23:06:33,725 DEBUG Static SQL for collection: XManager.Business.Afspraak.Behandelingen
2009-08-24 23:06:33,725 DEBUG  Row insert: INSERT INTO AfspraakBehandelingen (AfspraakId, BehandelingId) VALUES (?, ?)
2009-08-24 23:06:33,725 DEBUG  Row update: UPDATE AfspraakBehandelingen SET BehandelingId = ? WHERE AfspraakId = ? AND BehandelingId = ?
2009-08-24 23:06:33,725 DEBUG  Row delete: DELETE FROM AfspraakBehandelingen WHERE AfspraakId = ? AND BehandelingId = ?
2009-08-24 23:06:33,725 DEBUG  One-shot delete: DELETE FROM AfspraakBehandelingen WHERE AfspraakId = ?
2009-08-24 23:06:33,819 DEBUG Static SQL for entity: XManager.Business.Afspraak
2009-08-24 23:06:33,819 DEBUG  Version select: SELECT Id FROM Afspraak WHERE Id = ?
2009-08-24 23:06:33,819 DEBUG  Snapshot select: SELECT afspraak_.Id, afspraak_.StartDatum as StartDatum0_, afspraak_.EindDatum as EindDatum0_, afspraak_.Herhalend as Herhalend0_, afspraak_.HerhaalInterval as HerhaalI5_0_, afspraak_.Opmerking as Opmerking0_, afspraak_.Status as Status0_, afspraak_.ToevoegDatumTijd as ToevoegD8_0_, afspraak_.WijzigDatumTijd as WijzigDa9_0_, afspraak_.KlantId as KlantId0_ FROM Afspraak afspraak_ WHERE afspraak_.Id=?
2009-08-24 23:06:33,819 DEBUG  Insert 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,819 DEBUG  Update 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,819 DEBUG  Delete 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,819 DEBUG  Identity insert: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,928 DEBUG Static select for entity XManager.Business.Afspraak: SELECT afspraak0_.Id as Id0_2_, afspraak0_.StartDatum as StartDatum0_2_, afspraak0_.EindDatum as EindDatum0_2_, afspraak0_.Herhalend as Herhalend0_2_, afspraak0_.HerhaalInterval as HerhaalI5_0_2_, afspraak0_.Opmerking as Opmerking0_2_, afspraak0_.Status as Status0_2_, afspraak0_.ToevoegDatumTijd as ToevoegD8_0_2_, afspraak0_.WijzigDatumTijd as WijzigDa9_0_2_, afspraak0_.KlantId as KlantId0_2_, klant1_.Id as Id3_0_, klant1_.Voornaam as Voornaam3_0_, klant1_.Achternaam as Achternaam3_0_, klant1_.Adres as Adres3_0_, klant1_.Telefoon as Telefoon3_0_, klant1_.Gsm as Gsm3_0_, klant1_.Fax as Fax3_0_, klant1_.Email as Email3_0_, klant1_.Beroep as Beroep3_0_, klant1_.GeboorteDatum as Geboort10_3_0_, klant1_.RijksregisterNummer as Rijksre11_3_0_, klant1_.ToevoegDatumTijd as Toevoeg12_3_0_, klant1_.WijzigDatumTijd as WijzigD13_3_0_, klant1_.GemeenteId as GemeenteId3_0_, gemeente2_.Id as Id5_1_, gemeente2_.Naam as Naam5_1_, gemeente2_.Postcode as Postcode5_1_ FROM Afspraak afspraak0_ left outer join Klant klant1_ on afspraak0_.KlantId=klant1_.Id left outer join Gemeente gemeente2_ on klant1_.GemeenteId=gemeente2_.Id WHERE afspraak0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Afspraak: SELECT afspraak0_.Id as Id0_2_, afspraak0_.StartDatum as StartDatum0_2_, afspraak0_.EindDatum as EindDatum0_2_, afspraak0_.Herhalend as Herhalend0_2_, afspraak0_.HerhaalInterval as HerhaalI5_0_2_, afspraak0_.Opmerking as Opmerking0_2_, afspraak0_.Status as Status0_2_, afspraak0_.ToevoegDatumTijd as ToevoegD8_0_2_, afspraak0_.WijzigDatumTijd as WijzigDa9_0_2_, afspraak0_.KlantId as KlantId0_2_, klant1_.Id as Id3_0_, klant1_.Voornaam as Voornaam3_0_, klant1_.Achternaam as Achternaam3_0_, klant1_.Adres as Adres3_0_, klant1_.Telefoon as Telefoon3_0_, klant1_.Gsm as Gsm3_0_, klant1_.Fax as Fax3_0_, klant1_.Email as Email3_0_, klant1_.Beroep as Beroep3_0_, klant1_.GeboorteDatum as Geboort10_3_0_, klant1_.RijksregisterNummer as Rijksre11_3_0_, klant1_.ToevoegDatumTijd as Toevoeg12_3_0_, klant1_.WijzigDatumTijd as WijzigD13_3_0_, klant1_.GemeenteId as GemeenteId3_0_, gemeente2_.Id as Id5_1_, gemeente2_.Naam as Naam5_1_, gemeente2_.Postcode as Postcode5_1_ FROM Afspraak afspraak0_ left outer join Klant klant1_ on afspraak0_.KlantId=klant1_.Id left outer join Gemeente gemeente2_ on klant1_.GemeenteId=gemeente2_.Id WHERE afspraak0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Afspraak: SELECT afspraak0_.Id as Id0_0_, afspraak0_.StartDatum as StartDatum0_0_, afspraak0_.EindDatum as EindDatum0_0_, afspraak0_.Herhalend as Herhalend0_0_, afspraak0_.HerhaalInterval as HerhaalI5_0_0_, afspraak0_.Opmerking as Opmerking0_0_, afspraak0_.Status as Status0_0_, afspraak0_.ToevoegDatumTijd as ToevoegD8_0_0_, afspraak0_.WijzigDatumTijd as WijzigDa9_0_0_, afspraak0_.KlantId as KlantId0_0_ FROM Afspraak afspraak0_ with (updlock, rowlock) WHERE afspraak0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Afspraak: SELECT afspraak0_.Id as Id0_0_, afspraak0_.StartDatum as StartDatum0_0_, afspraak0_.EindDatum as EindDatum0_0_, afspraak0_.Herhalend as Herhalend0_0_, afspraak0_.HerhaalInterval as HerhaalI5_0_0_, afspraak0_.Opmerking as Opmerking0_0_, afspraak0_.Status as Status0_0_, afspraak0_.ToevoegDatumTijd as ToevoegD8_0_0_, afspraak0_.WijzigDatumTijd as WijzigDa9_0_0_, afspraak0_.KlantId as KlantId0_0_ FROM Afspraak afspraak0_ with (updlock, rowlock) WHERE afspraak0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Afspraak: SELECT afspraak0_.Id as Id0_0_, afspraak0_.StartDatum as StartDatum0_0_, afspraak0_.EindDatum as EindDatum0_0_, afspraak0_.Herhalend as Herhalend0_0_, afspraak0_.HerhaalInterval as HerhaalI5_0_0_, afspraak0_.Opmerking as Opmerking0_0_, afspraak0_.Status as Status0_0_, afspraak0_.ToevoegDatumTijd as ToevoegD8_0_0_, afspraak0_.WijzigDatumTijd as WijzigDa9_0_0_, afspraak0_.KlantId as KlantId0_0_ FROM Afspraak afspraak0_ with (updlock, rowlock) WHERE afspraak0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for action NHibernate.Engine.CascadingAction+MergeCascadingAction on entity XManager.Business.Afspraak: SELECT afspraak0_.Id as Id0_0_, afspraak0_.StartDatum as StartDatum0_0_, afspraak0_.EindDatum as EindDatum0_0_, afspraak0_.Herhalend as Herhalend0_0_, afspraak0_.HerhaalInterval as HerhaalI5_0_0_, afspraak0_.Opmerking as Opmerking0_0_, afspraak0_.Status as Status0_0_, afspraak0_.ToevoegDatumTijd as ToevoegD8_0_0_, afspraak0_.WijzigDatumTijd as WijzigDa9_0_0_, afspraak0_.KlantId as KlantId0_0_ FROM Afspraak afspraak0_ WHERE afspraak0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for action NHibernate.Engine.CascadingAction+RefreshCascadingAction on entity XManager.Business.Afspraak: SELECT afspraak0_.Id as Id0_0_, afspraak0_.StartDatum as StartDatum0_0_, afspraak0_.EindDatum as EindDatum0_0_, afspraak0_.Herhalend as Herhalend0_0_, afspraak0_.HerhaalInterval as HerhaalI5_0_0_, afspraak0_.Opmerking as Opmerking0_0_, afspraak0_.Status as Status0_0_, afspraak0_.ToevoegDatumTijd as ToevoegD8_0_0_, afspraak0_.WijzigDatumTijd as WijzigDa9_0_0_, afspraak0_.KlantId as KlantId0_0_ FROM Afspraak afspraak0_ WHERE afspraak0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static SQL for entity: XManager.Business.Categorie
2009-08-24 23:06:33,944 DEBUG  Version select: SELECT Id FROM Categorie WHERE Id = ?
2009-08-24 23:06:33,944 DEBUG  Snapshot select: SELECT categorie_.Id, categorie_.Naam as Naam2_, categorie_.Omschrijving as Omschrij3_2_ FROM Categorie categorie_ WHERE categorie_.Id=?
2009-08-24 23:06:33,944 DEBUG  Insert 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG  Update 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG  Delete 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG  Identity insert: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Categorie: SELECT categorie0_.Id as Id2_0_, categorie0_.Naam as Naam2_0_, categorie0_.Omschrijving as Omschrij3_2_0_ FROM Categorie categorie0_ WHERE categorie0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Categorie: SELECT categorie0_.Id as Id2_0_, categorie0_.Naam as Naam2_0_, categorie0_.Omschrijving as Omschrij3_2_0_ FROM Categorie categorie0_ WHERE categorie0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Categorie: SELECT categorie0_.Id as Id2_0_, categorie0_.Naam as Naam2_0_, categorie0_.Omschrijving as Omschrij3_2_0_ FROM Categorie categorie0_ with (updlock, rowlock) WHERE categorie0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Categorie: SELECT categorie0_.Id as Id2_0_, categorie0_.Naam as Naam2_0_, categorie0_.Omschrijving as Omschrij3_2_0_ FROM Categorie categorie0_ with (updlock, rowlock) WHERE categorie0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Categorie: SELECT categorie0_.Id as Id2_0_, categorie0_.Naam as Naam2_0_, categorie0_.Omschrijving as Omschrij3_2_0_ FROM Categorie categorie0_ with (updlock, rowlock) WHERE categorie0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for action NHibernate.Engine.CascadingAction+MergeCascadingAction on entity XManager.Business.Categorie: SELECT categorie0_.Id as Id2_0_, categorie0_.Naam as Naam2_0_, categorie0_.Omschrijving as Omschrij3_2_0_ FROM Categorie categorie0_ WHERE categorie0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for action NHibernate.Engine.CascadingAction+RefreshCascadingAction on entity XManager.Business.Categorie: SELECT categorie0_.Id as Id2_0_, categorie0_.Naam as Naam2_0_, categorie0_.Omschrijving as Omschrij3_2_0_ FROM Categorie categorie0_ WHERE categorie0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static SQL for entity: XManager.Business.Klant
2009-08-24 23:06:33,944 DEBUG  Version select: SELECT Id FROM Klant WHERE Id = ?
2009-08-24 23:06:33,944 DEBUG  Snapshot select: SELECT klant_.Id, klant_.Voornaam as Voornaam3_, klant_.Achternaam as Achternaam3_, klant_.Adres as Adres3_, klant_.Telefoon as Telefoon3_, klant_.Gsm as Gsm3_, klant_.Fax as Fax3_, klant_.Email as Email3_, klant_.Beroep as Beroep3_, klant_.GeboorteDatum as Geboort10_3_, klant_.RijksregisterNummer as Rijksre11_3_, klant_.ToevoegDatumTijd as Toevoeg12_3_, klant_.WijzigDatumTijd as WijzigD13_3_, klant_.GemeenteId as GemeenteId3_ FROM Klant klant_ WHERE klant_.Id=?
2009-08-24 23:06:33,944 DEBUG  Insert 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG  Update 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG  Delete 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG  Identity insert: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Klant: SELECT klant0_.Id as Id3_1_, klant0_.Voornaam as Voornaam3_1_, klant0_.Achternaam as Achternaam3_1_, klant0_.Adres as Adres3_1_, klant0_.Telefoon as Telefoon3_1_, klant0_.Gsm as Gsm3_1_, klant0_.Fax as Fax3_1_, klant0_.Email as Email3_1_, klant0_.Beroep as Beroep3_1_, klant0_.GeboorteDatum as Geboort10_3_1_, klant0_.RijksregisterNummer as Rijksre11_3_1_, klant0_.ToevoegDatumTijd as Toevoeg12_3_1_, klant0_.WijzigDatumTijd as WijzigD13_3_1_, klant0_.GemeenteId as GemeenteId3_1_, gemeente1_.Id as Id5_0_, gemeente1_.Naam as Naam5_0_, gemeente1_.Postcode as Postcode5_0_ FROM Klant klant0_ left outer join Gemeente gemeente1_ on klant0_.GemeenteId=gemeente1_.Id WHERE klant0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Klant: SELECT klant0_.Id as Id3_1_, klant0_.Voornaam as Voornaam3_1_, klant0_.Achternaam as Achternaam3_1_, klant0_.Adres as Adres3_1_, klant0_.Telefoon as Telefoon3_1_, klant0_.Gsm as Gsm3_1_, klant0_.Fax as Fax3_1_, klant0_.Email as Email3_1_, klant0_.Beroep as Beroep3_1_, klant0_.GeboorteDatum as Geboort10_3_1_, klant0_.RijksregisterNummer as Rijksre11_3_1_, klant0_.ToevoegDatumTijd as Toevoeg12_3_1_, klant0_.WijzigDatumTijd as WijzigD13_3_1_, klant0_.GemeenteId as GemeenteId3_1_, gemeente1_.Id as Id5_0_, gemeente1_.Naam as Naam5_0_, gemeente1_.Postcode as Postcode5_0_ FROM Klant klant0_ left outer join Gemeente gemeente1_ on klant0_.GemeenteId=gemeente1_.Id WHERE klant0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Klant: SELECT klant0_.Id as Id3_0_, klant0_.Voornaam as Voornaam3_0_, klant0_.Achternaam as Achternaam3_0_, klant0_.Adres as Adres3_0_, klant0_.Telefoon as Telefoon3_0_, klant0_.Gsm as Gsm3_0_, klant0_.Fax as Fax3_0_, klant0_.Email as Email3_0_, klant0_.Beroep as Beroep3_0_, klant0_.GeboorteDatum as Geboort10_3_0_, klant0_.RijksregisterNummer as Rijksre11_3_0_, klant0_.ToevoegDatumTijd as Toevoeg12_3_0_, klant0_.WijzigDatumTijd as WijzigD13_3_0_, klant0_.GemeenteId as GemeenteId3_0_ FROM Klant klant0_ with (updlock, rowlock) WHERE klant0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Klant: SELECT klant0_.Id as Id3_0_, klant0_.Voornaam as Voornaam3_0_, klant0_.Achternaam as Achternaam3_0_, klant0_.Adres as Adres3_0_, klant0_.Telefoon as Telefoon3_0_, klant0_.Gsm as Gsm3_0_, klant0_.Fax as Fax3_0_, klant0_.Email as Email3_0_, klant0_.Beroep as Beroep3_0_, klant0_.GeboorteDatum as Geboort10_3_0_, klant0_.RijksregisterNummer as Rijksre11_3_0_, klant0_.ToevoegDatumTijd as Toevoeg12_3_0_, klant0_.WijzigDatumTijd as WijzigD13_3_0_, klant0_.GemeenteId as GemeenteId3_0_ FROM Klant klant0_ with (updlock, rowlock) WHERE klant0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Klant: SELECT klant0_.Id as Id3_0_, klant0_.Voornaam as Voornaam3_0_, klant0_.Achternaam as Achternaam3_0_, klant0_.Adres as Adres3_0_, klant0_.Telefoon as Telefoon3_0_, klant0_.Gsm as Gsm3_0_, klant0_.Fax as Fax3_0_, klant0_.Email as Email3_0_, klant0_.Beroep as Beroep3_0_, klant0_.GeboorteDatum as Geboort10_3_0_, klant0_.RijksregisterNummer as Rijksre11_3_0_, klant0_.ToevoegDatumTijd as Toevoeg12_3_0_, klant0_.WijzigDatumTijd as WijzigD13_3_0_, klant0_.GemeenteId as GemeenteId3_0_ FROM Klant klant0_ with (updlock, rowlock) WHERE klant0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for action NHibernate.Engine.CascadingAction+MergeCascadingAction on entity XManager.Business.Klant: SELECT klant0_.Id as Id3_0_, klant0_.Voornaam as Voornaam3_0_, klant0_.Achternaam as Achternaam3_0_, klant0_.Adres as Adres3_0_, klant0_.Telefoon as Telefoon3_0_, klant0_.Gsm as Gsm3_0_, klant0_.Fax as Fax3_0_, klant0_.Email as Email3_0_, klant0_.Beroep as Beroep3_0_, klant0_.GeboorteDatum as Geboort10_3_0_, klant0_.RijksregisterNummer as Rijksre11_3_0_, klant0_.ToevoegDatumTijd as Toevoeg12_3_0_, klant0_.WijzigDatumTijd as WijzigD13_3_0_, klant0_.GemeenteId as GemeenteId3_0_ FROM Klant klant0_ WHERE klant0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for action NHibernate.Engine.CascadingAction+RefreshCascadingAction on entity XManager.Business.Klant: SELECT klant0_.Id as Id3_0_, klant0_.Voornaam as Voornaam3_0_, klant0_.Achternaam as Achternaam3_0_, klant0_.Adres as Adres3_0_, klant0_.Telefoon as Telefoon3_0_, klant0_.Gsm as Gsm3_0_, klant0_.Fax as Fax3_0_, klant0_.Email as Email3_0_, klant0_.Beroep as Beroep3_0_, klant0_.GeboorteDatum as Geboort10_3_0_, klant0_.RijksregisterNummer as Rijksre11_3_0_, klant0_.ToevoegDatumTijd as Toevoeg12_3_0_, klant0_.WijzigDatumTijd as WijzigD13_3_0_, klant0_.GemeenteId as GemeenteId3_0_ FROM Klant klant0_ WHERE klant0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static SQL for entity: XManager.Business.Behandeling
2009-08-24 23:06:33,944 DEBUG  Version select: SELECT Id FROM Behandeling WHERE Id = ?
2009-08-24 23:06:33,944 DEBUG  Snapshot select: SELECT behandelin_.Id, behandelin_.Naam as Naam4_, behandelin_.Omschrijving as Omschrij3_4_, behandelin_.Duur as Duur4_, behandelin_.Prijs as Prijs4_, behandelin_.ToevoegDatumTijd as ToevoegD6_4_, behandelin_.WijzigDatumTijd as WijzigDa7_4_, behandelin_.CategorieId as Categori8_4_ FROM Behandeling behandelin_ WHERE behandelin_.Id=?
2009-08-24 23:06:33,944 DEBUG  Insert 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG  Update 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG  Delete 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG  Identity insert: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Behandeling: SELECT behandelin0_.Id as Id4_1_, behandelin0_.Naam as Naam4_1_, behandelin0_.Omschrijving as Omschrij3_4_1_, behandelin0_.Duur as Duur4_1_, behandelin0_.Prijs as Prijs4_1_, behandelin0_.ToevoegDatumTijd as ToevoegD6_4_1_, behandelin0_.WijzigDatumTijd as WijzigDa7_4_1_, behandelin0_.CategorieId as Categori8_4_1_, categorie1_.Id as Id2_0_, categorie1_.Naam as Naam2_0_, categorie1_.Omschrijving as Omschrij3_2_0_ FROM Behandeling behandelin0_ left outer join Categorie categorie1_ on behandelin0_.CategorieId=categorie1_.Id WHERE behandelin0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Behandeling: SELECT behandelin0_.Id as Id4_1_, behandelin0_.Naam as Naam4_1_, behandelin0_.Omschrijving as Omschrij3_4_1_, behandelin0_.Duur as Duur4_1_, behandelin0_.Prijs as Prijs4_1_, behandelin0_.ToevoegDatumTijd as ToevoegD6_4_1_, behandelin0_.WijzigDatumTijd as WijzigDa7_4_1_, behandelin0_.CategorieId as Categori8_4_1_, categorie1_.Id as Id2_0_, categorie1_.Naam as Naam2_0_, categorie1_.Omschrijving as Omschrij3_2_0_ FROM Behandeling behandelin0_ left outer join Categorie categorie1_ on behandelin0_.CategorieId=categorie1_.Id WHERE behandelin0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Behandeling: SELECT behandelin0_.Id as Id4_0_, behandelin0_.Naam as Naam4_0_, behandelin0_.Omschrijving as Omschrij3_4_0_, behandelin0_.Duur as Duur4_0_, behandelin0_.Prijs as Prijs4_0_, behandelin0_.ToevoegDatumTijd as ToevoegD6_4_0_, behandelin0_.WijzigDatumTijd as WijzigDa7_4_0_, behandelin0_.CategorieId as Categori8_4_0_ FROM Behandeling behandelin0_ with (updlock, rowlock) WHERE behandelin0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Behandeling: SELECT behandelin0_.Id as Id4_0_, behandelin0_.Naam as Naam4_0_, behandelin0_.Omschrijving as Omschrij3_4_0_, behandelin0_.Duur as Duur4_0_, behandelin0_.Prijs as Prijs4_0_, behandelin0_.ToevoegDatumTijd as ToevoegD6_4_0_, behandelin0_.WijzigDatumTijd as WijzigDa7_4_0_, behandelin0_.CategorieId as Categori8_4_0_ FROM Behandeling behandelin0_ with (updlock, rowlock) WHERE behandelin0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Behandeling: SELECT behandelin0_.Id as Id4_0_, behandelin0_.Naam as Naam4_0_, behandelin0_.Omschrijving as Omschrij3_4_0_, behandelin0_.Duur as Duur4_0_, behandelin0_.Prijs as Prijs4_0_, behandelin0_.ToevoegDatumTijd as ToevoegD6_4_0_, behandelin0_.WijzigDatumTijd as WijzigDa7_4_0_, behandelin0_.CategorieId as Categori8_4_0_ FROM Behandeling behandelin0_ with (updlock, rowlock) WHERE behandelin0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for action NHibernate.Engine.CascadingAction+MergeCascadingAction on entity XManager.Business.Behandeling: SELECT behandelin0_.Id as Id4_0_, behandelin0_.Naam as Naam4_0_, behandelin0_.Omschrijving as Omschrij3_4_0_, behandelin0_.Duur as Duur4_0_, behandelin0_.Prijs as Prijs4_0_, behandelin0_.ToevoegDatumTijd as ToevoegD6_4_0_, behandelin0_.WijzigDatumTijd as WijzigDa7_4_0_, behandelin0_.CategorieId as Categori8_4_0_ FROM Behandeling behandelin0_ WHERE behandelin0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for action NHibernate.Engine.CascadingAction+RefreshCascadingAction on entity XManager.Business.Behandeling: SELECT behandelin0_.Id as Id4_0_, behandelin0_.Naam as Naam4_0_, behandelin0_.Omschrijving as Omschrij3_4_0_, behandelin0_.Duur as Duur4_0_, behandelin0_.Prijs as Prijs4_0_, behandelin0_.ToevoegDatumTijd as ToevoegD6_4_0_, behandelin0_.WijzigDatumTijd as WijzigDa7_4_0_, behandelin0_.CategorieId as Categori8_4_0_ FROM Behandeling behandelin0_ WHERE behandelin0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static SQL for entity: XManager.Business.Gemeente
2009-08-24 23:06:33,944 DEBUG  Version select: SELECT Id FROM Gemeente WHERE Id = ?
2009-08-24 23:06:33,944 DEBUG  Snapshot select: SELECT gemeente_.Id, gemeente_.Naam as Naam5_, gemeente_.Postcode as Postcode5_ FROM Gemeente gemeente_ WHERE gemeente_.Id=?
2009-08-24 23:06:33,944 DEBUG  Insert 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG  Update 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG  Delete 0: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG  Identity insert: NHibernate.SqlCommand.SqlCommandInfo
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Gemeente: SELECT gemeente0_.Id as Id5_0_, gemeente0_.Naam as Naam5_0_, gemeente0_.Postcode as Postcode5_0_ FROM Gemeente gemeente0_ WHERE gemeente0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Gemeente: SELECT gemeente0_.Id as Id5_0_, gemeente0_.Naam as Naam5_0_, gemeente0_.Postcode as Postcode5_0_ FROM Gemeente gemeente0_ WHERE gemeente0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Gemeente: SELECT gemeente0_.Id as Id5_0_, gemeente0_.Naam as Naam5_0_, gemeente0_.Postcode as Postcode5_0_ FROM Gemeente gemeente0_ with (updlock, rowlock) WHERE gemeente0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Gemeente: SELECT gemeente0_.Id as Id5_0_, gemeente0_.Naam as Naam5_0_, gemeente0_.Postcode as Postcode5_0_ FROM Gemeente gemeente0_ with (updlock, rowlock) WHERE gemeente0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for entity XManager.Business.Gemeente: SELECT gemeente0_.Id as Id5_0_, gemeente0_.Naam as Naam5_0_, gemeente0_.Postcode as Postcode5_0_ FROM Gemeente gemeente0_ with (updlock, rowlock) WHERE gemeente0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for action NHibernate.Engine.CascadingAction+MergeCascadingAction on entity XManager.Business.Gemeente: SELECT gemeente0_.Id as Id5_0_, gemeente0_.Naam as Naam5_0_, gemeente0_.Postcode as Postcode5_0_ FROM Gemeente gemeente0_ WHERE gemeente0_.Id=?
2009-08-24 23:06:33,944 DEBUG Static select for action NHibernate.Engine.CascadingAction+RefreshCascadingAction on entity XManager.Business.Gemeente: SELECT gemeente0_.Id as Id5_0_, gemeente0_.Naam as Naam5_0_, gemeente0_.Postcode as Postcode5_0_ FROM Gemeente gemeente0_ WHERE gemeente0_.Id=?
2009-08-24 23:06:33,991 DEBUG Static select for collection XManager.Business.Afspraak.Behandelingen: SELECT behandelin0_.AfspraakId as AfspraakId2_, behandelin0_.BehandelingId as Behandel2_2_, behandelin1_.Id as Id4_0_, behandelin1_.Naam as Naam4_0_, behandelin1_.Omschrijving as Omschrij3_4_0_, behandelin1_.Duur as Duur4_0_, behandelin1_.Prijs as Prijs4_0_, behandelin1_.ToevoegDatumTijd as ToevoegD6_4_0_, behandelin1_.WijzigDatumTijd as WijzigDa7_4_0_, behandelin1_.CategorieId as Categori8_4_0_, categorie2_.Id as Id2_1_, categorie2_.Naam as Naam2_1_, categorie2_.Omschrijving as Omschrij3_2_1_ FROM AfspraakBehandelingen behandelin0_ left outer join Behandeling behandelin1_ on behandelin0_.BehandelingId=behandelin1_.Id left outer join Categorie categorie2_ on behandelin1_.CategorieId=categorie2_.Id WHERE behandelin0_.AfspraakId=?
2009-08-24 23:06:33,991 DEBUG initializing class SessionFactoryObjectFactory
2009-08-24 23:06:33,991 DEBUG registered: 08d6bee47df74fb68ffa91f89cffe51d(unnamed)
2009-08-24 23:06:33,991 INFO no name configured
2009-08-24 23:06:33,991 DEBUG Instantiated session factory
2009-08-24 23:06:34,006 DEBUG Checking 0 named HQL queries
2009-08-24 23:06:34,006 DEBUG Checking 0 named SQL queries
2009-08-24 23:06:34,100 DEBUG opened session at timestamp: 5124731674779648
2009-08-24 23:06:34,397 DEBUG loading entity: [XManager.Business.Klant#1]
2009-08-24 23:06:34,397 DEBUG attempting to resolve: [XManager.Business.Klant#1]
2009-08-24 23:06:34,413 DEBUG object not resolved in any cache: [XManager.Business.Klant#1]
2009-08-24 23:06:34,413 DEBUG Fetching entity: [XManager.Business.Klant#1]
2009-08-24 23:06:34,413 DEBUG loading entity: [XManager.Business.Klant#1]
2009-08-24 23:06:34,459 DEBUG Opened new IDbCommand, open IDbCommands: 1
2009-08-24 23:06:34,459 DEBUG Building an IDbCommand object for the SqlString: SELECT klant0_.Id as Id3_1_, klant0_.Voornaam as Voornaam3_1_, klant0_.Achternaam as Achternaam3_1_, klant0_.Adres as Adres3_1_, klant0_.Telefoon as Telefoon3_1_, klant0_.Gsm as Gsm3_1_, klant0_.Fax as Fax3_1_, klant0_.Email as Email3_1_, klant0_.Beroep as Beroep3_1_, klant0_.GeboorteDatum as Geboort10_3_1_, klant0_.RijksregisterNummer as Rijksre11_3_1_, klant0_.ToevoegDatumTijd as Toevoeg12_3_1_, klant0_.WijzigDatumTijd as WijzigD13_3_1_, klant0_.GemeenteId as GemeenteId3_1_, gemeente1_.Id as Id5_0_, gemeente1_.Naam as Naam5_0_, gemeente1_.Postcode as Postcode5_0_ FROM Klant klant0_ left outer join Gemeente gemeente1_ on klant0_.GemeenteId=gemeente1_.Id WHERE klant0_.Id=?
2009-08-24 23:06:34,459 DEBUG binding '1' to parameter: 0
2009-08-24 23:06:34,475 INFO SELECT klant0_.Id as Id3_1_, klant0_.Voornaam as Voornaam3_1_, klant0_.Achternaam as Achternaam3_1_, klant0_.Adres as Adres3_1_, klant0_.Telefoon as Telefoon3_1_, klant0_.Gsm as Gsm3_1_, klant0_.Fax as Fax3_1_, klant0_.Email as Email3_1_, klant0_.Beroep as Beroep3_1_, klant0_.GeboorteDatum as Geboort10_3_1_, klant0_.RijksregisterNummer as Rijksre11_3_1_, klant0_.ToevoegDatumTijd as Toevoeg12_3_1_, klant0_.WijzigDatumTijd as WijzigD13_3_1_, klant0_.GemeenteId as GemeenteId3_1_, gemeente1_.Id as Id5_0_, gemeente1_.Naam as Naam5_0_, gemeente1_.Postcode as Postcode5_0_ FROM Klant klant0_ left outer join Gemeente gemeente1_ on klant0_.GemeenteId=gemeente1_.Id WHERE klant0_.Id=@p0
2009-08-24 23:06:34,475 DEBUG SELECT klant0_.Id as Id3_1_, klant0_.Voornaam as Voornaam3_1_, klant0_.Achternaam as Achternaam3_1_, klant0_.Adres as Adres3_1_, klant0_.Telefoon as Telefoon3_1_, klant0_.Gsm as Gsm3_1_, klant0_.Fax as Fax3_1_, klant0_.Email as Email3_1_, klant0_.Beroep as Beroep3_1_, klant0_.GeboorteDatum as Geboort10_3_1_, klant0_.RijksregisterNummer as Rijksre11_3_1_, klant0_.ToevoegDatumTijd as Toevoeg12_3_1_, klant0_.WijzigDatumTijd as WijzigD13_3_1_, klant0_.GemeenteId as GemeenteId3_1_, gemeente1_.Id as Id5_0_, gemeente1_.Naam as Naam5_0_, gemeente1_.Postcode as Postcode5_0_ FROM Klant klant0_ left outer join Gemeente gemeente1_ on klant0_.GemeenteId=gemeente1_.Id WHERE klant0_.Id=@p0; @p0 = '1'
2009-08-24 23:06:34,491 DEBUG Obtaining IDbConnection from Driver
2009-08-24 23:06:34,663 DEBUG Opened IDataReader, open IDataReaders: 1
2009-08-24 23:06:34,678 DEBUG processing result set
2009-08-24 23:06:34,678 DEBUG result set row: 0
2009-08-24 23:06:34,678 DEBUG returning '1' as column: Id5_0_
2009-08-24 23:06:34,694 DEBUG result row: EntityKey[XManager.Business.Gemeente#1], EntityKey[XManager.Business.Klant#1]
2009-08-24 23:06:34,694 DEBUG Initializing object from DataReader: [XManager.Business.Gemeente#1]
2009-08-24 23:06:34,725 DEBUG Hydrating entity: [XManager.Business.Gemeente#1]
2009-08-24 23:06:34,725 DEBUG returning 'Hasselt' as column: Naam5_0_
2009-08-24 23:06:34,725 DEBUG returning '3500' as column: Postcode5_0_
2009-08-24 23:06:34,725 DEBUG Initializing object from DataReader: [XManager.Business.Klant#1]
2009-08-24 23:06:34,725 DEBUG Hydrating entity: [XManager.Business.Klant#1]
xxxxxxxxxxxxxxxxxxxxxxxx
2009-08-24 23:06:34,741 DEBUG done processing result set (1 rows)
2009-08-24 23:06:34,741 DEBUG running NHybridDataReader.Dispose()
2009-08-24 23:06:34,741 DEBUG Closed IDataReader, open IDataReaders :0
2009-08-24 23:06:34,741 DEBUG Closed IDbCommand, open IDbCommands: 0
2009-08-24 23:06:34,741 DEBUG aggressively releasing database connection
2009-08-24 23:06:34,741 DEBUG Closing connection
2009-08-24 23:06:34,756 DEBUG total objects hydrated: 2
2009-08-24 23:06:34,756 DEBUG resolving associations for [XManager.Business.Gemeente#1]
2009-08-24 23:06:34,772 DEBUG done materializing entity [XManager.Business.Gemeente#1]
2009-08-24 23:06:34,772 DEBUG resolving associations for [XManager.Business.Klant#1]
2009-08-24 23:06:34,772 DEBUG loading entity: [XManager.Business.Gemeente#1]
2009-08-24 23:06:34,772 DEBUG attempting to resolve: [XManager.Business.Gemeente#1]
2009-08-24 23:06:34,788 DEBUG resolved object in session cache: [XManager.Business.Gemeente#1]
2009-08-24 23:06:34,788 DEBUG done materializing entity [XManager.Business.Klant#1]
2009-08-24 23:06:34,788 DEBUG initializing non-lazy collections
2009-08-24 23:06:34,788 DEBUG done entity load
2009-08-24 23:06:34,788 DEBUG after autocommit
2009-08-24 23:06:34,788 DEBUG transaction completion
2009-08-24 23:06:34,803 DEBUG aggressively releasing database connection
2009-08-24 23:06:37,803 DEBUG Opened new IDbCommand, open IDbCommands: 1
2009-08-24 23:06:37,803 DEBUG Building an IDbCommand object for the SqlString: SELECT this_.Id as Id5_0_, this_.Naam as Naam5_0_, this_.Postcode as Postcode5_0_ FROM Gemeente this_
2009-08-24 23:06:37,819 INFO SELECT this_.Id as Id5_0_, this_.Naam as Naam5_0_, this_.Postcode as Postcode5_0_ FROM Gemeente this_
2009-08-24 23:06:37,819 DEBUG SELECT this_.Id as Id5_0_, this_.Naam as Naam5_0_, this_.Postcode as Postcode5_0_ FROM Gemeente this_
2009-08-24 23:06:37,819 DEBUG Obtaining IDbConnection from Driver
2009-08-24 23:06:37,819 DEBUG Opened IDataReader, open IDataReaders: 1
2009-08-24 23:06:37,819 DEBUG processing result set
2009-08-24 23:06:37,819 DEBUG result set row: 0
2009-08-24 23:06:37,819 DEBUG returning '1' as column: Id5_0_
2009-08-24 23:06:37,819 DEBUG result row: EntityKey[XManager.Business.Gemeente#1]
2009-08-24 23:06:37,819 DEBUG done processing result set (1 rows)
2009-08-24 23:06:37,819 DEBUG running NHybridDataReader.Dispose()
2009-08-24 23:06:37,819 DEBUG Closed IDataReader, open IDataReaders :0
2009-08-24 23:06:37,819 DEBUG Closed IDbCommand, open IDbCommands: 0
2009-08-24 23:06:37,819 DEBUG aggressively releasing database connection
2009-08-24 23:06:37,819 DEBUG Closing connection
2009-08-24 23:06:37,819 DEBUG total objects hydrated: 0
2009-08-24 23:06:37,819 DEBUG initializing non-lazy collections
2009-08-24 23:06:37,819 DEBUG after autocommit
2009-08-24 23:06:37,819 DEBUG transaction completion
2009-08-24 23:06:37,819 DEBUG aggressively releasing database connection
2009-08-24 23:06:37,834 DEBUG Opened new IDbCommand, open IDbCommands: 1
2009-08-24 23:06:37,834 DEBUG Building an IDbCommand object for the SqlString: SELECT this_.Id as Id5_0_, this_.Naam as Naam5_0_, this_.Postcode as Postcode5_0_ FROM Gemeente this_
2009-08-24 23:06:37,834 INFO SELECT this_.Id as Id5_0_, this_.Naam as Naam5_0_, this_.Postcode as Postcode5_0_ FROM Gemeente this_
2009-08-24 23:06:37,834 DEBUG SELECT this_.Id as Id5_0_, this_.Naam as Naam5_0_, this_.Postcode as Postcode5_0_ FROM Gemeente this_
2009-08-24 23:06:37,834 DEBUG Obtaining IDbConnection from Driver
2009-08-24 23:06:37,834 DEBUG Opened IDataReader, open IDataReaders: 1
2009-08-24 23:06:37,834 DEBUG processing result set
2009-08-24 23:06:37,834 DEBUG result set row: 0
2009-08-24 23:06:37,834 DEBUG returning '1' as column: Id5_0_
2009-08-24 23:06:37,834 DEBUG result row: EntityKey[XManager.Business.Gemeente#1]
2009-08-24 23:06:37,834 DEBUG done processing result set (1 rows)
2009-08-24 23:06:37,834 DEBUG running NHybridDataReader.Dispose()
2009-08-24 23:06:37,834 DEBUG Closed IDataReader, open IDataReaders :0
2009-08-24 23:06:37,834 DEBUG Closed IDbCommand, open IDbCommands: 0
2009-08-24 23:06:37,834 DEBUG aggressively releasing database connection
2009-08-24 23:06:37,834 DEBUG Closing connection
2009-08-24 23:06:37,834 DEBUG total objects hydrated: 0
2009-08-24 23:06:37,834 DEBUG initializing non-lazy collections
2009-08-24 23:06:37,834 DEBUG after autocommit
2009-08-24 23:06:37,834 DEBUG transaction completion
2009-08-24 23:06:37,834 DEBUG aggressively releasing database connection
2009-08-24 23:06:38,725 DEBUG Opened new IDbCommand, open IDbCommands: 1
2009-08-24 23:06:38,725 DEBUG Building an IDbCommand object for the SqlString: SELECT this_.Id as Id3_1_, this_.Voornaam as Voornaam3_1_, this_.Achternaam as Achternaam3_1_, this_.Adres as Adres3_1_, this_.Telefoon as Telefoon3_1_, this_.Gsm as Gsm3_1_, this_.Fax as Fax3_1_, this_.Email as Email3_1_, this_.Beroep as Beroep3_1_, this_.GeboorteDatum as Geboort10_3_1_, this_.RijksregisterNummer as Rijksre11_3_1_, this_.ToevoegDatumTijd as Toevoeg12_3_1_, this_.WijzigDatumTijd as WijzigD13_3_1_, this_.GemeenteId as GemeenteId3_1_, gemeente2_.Id as Id5_0_, gemeente2_.Naam as Naam5_0_, gemeente2_.Postcode as Postcode5_0_ FROM Klant this_ left outer join Gemeente gemeente2_ on this_.GemeenteId=gemeente2_.Id
2009-08-24 23:06:38,725 INFO SELECT this_.Id as Id3_1_, this_.Voornaam as Voornaam3_1_, this_.Achternaam as Achternaam3_1_, this_.Adres as Adres3_1_, this_.Telefoon as Telefoon3_1_, this_.Gsm as Gsm3_1_, this_.Fax as Fax3_1_, this_.Email as Email3_1_, this_.Beroep as Beroep3_1_, this_.GeboorteDatum as Geboort10_3_1_, this_.RijksregisterNummer as Rijksre11_3_1_, this_.ToevoegDatumTijd as Toevoeg12_3_1_, this_.WijzigDatumTijd as WijzigD13_3_1_, this_.GemeenteId as GemeenteId3_1_, gemeente2_.Id as Id5_0_, gemeente2_.Naam as Naam5_0_, gemeente2_.Postcode as Postcode5_0_ FROM Klant this_ left outer join Gemeente gemeente2_ on this_.GemeenteId=gemeente2_.Id
2009-08-24 23:06:38,725 DEBUG SELECT this_.Id as Id3_1_, this_.Voornaam as Voornaam3_1_, this_.Achternaam as Achternaam3_1_, this_.Adres as Adres3_1_, this_.Telefoon as Telefoon3_1_, this_.Gsm as Gsm3_1_, this_.Fax as Fax3_1_, this_.Email as Email3_1_, this_.Beroep as Beroep3_1_, this_.GeboorteDatum as Geboort10_3_1_, this_.RijksregisterNummer as Rijksre11_3_1_, this_.ToevoegDatumTijd as Toevoeg12_3_1_, this_.WijzigDatumTijd as WijzigD13_3_1_, this_.GemeenteId as GemeenteId3_1_, gemeente2_.Id as Id5_0_, gemeente2_.Naam as Naam5_0_, gemeente2_.Postcode as Postcode5_0_ FROM Klant this_ left outer join Gemeente gemeente2_ on this_.GemeenteId=gemeente2_.Id
2009-08-24 23:06:38,725 DEBUG Obtaining IDbConnection from Driver
2009-08-24 23:06:38,725 DEBUG Opened IDataReader, open IDataReaders: 1
2009-08-24 23:06:38,725 DEBUG processing result set
2009-08-24 23:06:38,725 DEBUG result set row: 0
2009-08-24 23:06:38,725 DEBUG returning '1' as column: Id5_0_
2009-08-24 23:06:38,725 DEBUG returning '1' as column: Id3_1_
2009-08-24 23:06:38,725 DEBUG result row: EntityKey[XManager.Business.Gemeente#1], EntityKey[XManager.Business.Klant#1]
2009-08-24 23:06:38,725 DEBUG result set row: 1
2009-08-24 23:06:38,725 DEBUG returning '1' as column: Id5_0_
2009-08-24 23:06:38,725 DEBUG returning '2' as column: Id3_1_
2009-08-24 23:06:38,725 DEBUG result row: EntityKey[XManager.Business.Gemeente#1], EntityKey[XManager.Business.Klant#2]
2009-08-24 23:06:38,725 DEBUG Initializing object from DataReader: [XManager.Business.Klant#2]
2009-08-24 23:06:38,725 DEBUG Hydrating entity: [XManager.Business.Klant#2]
xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
2009-08-24 23:06:38,725 DEBUG result set row: 2
2009-08-24 23:06:38,725 DEBUG returning '1' as column: Id5_0_
2009-08-24 23:06:38,725 DEBUG returning '3' as column: Id3_1_
2009-08-24 23:06:38,725 DEBUG result row: EntityKey[XManager.Business.Gemeente#1], EntityKey[XManager.Business.Klant#3]
2009-08-24 23:06:38,725 DEBUG Initializing object from DataReader: [XManager.Business.Klant#3]
2009-08-24 23:06:38,725 DEBUG Hydrating entity: [XManager.Business.Klant#3]
2009-08-24 23:06:38,725 DEBUG returning 'Piet' as column: Voornaam3_1_
2009-08-24 23:06:38,725 DEBUG returning 'Fransen' as column: Achternaam3_1_
2009-08-24 23:06:38,725 DEBUG returning 'Vlinderlaan 8' as column: Adres3_1_
2009-08-24 23:06:38,725 DEBUG returning '' as column: Telefoon3_1_
2009-08-24 23:06:38,725 DEBUG returning null as column: Gsm3_1_
2009-08-24 23:06:38,725 DEBUG returning '' as column: Fax3_1_
2009-08-24 23:06:38,725 DEBUG returning '' as column: Email3_1_
2009-08-24 23:06:38,725 DEBUG returning 'Bakker' as column: Beroep3_1_
2009-08-24 23:06:38,725 DEBUG returning '19/08/1975' as column: Geboort10_3_1_
2009-08-24 23:06:38,725 DEBUG returning '1245681' as column: Rijksre11_3_1_
2009-08-24 23:06:38,725 DEBUG returning '15/08/2009' as column: Toevoeg12_3_1_
2009-08-24 23:06:38,725 DEBUG returning null as column: WijzigD13_3_1_
2009-08-24 23:06:38,725 DEBUG returning '1' as column: GemeenteId3_1_
2009-08-24 23:06:38,725 DEBUG done processing result set (3 rows)
2009-08-24 23:06:38,725 DEBUG running NHybridDataReader.Dispose()
2009-08-24 23:06:38,725 DEBUG Closed IDataReader, open IDataReaders :0
2009-08-24 23:06:38,725 DEBUG Closed IDbCommand, open IDbCommands: 0
2009-08-24 23:06:38,725 DEBUG aggressively releasing database connection
2009-08-24 23:06:38,725 DEBUG Closing connection
2009-08-24 23:06:38,725 DEBUG total objects hydrated: 2
2009-08-24 23:06:38,725 DEBUG resolving associations for [XManager.Business.Klant#2]
2009-08-24 23:06:38,725 DEBUG loading entity: [XManager.Business.Gemeente#1]
2009-08-24 23:06:38,725 DEBUG attempting to resolve: [XManager.Business.Gemeente#1]
2009-08-24 23:06:38,725 DEBUG resolved object in session cache: [XManager.Business.Gemeente#1]
2009-08-24 23:06:38,725 DEBUG done materializing entity [XManager.Business.Klant#2]
2009-08-24 23:06:38,725 DEBUG resolving associations for [XManager.Business.Klant#3]
2009-08-24 23:06:38,725 DEBUG loading entity: [XManager.Business.Gemeente#1]
2009-08-24 23:06:38,725 DEBUG attempting to resolve: [XManager.Business.Gemeente#1]
2009-08-24 23:06:38,725 DEBUG resolved object in session cache: [XManager.Business.Gemeente#1]
2009-08-24 23:06:38,725 DEBUG done materializing entity [XManager.Business.Klant#3]
2009-08-24 23:06:38,725 DEBUG initializing non-lazy collections
2009-08-24 23:06:38,725 DEBUG after autocommit
2009-08-24 23:06:38,725 DEBUG transaction completion
2009-08-24 23:06:38,725 DEBUG aggressively releasing database connection
2009-08-24 23:06:41,178 DEBUG loading entity: [XManager.Business.Klant#3]
2009-08-24 23:06:41,178 DEBUG attempting to resolve: [XManager.Business.Klant#3]
2009-08-24 23:06:41,178 DEBUG resolved object in session cache: [XManager.Business.Klant#3]
2009-08-24 23:06:41,178 DEBUG after autocommit
2009-08-24 23:06:41,178 DEBUG transaction completion
2009-08-24 23:06:41,178 DEBUG aggressively releasing database connection
2009-08-24 23:06:44,334 DEBUG Opened new IDbCommand, open IDbCommands: 1
2009-08-24 23:06:44,334 DEBUG Building an IDbCommand object for the SqlString: SELECT this_.Id as Id4_1_, this_.Naam as Naam4_1_, this_.Omschrijving as Omschrij3_4_1_, this_.Duur as Duur4_1_, this_.Prijs as Prijs4_1_, this_.ToevoegDatumTijd as ToevoegD6_4_1_, this_.WijzigDatumTijd as WijzigDa7_4_1_, this_.CategorieId as Categori8_4_1_, categorie2_.Id as Id2_0_, categorie2_.Naam as Naam2_0_, categorie2_.Omschrijving as Omschrij3_2_0_ FROM Behandeling this_ left outer join Categorie categorie2_ on this_.CategorieId=categorie2_.Id
2009-08-24 23:06:44,334 INFO SELECT this_.Id as Id4_1_, this_.Naam as Naam4_1_, this_.Omschrijving as Omschrij3_4_1_, this_.Duur as Duur4_1_, this_.Prijs as Prijs4_1_, this_.ToevoegDatumTijd as ToevoegD6_4_1_, this_.WijzigDatumTijd as WijzigDa7_4_1_, this_.CategorieId as Categori8_4_1_, categorie2_.Id as Id2_0_, categorie2_.Naam as Naam2_0_, categorie2_.Omschrijving as Omschrij3_2_0_ FROM Behandeling this_ left outer join Categorie categorie2_ on this_.CategorieId=categorie2_.Id
2009-08-24 23:06:44,334 DEBUG SELECT this_.Id as Id4_1_, this_.Naam as Naam4_1_, this_.Omschrijving as Omschrij3_4_1_, this_.Duur as Duur4_1_, this_.Prijs as Prijs4_1_, this_.ToevoegDatumTijd as ToevoegD6_4_1_, this_.WijzigDatumTijd as WijzigDa7_4_1_, this_.CategorieId as Categori8_4_1_, categorie2_.Id as Id2_0_, categorie2_.Naam as Naam2_0_, categorie2_.Omschrijving as Omschrij3_2_0_ FROM Behandeling this_ left outer join Categorie categorie2_ on this_.CategorieId=categorie2_.Id
2009-08-24 23:06:44,334 DEBUG Obtaining IDbConnection from Driver
2009-08-24 23:06:44,334 DEBUG Opened IDataReader, open IDataReaders: 1
2009-08-24 23:06:44,334 DEBUG processing result set
2009-08-24 23:06:44,334 DEBUG result set row: 0
2009-08-24 23:06:44,334 DEBUG returning '2' as column: Id2_0_
2009-08-24 23:06:44,334 DEBUG returning '1' as column: Id4_1_
2009-08-24 23:06:44,334 DEBUG result row: EntityKey[XManager.Business.Categorie#2], EntityKey[XManager.Business.Behandeling#1]
2009-08-24 23:06:44,334 DEBUG Initializing object from DataReader: [XManager.Business.Categorie#2]
2009-08-24 23:06:44,334 DEBUG Hydrating entity: [XManager.Business.Categorie#2]
2009-08-24 23:06:44,334 DEBUG returning 'Voetverzorging' as column: Naam2_0_
2009-08-24 23:06:44,334 DEBUG returning null as column: Omschrij3_2_0_
2009-08-24 23:06:44,334 DEBUG Initializing object from DataReader: [XManager.Business.Behandeling#1]
2009-08-24 23:06:44,334 DEBUG Hydrating entity: [XManager.Business.Behandeling#1]
2009-08-24 23:06:44,334 DEBUG returning 'Voetverzorging' as column: Naam4_1_
2009-08-24 23:06:44,334 DEBUG returning '' as column: Omschrij3_4_1_
2009-08-24 23:06:44,334 DEBUG returning '30' as column: Duur4_1_
2009-08-24 23:06:44,334 DEBUG returning '18' as column: Prijs4_1_
2009-08-24 23:06:44,334 DEBUG returning '19/08/2009' as column: ToevoegD6_4_1_
2009-08-24 23:06:44,334 DEBUG returning null as column: WijzigDa7_4_1_
2009-08-24 23:06:44,334 DEBUG returning '2' as column: Categori8_4_1_
2009-08-24 23:06:44,334 DEBUG done processing result set (1 rows)
2009-08-24 23:06:44,334 DEBUG running NHybridDataReader.Dispose()
2009-08-24 23:06:44,334 DEBUG Closed IDataReader, open IDataReaders :0
2009-08-24 23:06:44,334 DEBUG Closed IDbCommand, open IDbCommands: 0
2009-08-24 23:06:44,334 DEBUG aggressively releasing database connection
2009-08-24 23:06:44,334 DEBUG Closing connection
2009-08-24 23:06:44,334 DEBUG total objects hydrated: 2
2009-08-24 23:06:44,334 DEBUG resolving associations for [XManager.Business.Categorie#2]
2009-08-24 23:06:44,334 DEBUG done materializing entity [XManager.Business.Categorie#2]
2009-08-24 23:06:44,334 DEBUG resolving associations for [XManager.Business.Behandeling#1]
2009-08-24 23:06:44,334 DEBUG loading entity: [XManager.Business.Categorie#2]
2009-08-24 23:06:44,334 DEBUG attempting to resolve: [XManager.Business.Categorie#2]
2009-08-24 23:06:44,334 DEBUG resolved object in session cache: [XManager.Business.Categorie#2]
2009-08-24 23:06:44,350 DEBUG done materializing entity [XManager.Business.Behandeling#1]
2009-08-24 23:06:44,350 DEBUG initializing non-lazy collections
2009-08-24 23:06:44,350 DEBUG after autocommit
2009-08-24 23:06:44,350 DEBUG transaction completion
2009-08-24 23:06:44,350 DEBUG aggressively releasing database connection
2009-08-24 23:06:45,663 DEBUG loading entity: [XManager.Business.Behandeling#1]
2009-08-24 23:06:45,663 DEBUG attempting to resolve: [XManager.Business.Behandeling#1]
2009-08-24 23:06:45,663 DEBUG resolved object in session cache: [XManager.Business.Behandeling#1]
2009-08-24 23:06:45,663 DEBUG after autocommit
2009-08-24 23:06:45,663 DEBUG transaction completion
2009-08-24 23:06:45,663 DEBUG aggressively releasing database connection
2009-08-24 23:07:02,585 DEBUG saving transient instance
2009-08-24 23:07:02,600 DEBUG saving [XManager.Business.Afspraak#<null>]
2009-08-24 23:07:02,616 DEBUG executing insertions
2009-08-24 23:07:02,647 DEBUG Wrapped collection in role: XManager.Business.Afspraak.Behandelingen
2009-08-24 23:07:02,663 DEBUG executing identity-insert immediately
2009-08-24 23:07:02,678 DEBUG Inserting entity: XManager.Business.Afspraak (native id)
2009-08-24 23:07:02,678 DEBUG Opened new IDbCommand, open IDbCommands: 1
2009-08-24 23:07:02,678 DEBUG Building an IDbCommand object for the SqlString: INSERT INTO Afspraak (StartDatum, EindDatum, Herhalend, HerhaalInterval, Opmerking, Status, ToevoegDatumTijd, WijzigDatumTijd, KlantId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPE_IDENTITY()
2009-08-24 23:07:02,678 DEBUG Dehydrating entity: [XManager.Business.Afspraak#<null>]
2009-08-24 23:07:02,678 DEBUG binding '24/08/2009' to parameter: 0
2009-08-24 23:07:02,678 DEBUG binding '24/08/2009' to parameter: 1
2009-08-24 23:07:02,678 DEBUG binding 'False' to parameter: 2
2009-08-24 23:07:02,678 DEBUG binding '0' to parameter: 3
2009-08-24 23:07:02,678 DEBUG binding '' to parameter: 4
2009-08-24 23:07:02,678 DEBUG binding '0' to parameter: 5
2009-08-24 23:07:02,678 DEBUG binding '24/08/2009' to parameter: 6
2009-08-24 23:07:02,678 DEBUG binding null to parameter: 7
2009-08-24 23:07:02,694 DEBUG binding '3' to parameter: 8
2009-08-24 23:07:02,694 DEBUG INSERT INTO Afspraak (StartDatum, EindDatum, Herhalend, HerhaalInterval, Opmerking, Status, ToevoegDatumTijd, WijzigDatumTijd, KlantId) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8); select SCOPE_IDENTITY(); @p0 = '24/08/2009 23:06:36', @p1 = '24/08/2009 23:36:36', @p2 = 'False', @p3 = '0', @p4 = '', @p5 = '0', @p6 = '24/08/2009 23:07:02', @p7 = '', @p8 = '3'
2009-08-24 23:07:02,694 DEBUG Obtaining IDbConnection from Driver
2009-08-24 23:07:02,694 DEBUG Opened IDataReader, open IDataReaders: 1
2009-08-24 23:07:02,694 DEBUG returning '12' as column:
2009-08-24 23:07:02,694 DEBUG Natively generated identity: 12
2009-08-24 23:07:02,694 DEBUG running NHybridDataReader.Dispose()
2009-08-24 23:07:02,694 DEBUG Closed IDataReader, open IDataReaders :0
2009-08-24 23:07:02,694 DEBUG Closed IDbCommand, open IDbCommands: 0
2009-08-24 23:07:02,694 DEBUG aggressively releasing database connection
2009-08-24 23:07:02,694 DEBUG Closing connection