public void ShouldInstallConfigurationSchema()
{
var creator = new SchemaInstaller();
creator.InstallHangfireConfigurationSchema(ConnectionString);
var expected = "hangfireconfiguration";
using var conn = SelectDialect <DbConnection>(() => new SqlConnection(ConnectionString), () => new NpgsqlConnection(ConnectionString));
var actual = conn.ExecuteScalar <string>($"SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '{expected}'");
Assert.AreEqual(expected.ToLower(), actual.ToLower());
}