Sequence generator in Nhibernate (c#)

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

SEQ_DEPT_ID

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

Please help . thanks in advance.