Uses @@identity to get the Id value.
Namespace: NHibernate.DialectAssembly: NHibernate (in NHibernate.dll) Version: 3.2.0.4000 (3.2.0.4000)
Syntax
Remarks
There is a well known problem with @@identity and triggers that insert into
rows into other tables that also use an identity column. The only way I know
of to get around this problem is to upgrade your database server to Ms Sql 2000.