Hi,

I developed an Asp.net application with VS2005 + NHibernate 1.2 + Oracle 9.2, and i have a lot of mappings width a Sequence strategy (Oracle dialect) and everything is running OK until i receive a request to have more than one database: ORACLE and SQLServer2005.

How can i run my application with SQLServer database without change ALL my mappings to remove the SEQUENCE!???

Exists any way to maintain the same mapping with differents dialects!?


Someone can help me!?


Regards,

Tony Wolfango
Portugal

TonyW

I thought you could just set the mapping to generator class="native"
Which will use the native/default generator strategy for the dialect that you're using... which will be IDENTITY for SqlServer and SEQUENCE for Oracle (the latter I'm guessing will be the case)

eg
<id name="id"> <generator class="native"/> </id>