Auto Increment in FLuent Nhibernate and PostgreSQL

[Rivera]

Hai, I`m Newbie in Fluent Nhibernate.. I have postgreSql Database and what i want is generated id with auto increment.. i have no see feature auto increment in Postgres and i was understand that for use auto increment in postgreSql i must create sequence..

there is other way beside sequence?

if create sequence is the only way, can You tell me how I mapping it? I was tried use this and not success :

mapping.Id(x => x.Id, "id").GeneratedBy.Sequence("hibernate-sequence");

i was created hibernate-sequence before

Regards

[Yann ROBIN]

Hi,

PostgreSQL have "serial" types that create the sequence and set the
default value field to the sequence.
So if you use this feature, you only need to set GeneratedBy.Identity()

--
Yann

[Oskar Berggren]

Though you should also be aware of the consequences of letting the
database generate the id. See for example:
http://nhforge.org/blogs/nhibernate/archive/2009/03/20/nhibernate-poid-generators-revealed.aspx

/Oskar

2010/10/7 Yann ROBIN <me....@gmail.com>:

> --
> You received this message because you are subscribed to the Google Groups "Fluent NHibernate" group.
> To post to this group, send email to fluent-n...@googlegroups.com.
> To unsubscribe from this group, send email to fluent-nhibern...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/fluent-nhibernate?hl=en.
>
>