Load data from XML to in-memory SQLite instance

gistfile1.cs

SQLiteConnection connection = boundSession.GetConnection();

using (var cmd = new SQLiteCommand("PRAGMA foreign_keys = OFF", connection))
{
    cmd.ExecuteNonQuery();
}

var sqlLiteUnitTest = new SqlLiteDbUnitTest(connection);

sqlLiteUnitTest.ReadXmlSchema(xsdFile);
sqlLiteUnitTest.ReadXml(xmlDataFile);
sqlLiteUnitTest.PerformDbOperation(DbOperationFlag.CleanInsertIdentity);

using (var cmd = new SQLiteCommand("PRAGMA foreign_keys = ON", (SQLiteConnection)connection))
{
    cmd.ExecuteNonQuery();
}

// In-memory SQLite instances are created per connection. Use same connection at unittest