예제 #1
0
        public void Close()
        {
            sql?.CloseConnection();
#if !NO_ODBC
            odbc?.CloseConnection();
#endif
        }
예제 #2
0
        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);
            }
        }