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 CreateRemoteUser(string targetQueueFullName, string certificateBinaryData) { if (string.IsNullOrWhiteSpace(CurrentServer)) { throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED); } Guid targetBroker = SqlScripts.GetBrokerId(targetQueueFullName); SqlScripts.ExecuteScript(ConnectionString, SqlScripts.CreateRemoteUserScript(targetBroker, certificateBinaryData)); }
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)); }
public void SetupServiceBroker() { if (string.IsNullOrWhiteSpace(CurrentServer)) { throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED); } SqlScripts.ExecuteScript(ConnectionString, SqlScripts.CreateDatabaseScript()); Guid brokerId = SqlScripts.ExecuteScalar <Guid>(ConnectionString, SqlScripts.SelectServiceBrokerIdentifierScript()); SqlScripts.ExecuteScript(ConnectionString, SqlScripts.CreateDatabaseUserScript(brokerId)); SqlScripts.ExecuteScript(ConnectionString, SqlScripts.CreateChannelsTableScript()); }
public void SendMessage(string routeName, string payload) { if (string.IsNullOrWhiteSpace(CurrentServer)) { throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED); } Guid handle = SqlScripts.ExecuteScalar <Guid>(ConnectionString, SqlScripts.SelectDialogHandleScript(routeName)); string sql = SqlScripts.SendMessageToChannelScript(); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("handle", handle); parameters.Add("message", payload); SqlScripts.ExecuteScript(ConnectionString, sql, parameters); }
public void CreateRoute(string name, string sourceQueueFullName, string targetAddress, string targetQueueFullName) { if (string.IsNullOrWhiteSpace(CurrentServer)) { throw new InvalidOperationException(ERROR_SERVER_IS_NOT_DEFINED); } Guid sourceBroker = SqlScripts.GetBrokerId(sourceQueueFullName); Guid targetBroker = SqlScripts.GetBrokerId(targetQueueFullName); string sourceQueueName = SqlScripts.GetQueueName(sourceQueueFullName); string targetQueueName = SqlScripts.GetQueueName(targetQueueFullName); string script = SqlScripts.CreateRouteScript(name, sourceBroker, sourceQueueName, targetAddress, targetBroker, targetQueueName); SqlScripts.ExecuteScript(ConnectionString, script); }