Problem with NuGet Microsoft Data SqlClient library

Question

Microsoft Data SqlClient is referenced in the Visual Studio C Sharp project. Code throws an error ' The type 'IDbColumnSchemaGenerator' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Common, Version=4.2.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. NuGet Microsoft.Data.SqlClient is showing as installed. have tried the following console commands

1.'dotnet nuget locals all --clear

2.'dotnet restore

3.'dotnet clean

4.'dotnet build - error 'build failed. But NuGet Microsoft Data SqlClient is reported as installed in NuGet Browse tab

Answer 1

Moving on a bit, installing Microsoft.Data.SqlClient isn't completing fully, attempts to install and then does a roll back near the end of the install with following error : Error Could not find a part of the path 'C:\Users..............................\packages\Microsoft.Extensions.DependencyInjection.Abstractions.8.0.2\buildTransitive/netcoreapp2.0/Microsoft.Extensions.DependencyInjection.Abstractions.targets'.

Then attempted to repeat NuGet Microsoft.Data.SqlClient install in a completely new effectively blank project ( .NET Framework 4.7.2, Windows Forms App ) and got exactly the same error