public void CreateNewDatabase() { ; using var connection = new SqlConnection(GetConnectionString()); connection.Open(); var expression = new CreateDatabase(TestDbName); using var statement = new Statement(expression.ToString(), connection); var result = statement.Execute(); Assert.Equal(-1, result); using var dropStatement = new Statement(new DropDatabase(TestDbName).ToString(), connection); var dropResult = dropStatement.Execute(); Assert.Equal(-1, dropResult); connection.Close(); }
public void CreateDatabaseWithoutCollation() { var expression = new CreateDatabase(Database); Assert.Equal("CREATE DATABASE " + Database, expression.ToString()); }
public void CreateDatabaseWithCollation() { var expression = new CreateDatabase(Database, Collation); Assert.Equal("CREATE DATABASE " + Database + " COLLATE " + Collation, expression.ToString()); }