public void Close() { sql?.CloseConnection(); #if !NO_ODBC odbc?.CloseConnection(); #endif }
private void CreateMssqlDatabase() { DBHelper.ExecuteNonQuery(sql.Connection, $"CREATE DATABASE [{DatabaseName}]"); sql.ConnectionString = sql.ConnectionString.Replace(sql.Connection.Database, DatabaseName); sql.CloseConnection(); string query = File.ReadAllText(TestResourceHelper.GetFullPathOfResource("Test/ProviderTests/sql/sqlserver.sql")); var queries = SplitSqlStatements(query); foreach (var subQuery in queries) { DBHelper.ExecuteNonQuery(sql.Connection, subQuery); } }