As part of this release we had 3 issues closed.
Improvements
#38 Move to .net 4.5
related to Particular/NServiceBus#2078
#3 Improve error reporting in SqlServerPollingDequeueStrategy
If you neglect to Configure.Instance.ForInstallationOn<Windows>().Install()
, SqlServer transport will not create its tables. Later the SqlServerPollingDequeueStrategy
will have exceptions because the objects does not exist.
The issue is that the exception reported to log is
WARN NServiceBus.Transports.SQLServer.SqlServerPollingDequeueStrategy - Failed to connect to the configured SqlServer
The message is inaccurately reporting a connection failure.
Content trimmed. See full issue
#32 Expose the SqlConnection used to receive incoming messages
You can now access the IDbConnection
and SqlTransaction
from your own sagas and/or handlers.
To do this inject SqlServerStorageContext
Bugs
#29 Using transport with no DTC
This issue is raised as part of the diagnosing of #17
The problem is that to prevent DTC escalation we cannot use nested ADO connections from within a handler, so we need a way to expose both the ado connection + ado transaction to the end user.
Here is what @andreasohlund said:
Did some research and it seems escalation wont happen if "the connections are not open at the same time"
http://stackoverflow.com/a/1693270/236004
Since we keep the connection open during receive I believe the escalation will happen when a second connection is opened. To fix this we need to share the connection or have the users use our native transaction. Does this make sense?
Content trimmed. See full issue
Where to get it
You can download this release from nuget