Hi!

I'd like to program a little application with SQLite as Database and NHibernate as OR-Mapper.
I have some tables with foreign keys and i'm not sure if it is possible to do this with NHibernate and SQLite because SQLite doesn't support foreign keys by default. But I found some information in the internet that it is possible to do something like that with triggers. But now my question:
Because I don't have "real" foreign keys is it even possible to do correct mapping with NHibernate between different tables.
My code looks for example like this:

So I think I should have "real" foreign keys. But that's not possible with SQLite...
My current error message: NHibernate.MappingException : could not instantiate id generator: foreign

Regards