NHibernate Growth Generator - Failed to Get Initial Value

Question

I am trying to use NHibernate (and FluentNHibernate ) on top of an obsolete database. I also use SQLite for tests .

When I try to create a test for mappings using FluentNHibernate PersistenceSpecification , I get the following exception:

NHibernate.Exceptions.GenericADOException: Failed to get initial value for increment generator

I map my id as follows:

Id(f => f.ID, "OID").GeneratedBy.Increment(); 

My test uses SQLite, so when I ran them, the tables were initially empty.

Does anyone have any ideas how to solve this?

Thanks.

Answer 1

You can also try:

 Id(f => f.ID, "OID").GeneratedBy.Native() 

This works for me in SQLite and SQL Server.

Answer 2

Have you tried using GeneratedBy.Identity instead of GeneratedBy.Increment?

Answer 3

You can try using seqhilo depending on your database system.