Better Support for Nuget Dependencies for Binary Modules

Port of https://github.com/PowerShell/PowerShell/issues/15588

Summary of the new feature/enhancement

Powershell Package Authoring in C#/.Net is a very unsatisfying task for anything that relies on complex Nuget Packages. As an example: It's nearby impossible to get a package working on Powershell Gallery that relies on the Nuget Package of the SQL Server Driver (Microsoft.Data.SqlClient). I have to reference platform specified dll's somehow and it requires a lot of code just to get that dll working. The SQL Server Module

In addition, as a Powershell package can only have dependencies from PowershellGallery (de-facto), it's common to include the .Net DLLs in the Package, see SqlServer Module for example. If two packages include the same dll's we have a conflict. As an example, the SqlServer Module mentioned uses Newtonsoft.Json which should be fairly common to include.

Proposed technical implementation details

I'd propose to support Nuget Dependencies directly in the Manifest Files (psd1).

Inizia leggendo il supporto proposto per le dipendenze NuGet nei file manifesto dei moduli PowerShell (psd1), quindi confronta la gestione delle dipendenze e delle DLL utilizzata da SqlServer Module. Definisci come gli autori dei pacchetti dichiarerebbero le dipendenze NuGet e come dovrebbero essere risolte le DLL .NET in conflitto; il completamento richiede un design condiviso e la relativa implementazione e i test.