Start some SQL Server updates
- Make the receiver sync (just use a BG thread, no need for async here)
- Have the receiver only setup a query notification after no messages received for a set loop count
- Fix init code
- Add inserted datetime to messages table so we can add a cleanup routine later
Update SQL message bus for latest scale-out changes
- Pass through TraceSource
- Override the correct Send overload
- Added some marker comments for work to complete
Added tracing to SqlReceiver
SQL message bus now works!
- Fixed SQL query notification subscription issues
- Ensure table scheme name is used everywhere ([dbo])
- Re-use SqlCommand object
- Store messages in binary now, like the Redis message bus
- Refined tracing so that it's easier to see which derived MessageBus traced what message
- Added TraceSourceExtensions to make it simpler to trace verbose and error messages
Added some extra comments
SQL message bus now uses [SignalR] schema
- Now uses a specific schema [SignalR] instead of default [dbo]
- Updated installer logic to check for schema and create if missing
- #943
Fixed scale-out comments in sample site
Fix FxCop issues