public Task Send(IList <Message> messages)
{
if (messages == null || messages.Count == 0)
{
return(Task.FromResult <object>(null));
}
var parameter = _dbProviderFactory.CreateParameter();
parameter.ParameterName = "Payload";
parameter.DbType = DbType.Binary;
parameter.Value = SqlPayload.ToBytes(messages);
var operation = new DbOperation(_connectionString, _insertDml, _logger, parameter);
return(operation.ExecuteNonQueryAsync());
}
public void Install()
{
_logger.LogInformation("Start installing SignalR SQL objects");
if (!IsSqlEditionSupported(_connectionString))
{
throw new PlatformNotSupportedException(Resources.Error_UnsupportedSqlEdition);
}
var script = GetType().GetTypeInfo().Assembly.StringResource("install.sql");
script = script.Replace("SET @SCHEMA_NAME = 'SignalR';", "SET @SCHEMA_NAME = '" + SqlMessageBus.SchemaName + "';");
script = script.Replace("SET @SCHEMA_TABLE_NAME = 'Schema';", "SET @SCHEMA_TABLE_NAME = '" + SchemaTableName + "';");
script = script.Replace("SET @TARGET_SCHEMA_VERSION = 1;", "SET @TARGET_SCHEMA_VERSION = " + SchemaVersion + ";");
script = script.Replace("SET @MESSAGE_TABLE_COUNT = 1;", "SET @MESSAGE_TABLE_COUNT = " + _tableCount + ";");
script = script.Replace("SET @MESSAGE_TABLE_NAME = 'Messages';", "SET @MESSAGE_TABLE_NAME = '" + _messagesTableNamePrefix + "';");
var operation = new DbOperation(_connectionString, script, _logger);
operation.ExecuteNonQuery();
_logger.LogInformation("SignalR SQL objects installed");
}
private void Receive(object state)
{
var tcs = (TaskCompletionSource <object>)state;
if (!_lastPayloadId.HasValue)
{
var lastPayloadIdOperation = new DbOperation(_connectionString, _maxIdSql, _logger)
{
LoggerPrefix = _loggerPrefix
};
try
{
_lastPayloadId = (long?)lastPayloadIdOperation.ExecuteScalar();
Queried();
_logger.LogDebug(String.Format("{0}SqlReceiver started, initial payload id={1}", _loggerPrefix, _lastPayloadId));
// Complete the StartReceiving task as we've successfully initialized the payload ID
tcs.TrySetResult(null);
}
catch (Exception ex)
{
_logger.LogError(String.Format("{0}SqlReceiver error starting: {1}", _loggerPrefix, ex));
tcs.TrySetException(ex);
return;
}
}
// NOTE: This is called from a BG thread so any uncaught exceptions will crash the process
lock (this)
{
if (_disposed)
{
return;
}
var parameter = _dbProviderFactory.CreateParameter();
parameter.ParameterName = "PayloadId";
parameter.Value = _lastPayloadId.Value;
_dbOperation = new ObservableDbOperation(_connectionString, _selectSql, _logger, parameter)
{
LoggerPrefix = _loggerPrefix
};
}
_dbOperation.Queried += () => Queried();
_dbOperation.Faulted += ex => Faulted(ex);
#if NET451
_dbOperation.Changed += () =>
{
_logger.LogInformation("{0}Starting receive loop again to process updates", _loggerPrefix);
_dbOperation.ExecuteReaderWithUpdates(ProcessRecord);
};
#endif
_logger.LogDebug(String.Format("{0}Executing receive reader, initial payload ID parameter={1}", _loggerPrefix, _dbOperation.Parameters[0].Value));
_dbOperation.ExecuteReaderWithUpdates(ProcessRecord);
_logger.LogInformation("{0}SqlReceiver.Receive returned", _loggerPrefix);
}
private void ProcessRecord(IDataRecord record, DbOperation dbOperation)