Hi all,
In my application I have a business entity mapped to a database view.
The database is sql server express edition and the view has one instead of trigger for insert associated to it.
Because the type of generator is Identity there is a problem with the value returned from the "Select Scope_Identity()" query execution. The value is null, probably because the context inside the trigger is different from the context of the nhibernate query.
How Can I solve this problem? Is possible to define a custom slq-insert with output param and use it for set the entity's ID ?


Thanks