Automate detecting new transitive dependencies for .NET Framework

[Kielek]

TransientDependenciesTests.DefinedTransientDeps_Are_MatchingGeneratedDeps is not able to detect new transitive dependencies.
Example:

OpenTelemetry.Exporter.Zipkin references System.Text.Json 4.7.2 (without any reference to System.IO.Pipelines). The we upgrade this package to System.Text.Json 9.0.0. New version is referencing System.IO.Pipelines.

Mentioned tests was modified to manually handle this particular case. It should be automated to handle all future changes automatically.