Hi All,

Heres the problem, we have two SQL servers with "Linked Server" references between them. We have NHibernate able to pull data from these tables and even build the mapped bags, lists, sets by joining between the tables.

We achieved this by adding a fully qualified name to our table name i.e

Table "Categories" on server 1 has an hbm mapping:



All is going well, untill we have to persist an object. At the point NHibernate persists an object to SQL using auto increment of the identity field is calls ''select SCOPE_IDENTITY()' to get the last identity value provided by sql e.g.



Thus we do not get the identity result back and NHibernate throws an exception. What can I do?

Cheers, Chris.

You can auto increment the ID column in the database itself and mark the id tag with the following element.

<generator class="native"/>

Hi lvelayutham,


Tried that with no joy.

Chris.

From what I read 'native' chooses the best algorithm based upon the underlying DB. Which in this case seems to be working the same was as 'identity'. The sql output is identical in any case.