Issue with connecting to PostgreSQL database

[wis-niowy]

Describe the bug
I am trying to establish a connection with PostgreSQL. Following this docs site: https://fsprojects.github.io/SQLProvider//core/postgresql.html I have copied Npgsql.dll in the chosen location and provided a path to this location as a ResolutionPath argument.
I have this code to achieve the connection:
`
module Postgresql =
open FSharp.Data.Sql

let [<Literal>] connectionString = "Host=localhost; Database=TestDb; Username=postgres;Password=postgres"
let [<Literal>] resolutionPath = @"C:\Users\%user%\source\repos\MySolution"
// create a type alias with the connection string and database vendor settings
type sql = SqlDataProvider< 
              ConnectionString = connectionString,
              DatabaseVendor = Common.DatabaseProviderTypes.POSTGRESQL,
              ResolutionPath = resolutionPath,
              IndividualsAmount = 1000,
              UseOptionTypes = Common.NullableColumnType.OPTION
              >
let ctx = sql.GetDataContext()

`
The error that I get when trying to build the project (via CLI) is as follows:

C:\Users\%user%\source\repos\Wisniowy.FSharpUtils\Wisniowy.FSharpUtils.DatabaseAccess\Library.fs(12,16): error FS3033: The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Could not create the connection, most likely this means that the connectionString is wrong. See error from Npgsql to troubleshoot: Could not load file or assemb
ly 'Microsoft.Extensions.Logging.Abstractions, Version=6.0.0.0, Culture=neutral, PublicKeyToken=adb9793829ddae60'. The system cannot find the file specified. [C:\Users\%user%\source\repos\Wisniowy.FSharpUtils\Wisniowy.FSharpUtils.DatabaseAccess\Wisniowy.FSharpUtils.DatabaseAccess.fsproj]
C:\Users\%user%\source\repos\Wisniowy.FSharpUtils\Wisniowy.FSharpUtils.DatabaseAccess\Library.fs(12,16): error FS3033: The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Could not create the connection, most likely this means that the connectionString is wrong. See error from Npgsql to troubleshoot: Could not load file or assemb
ly 'Microsoft.Extensions.Logging.Abstractions, Version=6.0.0.0, Culture=neutral, PublicKeyToken=adb9793829ddae60'. The system cannot find the file specified. [C:\Users\%user%\source\repos\Wisniowy.FSharpUtils\Wisniowy.FSharpUtils.DatabaseAccess\Wisniowy.FSharpUtils.DatabaseAccess.fsproj]

So I focus mostly on the first line: "The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Microsoft.Data.SqlClient is not supported on this platform."
I have Microsoft.Data.SqlClient installed in this project, all my nuget packages are:
SQLProvider - v.1.3.7
Npgsql - v.7.0.2
Microsoft.Data.SqlClient - v.5.1.0

To Reproduce
Steps to reproduce the behavior:

1. Copy the code provided above
2. Make sure you have an instance of PostgreSQL (or a docker container)
3. Try to run the code

Expected behavior
Successful connection with the db and a successful sample read done..

Screenshots
The error displayed when I hover over the code sample:

and when I build the solution with ctrl+shift+B (same error)

The dll files added to the "resolution path" location:

I added Npgsql.dll along with two other dlls according to some suggestion I had found on stack overflow (they are the external dependencies that Npgsql.dll has and that it needs)

Desktop (please complete the following information):

• OS: Windows 10

Additional context

[JulesNP]

I'm experiencing the same issue on both Windows 11 and MacOS. Using Npgsql directly works, but when using it via SqlDataProvider it fails.