github Particular/NServiceBus.SqlServer 2.0.0-beta1
2.0.0 beta1

latest releases: 8.1.6, 7.0.8, 7.0.7...
pre-release10 years ago

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

Don't miss a new NServiceBus.SqlServer release

NewReleases is sending notifications on new releases.