Hi,
Often overlooked in microservices is how to get atomic transactional behaviour between database update and message publishing.
One solution is the transactional outbox.
It would be good if SQL server could have a plugin to do this - something a bit like CDC but instead of writing to a CDC table it attempts to publish to ASB (and also persisting to a table for undeliverable messages).
This would give very fast, reliable delivery to ASB.
For the edge case of ASB not being reachable a background scheduled thread would need to retry any undelivered messages.
Sql Server Service Broker seems too clunky to me - but please advise if this can be used as a clean solution for an outbox to Azure Service Bus.
Thanks
Michael