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.

Accepted Answer

You can also try:

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

This works for me in SQLite & SQL Server.

NHibernate's Increment Generator - could not fetch initial value

Solution

Problem