Microsoft.SqlServer.SqlManagementObjects 172.52.0 not compatible with Microsoft.Data.SqlClient 6.0.0

[MojoDK]

I can't add Microsoft.Data.SqlClient 6.0.0 to my projects, becuase I get this error:

Unable to find a version of 'Microsoft.Data.SqlClient' that is compatible with 'Microsoft.SqlServer.SqlManagementObjects 172.52.0 constraint: Microsoft.Data.SqlClient (>= 5.1.5 && < 6.0.0)'.

Is it possible to update Microsoft.SqlServer.SqlManagementObjects, so it is compatible?

Thanks.

[shueybubbles]

we've not tested SMO with SqlClient 6 yet. When we put the version limitation on the nupkg last year, we assumed version 6 would have breaking changes (otherwise why change the version number?). If there are no breaking changes in SqlClient 6 I can try to get a SMO update out in the next few weeks to lift the limitation.

[ErikEJ]

@shueybubbles There ARE breaking changes. SqlClient 6 targets .net 8 and netfx 4.6.2 only.

[shueybubbles]

@ErikEJ Would that difference break someone's build, though, if they are targeting net8 or net472 that SMO already supports?

I'm a bit nervous about getting pushback from SMO users if I adopt that same limited set of targets. Even though net6 and netstandard2 are out of support not everyone moves forward that fast.

[ErikEJ]

No, but it will prevent SMO from being able to use 6.0.

[shueybubbles]

I published 172.61.0-preview. It swaps out net6/netstandard2 and adds net8, and removes the major version restriction on the SqlClient dependency.

If you find it works for you, I will publish a non-preview one with the next SSMS 21 release.

[pregress]

Updated our project to use 172.61.0-preview all our tests are still passing, running against a SQL Server test container.

[ronymeyer]

We are also using 172.61.0-preview against Azure SQL Database without any issues.