Missing Key, Value in Nuget.config on `System.Data.SqlClient` to `Microsoft.Data.SqlClient` porting cheat sheet

[eilonik]

Describe the bug

Hello,
I'm following the cheat sheet to migrate from System.Data.SqlClient to Microsoft.Data.SqlClient, and after adding the required configuration and building I'm getting the following error messages:

Exception message:

Build FAILED.

C:\Program Files\dotnet\sdk\8.0.300\NuGet.targets(694,5): error : Unable to parse config file because: Missing required attribute 'key' in element 'add'.

And

C:\Program Files\dotnet\sdk\8.0.300\NuGet.targets(694,5): error : Unable to parse config file because: Missing required attribute 'value' in element 'add'.

Adding random key and value properties solved this issue. is there a specific key: value pair that needs to be used in this case?

[cheenamalhotra]

It seems that the Key, Value are also not documented on public Docs: https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/obtaining-a-dbproviderfactory#retrieving-provider-information

Nor on GetFactoryClasses() API docs.

So unless they were recently added by runtime, they shouldn't be required by .NET runtime.
Can you change .NET runtime targeted version to see if that fixes the error?

I would be interested to know which version of .NET runtime enforces this requirement, and we would also need updated docs too.

[ErikEJ]

@eilonik Please share the FULL config file and .csproj file. The configuration file changes are for .NET Framework projects, not .NET 8

[cheenamalhotra]

Closing as stale