Search code examples
asp.net-core.net-core.net-assemblyasp.net-core-2.2linq2db

Connecting .NET Core web application to sap hana (could not load assembly)

I am using linq2db as ORM for my web application project (ASP.NET Core 2.2) with SAP HANA database.

When I run my code including database queries I receive the following error (first 2 rows):

System.IO.FileNotFoundException: Could not load file or assembly 'Sap.Data.Hana, Culture=neutral, PublicKeyToken=null'.
File name: 'Sap.Data.Hana, Culture=neutral, PublicKeyToken=null'

I assumed that Sap.Data.Hana refers to the assembly SAP HANA provides in their data provider package. That's why I established a reference to the assembly Sap.Data.Hana.v4.5.dll using Visual Studio UI. However, I still receive the same error.

What could be the reason for this error? Am I using the wrong assembly file or do I have to establish the reference differently?

Solution

  • SAP have added support for .net core from HANA 2.0 SPS4: SAP HANA Client Interface Programming Reference for SAP HANA Platform

    Also see SAP Note 2499500.