Class library dll throwing exception Could not load file or assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0 but it reference version 5.2.0

Moshe Yalovsky 5

I have created Class Library using Visual Studio 2022 community v 17.9.6 TragetFramework 8 project file

<Project Sdk="Microsoft.NET.Sdk">
  <PropertyGroup>.0
    <TargetFramework>net8.0</TargetFramework>
    <ImplicitUsings>enable</ImplicitUsings>
    <Nullable>enable</Nullable>
    <AssemblyName>AchieveResource</AssemblyName>
    <RootNamespace>Achieve.AchieveResource</RootNamespace>
  </PropertyGroup>
  <ItemGroup>
    <PackageReference Include="Azure.Identity" Version="1.11.0" />
    <PackageReference Include="Microsoft.Data.SqlClient" Version="5.2.0" />
  </ItemGroup>
  <ItemGroup>
    <Reference Include="Achieve.Common">
      <HintPath>..\Achieve.Common\bin\Debug\net8.0\Achieve.Common.dll</HintPath>
    </Reference>
  </ItemGroup>
  <ItemGroup>
    <Compile Update="AchieveResource1.Designer.cs">
      <DesignTime>True</DesignTime>
      <AutoGen>True</AutoGen>
      <DependentUpon>AchieveResource1.resx</DependentUpon>
    </Compile>
  </ItemGroup>
   </Project>

A console application is referencing this dll and when one of the static methods in the library is called, it throws the following error, although the project is referencing
<PackageReference Include="Microsoft.Data.SqlClient" Version="5.2.0" /> it complains that Microsoft.Data.SqlClient version 5.0.0.0 not found.
I got a similar error when using System.Data.SQLClient 4.8.6 and the error was that System.Data.SQLClient version 4.4.0 could not be found.
Any idea? Thanks

FileNotFoundException: Could not load file or assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5'. The system cannot find the file specified.
System.TypeInitializationException
  HResult=0x80131534
  Message=The type initializer for 'Achieve.AchieveReserouce.ConnectionStrings' threw an exception.
  Source=AchieveResource
  StackTrace:
   at Achieve.AchieveReserouce.ConnectionStrings.GetEnterpriseConnectionString()
   at Program.<Main>$(String[] args) in C:\Dev\Achieve\2022Projects\ConsoleApp1\Program.cs:line 4

  This exception was originally thrown at this call stack:
    [External Code]

Inner Exception 1:
FileNotFoundException: Could not load file or assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5'. The system cannot find the file specified.

The line in the console application is

OUConstr = Achieve.AchieveReserouce.ConnectionStrings.GetConnectionSringForOU(1004);

1 answer

Anna Xiu-MSFT 26,561 Reputation points Microsoft Vendor

2024-04-30T03:40:04.9133333+00:00

Hi @Moshe Yalovsky,

Welcome to Microsoft Q&A!

What target framework is your console application using?

Please add the Microsoft.Data.SqlClient package as a reference to the console application.

Sincerely,

Anna

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Moshe Yalovsky 5 Reputation points

2024-04-30T13:31:28.83+00:00

The console application is trargeting 8.0.
Adding reference to Microsoft.Data.SqlClient package to, beat the whole purpose of separation. The user of the class library does not need to know who the class is retrieving data and from where. The class is returning regular c# objects.
I did that but it did fix the issue

Moshe Yalovsky 5 Reputation points

2024-04-30T21:28:58.77+00:00

I think I know what is going on. In one of the steps, I was catching errors without throwing them up.
The error was Microsoft.Data.SqlClient is not supported on this platform.
On the Microsoft site, it was not clear if Microsoft.Data.SqlClinet 5,2,8 compatible with 8.0. On the front page, it shows .net 6 but somewhere else it shows .Net 8. Since then, I was trying to change the target of the project to match, but that did not work. Do you know what combination that does not have vulnerabilities of frame work and the Microsoft.Data.SqlClient will work? Thanks

Anna Xiu-MSFT 26,561 Reputation points Microsoft Vendor

2024-05-01T09:56:09.8966667+00:00

Hello, from looking at the Microsoft.Data.SqlClient package, the version 5.2.0 is compatible with the .NET 8.0.

Moshe Yalovsky 5 Reputation points

2024-05-01T13:46:09.8+00:00

I know but I am still getting this error "Microsoft.Data.SqlClient is not supported on this platform."
I really need help to figure this.
Thanks

<Project Sdk="Microsoft.NET.Sdk">

<PropertyGroup>

<TargetFramework>net8.0</TargetFramework>

<ImplicitUsings>enable</ImplicitUsings>

<Nullable>enable</Nullable>

<AssemblyName>AchieveResource</AssemblyName>

<RootNamespace>Achieve.AchieveResource</RootNamespace>

</PropertyGroup>

<ItemGroup>

<PackageReference Include="Azure.Identity" Version="1.11.0" />

<PackageReference Include="Microsoft.Data.SqlClient" Version="5.2.0" />

<PackageReference Include="Microsoft.Identity.Client" Version="4.60.3" />

</ItemGroup>

<ItemGroup>

<Reference Include="Achieve.Common">

<HintPath>..\Achieve.Common\bin\Debug\net6.0\Achieve.Common.dll</HintPath>

</Reference>

</ItemGroup>

<ItemGroup>

<Compile Update="AchieveResource1.Designer.cs">

<DesignTime>True</DesignTime>

<AutoGen>True</AutoGen>

<DependentUpon>AchieveResource1.resx</DependentUpon>

</Compile>

</ItemGroup>

</Project>

This is where the error occurs

using Achieve.AchieveReserouce.Models;

using Achieve.AchieveResource.Services;

//using System.Data.SqlClient;

using Microsoft.Data.Sql;

using Microsoft.Data.SqlClient;

using System.Data;

using System.Resources;

namespace Achieve.AchieveReserouce

{

#region connection Strings

public static class ConnectionStrings

{

private static string fileName = "";

private static string Path32 = "";

private static string Path64 = "";

private static string EnterpriseConnectionString = "";

private static int OUGlobal;

private static List<OUConnectionString> OUconnectionStrings;

public static Achieve.Common.Result result = new Achieve.Common.Result();

static ConnectionStrings()

{

result = new Achieve.Common.Result();

string ConString = "";

//String PathToFile = rm.GetString("AchieveEnterpriseConStrPath");

Path32 = @"C:\Program Files (x86)\Achieve Sub Escrow\constrEN.ach";

Path64 = @"C:\Program Files\Achieve Sub Escrow\constrEN.ach";

if (File.Exists(Path32))

{

ConString = System.IO.File.ReadAllText(Path32);

}

if (string.IsNullOrEmpty(ConString) == true)

{

if (File.Exists(Path64))

{

ConString = System.IO.File.ReadAllText(Path64);

}

}

if (string.IsNullOrEmpty(ConString))

{

result.ErrorMessages.Add($"No constr found in path 32 {Path32} or in path 64 {Path64}");

}

EnterpriseConnectionString = ConString;

if (EnterpriseConnectionString == null)

{

//raise an error

ApplicationException applicationException = new ApplicationException("ConnectionString could not evaluate EnterpriseConnectionString"

);

throw applicationException;

}

//if the OU connection strings were not yet loaded, load them first

if (OUconnectionStrings == null)

{

OUConnectionString oUConnectionString = new OUConnectionString();

try

{

SqlConnection conn = new SqlConnection(EnterpriseConnectionString);

conn.Open(); //<----------- Error here

SqlCommand cmdGetOUConStrings = new SqlCommand("SPN_OU_GetAll", conn);

cmdGetOUConStrings.CommandType = CommandType.StoredProcedure;

SqlDataReader rdr = cmdGetOUConStrings.ExecuteReader();

while (rdr.Read())

{

oUConnectionString = new OUConnectionString();

oUConnectionString.OUID = rdr.GetInt32(0);

oUConnectionString.DisplayName = rdr.GetString(1);

oUConnectionString.SystemName = rdr.GetString(2);

oUConnectionString.ConnectionString = rdr.GetString(3);

if (!rdr.IsDBNull(4))

{

oUConnectionString.ADOConnectionString = rdr.GetString(4);

}

oUConnectionString.TimeToLive = rdr.GetInt16(5);

if (!rdr.IsDBNull(6))

{

oUConnectionString.Address1 = rdr.GetString(6);

}

if (!rdr.IsDBNull(7))

{

oUConnectionString.Address2 = rdr.GetString(7);

}

if (!rdr.IsDBNull(8))

{

oUConnectionString.City = rdr.GetString(8);

}

if (!rdr.IsDBNull(9))

{

oUConnectionString.State = rdr.GetString(9);

}

if (!rdr.IsDBNull(10))

{

oUConnectionString.Zip = rdr.GetString(10);

}

if (!rdr.IsDBNull(11))

{

oUConnectionString.PhoneNumber = rdr.GetString(11);

}

if (!rdr.IsDBNull(12))

{

oUConnectionString.FaxNumber = rdr.GetString(12);

}

if (!rdr.IsDBNull(13))

{

oUConnectionString.Email = rdr.GetString(13);

}

}

conn.Close();

}

catch (Exception Ex)

{

result.Success = false;

result.ErrorMessages.Add(Ex.Message);

}

}

}

public static string GetEnterpriseConnectionString() { return EnterpriseConnectionString; } public static string GetConnectionSringForOU(int OUID) { string OUConString = ""; result = new Achieve.Common.Result(); result.Success = true; //return the specific one try { var tempOu = OUconnectionStrings.Find(i => i.OUID == OUID); if (tempOu != null) { OUConString = tempOu.ADOConnectionString; } } catch (Exception ex) { if (ex.Message.ToLower().Contains("sequence contains no matching element") == true) { result.ErrorMessages.Add("OUID not found"); result.Success = false; } else { result.Success = false; result.ErrorMessages.Add(ex.Message); } } return OUConString; }

}

#endregion

}

Moshe Yalovsky 5 Reputation points

2024-05-01T13:57:18.31+00:00

I understand but I am still getting the same error:

"Microsoft.Data.SqlClient is not supported on this platform."

I really need help to resolve this issue.

Thanks

Moshe Yalovsky 5 Reputation points

2024-05-06T15:10:29.13+00:00

The target framework of the console is 8,0

Referencing Microsoft.Data.SqlClient to the Console application is not a solution. Consumers of class library dll, do not need to reference any components that the class uses. This is a basic concept.

That said, I tried it and it didn't help.

I really need help resolving this issue.

Thanks
Sign in to comment

Share via

Class library dll throwing exception Could not load file or assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0 but it reference version 5.2.0

1 answer