views:

816

answers:

3

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.

A: 

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

Josh
A: 

You can also try:

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

This works for me in SQLite & SQL Server.

JD Courtoy
A: 

You could try using seqhilo depending on your database system.

Chris