public void UpdateTestRun() { var queries = Helpers.GetQueries(Properties.Resources.UpdateTestQueries); Assert.AreEqual(6, queries.Length); using (var connection = Helpers.GetJetConnection()) { connection.Open(); DbDataReader reader; for (int index = 0; index < queries.Length - 2; index++) { string query = queries[index]; reader = Helpers.Execute(connection, query); if (reader != null) { reader.Dispose(); } } reader = Helpers.Execute(connection, queries[4]); reader.Read(); Assert.AreEqual(1, reader.GetInt32(0)); reader.Dispose(); Helpers.Execute(connection, queries[5]); } }
public void UpdateTestWithTransactionsRun() { JetConfiguration.ShowSqlStatements = true; var queries = Helpers.GetQueries(Properties.Resources.UpdateTestQueries); Assert.AreEqual(6, queries.Length); using (var connection = Helpers.GetJetConnection()) { connection.Open(); DbDataReader reader; for (int index = 0; index < queries.Length - 2; index++) { DbTransaction transaction = connection.BeginTransaction(); string query = queries[index]; reader = Helpers.Execute(connection, transaction, query); if (reader != null) { reader.Dispose(); } transaction.Commit(); } reader = Helpers.Execute(connection, queries[4]); reader.Read(); Assert.AreEqual(1, reader.GetInt32(0)); reader.Dispose(); Helpers.Execute(connection, queries[5]); } }
public void CheckIfTablesExists() { var queries = Helpers.GetQueries(System.Data.Jet.Test.Properties.Resources.CheckIfTableExistsTestQueries); using (var connection = Helpers.GetJetConnection()) { connection.Open(); Helpers.Execute(connection, queries[0]); bool exists = ((JetConnection)AssemblyInitialization.Connection).TableExists("CheckIfTableExistsTable"); Assert.IsTrue(exists); Helpers.Execute(connection, queries[1]); } }
public void InsertTestRun() { var queries = Helpers.GetQueries(Properties.Resources.InsertTestQueries); Assert.AreEqual(4, queries.Length); using (var connection = Helpers.GetJetConnection()) { connection.Open(); DbDataReader reader; for (int index = 0; index < queries.Length - 1; index++) { string query = queries[index]; reader = Helpers.Execute(connection, query); if (reader != null) { reader.Dispose(); } } Helpers.Execute(connection, queries[3]); } }