NHibernate's Increment Generator - could not fetch initial value

Question

I'm trying to use NHibernate (and FluentNHibernate) over a legacy database. I'm also using SQLite for tests.

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

NHibernate.Exceptions.GenericADOException : could not fetch initial value for increment generator

I'm mapping my ID like this:

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

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

Does someone have an idea how to solve this?

Thanks.

Answer 1

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

Answer 2

You can also try:

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

This works for me in SQLite & SQL Server.

Answer 3

You could try using seqhilo depending on your database system.