Enable referential integrity using nHIbernate using the SQlite database

Question

Good evening everyone,

I have a project using nHibernate (2.1.2.4000) and System.Data.SQLite (1.0.66.0). I want to force NHibernate to create foreign keys when creating the database, or at least use the keyword "foreign key", then I can create triggers.

I googled, but I did not find any documentation on how to do this, and I am losing faith. I really don't want (and will not) check referential integrity inside my code.

In a word: how to enable referential integrity (or equivalent) using nHibernate and SQLite?

Thanks in advance,

Answer 1

Better late than never: here is the answer:

Foreign keys with SchemaExport in Fluent NHibernate using SQLite

nHibernate Issue Tracker