コード例 #1
0
    protected override SqlCommand CreateSendCommand(OutgoingDelayedMessage message)
    {
        var command = Connection.CreateCommand(Transaction, string.Format(SendSql, Table));

        var dueParameter     = CreateDueParameter(command);
        var headersParameter = CreateHeadersParameter(command);
        var bodyParameter    = CreateBodyParameter(command);

        dueParameter.Value     = message.Due;
        headersParameter.Value = message.Headers;
        bodyParameter.SetBinaryOrDbNull(message.Body);

        return(command);
    }
コード例 #2
0
    async Task Send()
    {
        string headers = null !;

        byte[] body = null !;

        #region SendDelayed

        var manager = new DelayedQueueManager("endpointTable.Delayed", sqlConnection);
        var message = new OutgoingDelayedMessage(
            due: DateTime.UtcNow.AddDays(1),
            headers: headers,
            bodyBytes: body);
        await manager.Send(message);

        #endregion
    }