Ensure SQL Service Broker is enabled

gistfile1.cs

static void ensureServiceBrokerEnabled()
{
    var sql = @"if (SELECT is_broker_enabled FROM sys.databases WHERE name = DB_NAME()) = 0
        begin
            declare @sql nvarchar(max) = 'ALTER DATABASE ' + QUOTENAME(DB_NAME()) + ' SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE'
            exec(@sql)
        end";
    using (var db = DependencyResolver.Current.GetService<IDbConnection>())
    {
        db.Open();
        db.Execute(sql);
    }
}