Nhibernate Mapping by Code conventions to Postgres Sequence

Question

I´m using PostGres 8.3 and have NHibernate working fine with database... I´m creating a Conventions file and I´m having problem to configure the Primary key sequence... All my tables have a primary key called ID, so I did that :

...
mapper.BeforeMapClass += (modelInspector, type, classCustomizer) => {
            classCustomizer.Id(c => c.Column("ID"));
            classCustomizer.Id(c => c.Generator(Generators.Sequence));
};

When I try to Save a instance, I got that error:

ERROR: 42P01: relation "hibernate_sequence" does not exist

How Can I create a convention to that?

Thanks

Community · Accepted Answer · 2017-05-23 11:43:15Z

1

have a look at How to properly use NHibernate By Code to get the next Sequence in Oracle?

Id(u => u.Id, map =>
            {
                map.Column("id");
                map.Generator(Generators.Sequence,
                              gmap => gmap.Params(new {sequence = "seq_name"}));
            });

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered May 24, 2013 at 8:42

Leaf

263 bronze badges

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

Collectives™ on Stack Overflow

Nhibernate Mapping by Code conventions to Postgres Sequence

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related