Sequence generator in Nhibernate (c#)

Question

Hi All,

 

I have a conversion project (from oracle to sql server) and using NHibernate to handle database operations. 

 

1. Saving is working when we Save entity  by using oracle . here for a column has sequence

2. But same if we do in SQL server it is not working as getting 'null Identifier' 

 

Query:

Insert into Dept(deptname, loc) values (@po,@p1) scope_identity, @p0='IT' , @p1='Hyd'

Exception: null Identifier.

 

dept.hbm.xml

 

<id name="id" column="deptid">

<generator class="identity">

<param name="sequence">SEQ_DEPT_ID</param>

</generator>

</id>

 

Note: we are using Instead of Insert triggers in SQL server. 

 

Please help . thanks in advance.