public void HasForeignKeyErrors() { using (var ds = new SQLiteDatastore()) { ds.Execute("PRAGMA foreign_keys = off;"); ds.Execute("Create table TableA (ID INTEGER PRIMARY KEY);"); ds.Execute("CREATE TABLE TABLEB (ID_B REFERENCES TABLEA (ID));"); ds.Execute("INSERT INTO TABLEA ([ID]) VALUES (1);"); ds.Execute("INSERT INTO TABLEB VALUES (1);"); Assert.False(ds.HasForeignKeyErrors("TableB")); ds.Execute("INSERT INTO TABLEB VALUES (2);"); Assert.True(ds.HasForeignKeyErrors("TableB")); } }