topic Re: System.Data.SQLClient - Autocad 2025 in .NET Forum

System.Data.SQLClient - Autocad 2025

tmfieker — Tue, 26 Mar 2024 20:46:02 GMT

Loading an app (DLL created in VB.NET using .NET Framework 4.6) in Autocad 2025 returns the following error.

This app try to connect to a Microsft SQL Server using System. Data.SQLClient.

Running the same app in Autocad 2018 and 2024 it works perfectly.

Rebuild using .NET Framework 4.8 the same error is returned.

When SQL Server is not accessed this app runs in Autocad 2025 successfully (using .NET Framework 4.6 or 4.8).

Why is this occurring only in Autocad 2025?

Thanks!

Re: System.Data.SQLClient - Autocad 2025

matt.worland — Tue, 26 Mar 2024 20:57:56 GMT

In 2025, Autocad is using .NET instead of the 4.8 framework. In .NET I believe it it was changed to Microsoft.Data instead of System.Data

Re: System.Data.SQLClient - Autocad 2025

tmfieker — Wed, 27 Mar 2024 19:56:25 GMT

Matt, thanks for the answer, but replacing System.Data. SQLClient by Microsoft.Data.SQLClient also does not work and generates other errors.

Re: System.Data.SQLClient - Autocad 2025

kerry_w_brown — Wed, 27 Mar 2024 21:34:10 GMT

From Dario Bellinazzi

I had the same problem, you need to specify both target framework and runtime platform in the .proj file:

<PropertyGroup>
<TargetFramework>net8.0-windows</TargetFramework>
<RuntimeIdentifier>win-x64</RuntimeIdentifier>
</PropertyGroup>

Without <RuntimeIdentifier> dotnet builder doesn't know which type of SqlClient implementation (or others ex. .net Framework converted to NuGet namespaces) is expected to be used from .NET8 in the AutoCAD Environment from the various given by NuGet Package for different platforms.

//---

Do you find System.Data.SqlClient.dll in your output path folder?
If not add <CopyLocalLockFileAssemblies>true</CopyLocalLockFileAssemblies>. .NET8 doesn't automatically copy referenced packages without this setting, so it could be that the assembly resolver is not finding the referenced library because is not present.

I understand this issue was still being addressed.

perhaps Madhukar Moogala ( @moogalm ) can help.

Untried.
Regards,

Re: System.Data.SQLClient - Autocad 2025

tmfieker — Thu, 28 Mar 2024 14:37:28 GMT

Thanks, I´ll send an email to Madhu.

I will test your sugestion too.

Re: System.Data.SQLClient - Autocad 2025

tmfieker — Mon, 15 Apr 2024 20:28:49 GMT

Is is necessary to follow the Migration Guide written by Gilles Chanteau:

https://info.quuxsoft.com/ftp/Migration_NET_Core%20English.pdf