public async Task <ISqlTransactionalOutboxItem <Guid> > SendMessageAsync(string message)
{
//Initialize the Payload from the Body as Json!
var payloadBuilder = new PayloadBuilder()
{
PublishTarget = this.ServiceBusTopic,
To = "CajunCoding",
Body = message,
FifoGroupingId = "AllConsoleAppTestItemsShouldBeFIFO"
};
await using var sqlConnection = new SqlConnection(this.SqlConnectionString);
await sqlConnection.OpenAsync();
//************************************************************
//*** Add The Payload to our Outbox
//************************************************************
var outboxItem = await sqlConnection.AddTransactionalOutboxPendingItemAsync(
publishTarget : payloadBuilder.PublishTarget,
payload : payloadBuilder.ToJObject(),
//It's always a good idea to ensure that a FIFO Group Id/Name is specified for any FIFO Subscriptions that may receive the messages...
fifoGroupingIdentifier : payloadBuilder.FifoGroupingId ?? "DefaultFifoGroup"
).ConfigureAwait(false);
return(outboxItem);
}
