net8.0 + Microsoft.Data.SqlClient <5.2.0 incompatibility

Microsoft.SqlServer.SqlManagementObjects 171.30.0 depends on Microsoft.Data.SqlClient 5.1.4. Upgrading a tests project from net6.0 to net8.0 produces the following exception

OneTimeSetUp: System.Reflection.ReflectionTypeLoadException : Unable to load one or more of the requested types. Could not load type 'SqlGuidCaster' from assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5' because it contains an object field at offset 0 that is incorrectly aligned or overlapped by a non-object field. ----> System.TypeLoadException : Could not load type 'SqlGuidCaster' from assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5' because it contains an object field at offset 0 that is incorrectly aligned or overlapped by a non-object field.

Upgrading to Microsoft.Data.SqlClient 5.2.0 fixes the issue, as documented here: https://github.com/dotnet/SqlClient/issues/1930

Comienza localizando el proyecto de pruebas y su dependencia Microsoft.SqlServer.SqlManagementObjects. Reproduce el fallo de inicio de las pruebas net8.0 con Microsoft.Data.SqlClient 5.1.4 y, a continuación, verifica que el uso de la versión 5.2.0 permite que las pruebas se carguen correctamente.