public SqlLiteFunctionTests() { dstore = SqlLiteDataConnection.GetDataStore(Path.GetTempFileName()); InitHelper.AttachEvents(dstore); List<DBObject> data = dstore.SchemaValidator.ViewValidator.GetObjects().Where(R => R.Name != "sqlite_sequence").ToList(); while (data.Count != 0) { foreach (DBObject t in data) { if (t.Name.Equals("sqlite_sequence")) continue; SQLiteCommand cmd = new SQLiteCommand(); cmd.CommandText = string.Format("DROP VIEW {0}", t.Name); try { dstore.ExecuteCommand(cmd); } catch { } } data = dstore.SchemaValidator.ViewValidator.GetObjects(true).Where(R => R.Name != "sqlite_sequence").ToList(); } data = dstore.SchemaValidator.TableValidator.GetObjects().Where(R => R.Name != "sqlite_sequence").ToList(); while (data.Count != 0) { foreach (DBObject t in data) { if (t.Name.Equals("sqlite_sequence")) continue; SQLiteCommand cmd = new SQLiteCommand(); cmd.CommandText = string.Format("DROP TABLE {0}", t.Name); try { dstore.ExecuteCommand(cmd); } catch { } } data = dstore.SchemaValidator.TableValidator.GetObjects(true).Where(R => R.Name != "sqlite_sequence").ToList(); } }