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

Commencez par localiser le projet de tests et sa dépendance Microsoft.SqlServer.SqlManagementObjects. Reproduisez l’échec du démarrage des tests net8.0 avec Microsoft.Data.SqlClient 5.1.4, puis vérifiez que l’utilisation de la version 5.2.0 permet aux tests de se charger correctement.