I don't quite understand the problem being described as it pertains to SQLite or
System.Data.SQLite.

Perhaps you could post the portion of the schema and/or C# code that demonstrates
the problem?