Move to Microsoft.Data.SqlClient

[divega]

Now that the preview of Microsoft.Data.SqlClient is available in NuGet, we should be able to use it.

[ralmsdeveloper]

Wonderful!

https://github.com/dotnet/SqlClient/blob/master/release-notes/1.0/1.0.0.md

[Tim-Bijnens]

Following this since we could realy use this to help port our current website to an Always Encrypted .Net Core app

[zenunits]

Waiting for Microsoft.Data.SqlClient to be integrated in preview of Microsoft.Entity.SqlServer. Currently its using System.Data.SqlClient as dependency.

Badly needed it to take advantage of column encryption feature of SQL Server 2016 in .net core project using entity core.

[ErikEJ]

@kedarchinchvalkar @Tim-Bijnens You can use the new client with EF Core 2.x as described here: dotnet/SqlClient#11 (comment)