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"));
}
}
