

Introduction and the roadmap of the new SQL ClientĪbout the Authors: Hadi Eskandari and Mike Minutillo are both developers at Particular Software.
#Sql client for windows upgrade#

Because SQL Persistence uses a connection builder approach to creating the SqlConnection object, you can use your choice of SQL client with the same SQL Persistence package. For SQL Persistence, we’ve added support for the new SQL client in version 5.The first release of this package is version 6, matching the current version of the NService.SqlServer package, and we will continue to release both packages in lockstep. is a new package that contains the same code, but uses the new package.NServiceBus.SqlServer will continue to use the.For the SQL Server Transport, we now have two separate packages:.🔗MigrationĪs there is feature parity between the old and the new SQL clients at the time of writing this post, it should be fairly easy to migrate to the new SQL client.įor NServiceBus users, we have a few packages that are affected: In most cases, the will be the one you should use for any project moving forward, and you will probably need to convert existing projects to use it over time as well. NET Framework, allowing clients to keep up to date with the latest changes on the server.

The NuGet package can be released much more frequently than the. This client library is shipped outside of the. To resolve this situation Microsoft released a new client library called. NET Framework are not released as often as the client library needs to be updated. NET Framework is a big task and is limited by the Microsoft support and backward compatibility guarantees. NET Framework and can only be updated when a new version of the. Unfortunately, the library is also shipped as part of the.
#Sql client for windows update#
This is especially true in the cloud with services such as Azure SQL Database that tend to update very often. Have you noticed that database servers are getting more frequent updates? To make use of new features in the server, you need an updated client library. Let’s see why, which one you should choose, and how this affects our NServiceBus packages. Wait…didn’t we already have a stable SQL client library shipped as a part of. A few months back, Microsoft released a brand new SQL client library called on NuGet.
