public bool CreateQueue(QueueInfo queue, out string errorMessage) { errorMessage = string.Empty; if (string.IsNullOrWhiteSpace(CurrentServer)) { errorMessage = ERROR_SERVER_IS_NOT_DEFINED; return(false); } if (string.IsNullOrWhiteSpace(CurrentDatabase)) { errorMessage = ERROR_DATABASE_IS_NOT_DEFINED; return(false); } try { Guid brokerId = SqlScripts.ExecuteScalar <Guid>(ConnectionString, SqlScripts.SelectServiceBrokerIdentifierScript(CurrentDatabase)); SqlScripts.ExecuteScript(ConnectionString, SqlScripts.CreateServiceQueueScript(brokerId, queue)); } catch (Exception ex) { errorMessage = ExceptionHelper.GetErrorText(ex); } return(string.IsNullOrEmpty(errorMessage)); }
public void CreateQueue(string name) { if (string.IsNullOrWhiteSpace(CurrentServer)) { throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED); } Guid brokerId = SqlScripts.ExecuteScalar <Guid>(ConnectionString, SqlScripts.SelectServiceBrokerIdentifierScript()); SqlScripts.ExecuteScript(ConnectionString, SqlScripts.CreateServiceQueueScript(brokerId, name)); }