Mapping entities for Sql Server Identity and Oracle Sequence with NHibernate

Question

I have a application that uses C# and NHibernate and it will support SQL Server 2008, SQL Server 2012 and Oracle. I have been using fluent nhibernate to map my entities and I have some questions about how should I map the ID. Oracle supports only the Sequence, SQL Server 2008 only identity and Sql Server 2012 both. I would like to map in Sql Server (2008 and 2012) with Identity and Oracle with Sequence on the same code.

How should I map the ID to work for all databases?

It does not matter if I will have some IF's statement on my fluent mapping code. Looks my codes for mapping:

For SQL:

Id(x => x.Id).GeneratedBy.Native();

For Oracle:

Id(x => x.Id).GeneratedBy.Sequence("SQ_Customer");

PS: I do not want any workaround to achieve it. I want a NHibernate/Fluent-NHibernate solution to map it.

Do you have to wait for database to give you the id, or can you generate your own using nhibernates HILO generator? — epitka
– epitka, Commented Jun 20, 2013 at 15:48
I was think using a Guid but unfortunately I can not change my database :( — Felipe Oriani
– Felipe Oriani, Commented Jun 20, 2013 at 16:52

DontVoteMeDown · Accepted Answer · 2013-06-24 13:02:42Z

8

+100

Well, "Native" chooses Identity, sequence or HILO automatically depending on the used DB.

Using this xml mapping it should use identity or the sequence sq_customer if its Oracle:

  <generator class="native" >
    <param name="sequence">sq_customer</param>
  </generator>

This post describes things further.

edited Jun 24, 2013 at 13:02

DontVoteMeDown

21.5k10 gold badges72 silver badges113 bronze badges

answered Jun 24, 2013 at 12:44

Tamim Al Manaseer

3,7543 gold badges27 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Rafał Rutkowski Over a year ago

It's the correct answer. Translated to Fluent: Id(x => x.Id).GeneratedBy.Native("SQ_Customer");

79E09796 Over a year ago

Id(x => x.Id).GeneratedBy.Increment() works without needing a sequence.

user2171669 Over a year ago

I was searching 2 days for solution in Java. No answers like that for Java. No info in doc. This "trick" helped me very much, worked perfectly for MS SQL Identity and Oracle SEQUENCE-TRIGGER. Thank you very much.

Tamim Al Manaseer Over a year ago

great I was of assistance, vote up the answer if you don't mind :)

Collectives™ on Stack Overflow

Mapping entities for Sql Server Identity and Oracle Sequence with NHibernate

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related