Clarify the difference between System.Data.SqlClient and Microsoft.Data.SqlClient in NuGet

[ericstj]

@sharwell raised the concern that he couldn't tell the difference between
https://www.nuget.org/packages/System.Data.SqlClient
and
https://www.nuget.org/packages/Microsoft.Data.SqlClient

Which should he use, and why?

Describe the solution you'd like

Clear messaging in the package descriptions around which package to use. Potentially marking the old one as obsolete.

[lcheunglci]

Hi @ericstj,

You can refer to this blog article when Microsoft.Data.SqlClient was introduced.

We would recommend using the latest LTS version of Microsoft.Data.SqlClient, which is currently 5.1.0 as it's the latest stable version that will be actively maintained for another 3 years, which can be found in the Life Cycle page. If you were previously using System.Data.SqlClient, we also have a guide to ease that process. You can also refer to the FAQ. Hope that helps with your decision in which library to use.

[ericstj]

I'm aware of those sources. I believe @sharwell's request was to make the guidaince more visible for the user who's just coming through NuGet.

For example: https://www.nuget.org/packages?q=SqlClient

From this it's not clear what to choose, as both have nearly identical descriptions.

[lcheunglci]

Thanks @ericstj for the clarification. I'll bring it up to the team and see if we can update the nuget description to make it easier to distinguish between them.

[JRahnama]

Closing as it was fixed by #1973