.net code 连接SAP HANA 数据库

使用 SAP .NET Connector

SAP 提供了一个专门的 .NET Connector，可以直接用于连接 SAP HANA 数据库。

1､下载配置SAP HANA客户端驱动程序

下载地址：https://tools.eu1.hana.ondemand.com/#hanatools

安装 SAP .NET Connector

 

项目中引用Sap.Data.Hana

SAP .NET Connector安装完成会在
C:\Program Files\sap\hdbclient\dotnetcore\v6.0
生成安装文件

 建议把这2个dll,放在项目bin目录下和C:\Windows\System32下

要将其添加到项目中，请在解决方案资源管理器中右键单击项目的“引用”文件夹，然后选择“添加引用...”。在.NET选项卡中搜索“ Sap.Data.Hana.Net.v6.0”引用，然后单击“确定”。如果您使用的是.NET的其他版本，请从列表中选择一个。

"HanaConnection": "Server=10.11.35.2:30044;UserName=saphanadb;Password=Init123456;",
"SapClient": "610"

 

using HPRTWEBAPI.Application.Service.SapRfc.Dto.Response;
using HPRTWEBAPI.Application.Service.SapRfc.Interface;
using HPRTWEBAPI.Database;
using Sap.Data.Hana;
using System.Data;
using System.Text;
using Sap.EntityFrameworkCore.Hana;
using NewLife.Reflection;
using static Microsoft.EntityFrameworkCore.DbLoggerCategory.Database;namespace HPRTWEBAPI.Application.Service.SapRfc
{[ApiDescriptionSettings("SapHana", Name = "SapHana", Order = 100)][Route("api")]public class SapHanaService : ISapHanaService, IDynamicApiController, ITransient{private string connectionStringHana = App.Configuration["HanaConnection"].ToString();private string sapClient = App.Configuration["SapClient"].ToString();public SapHanaService(){}/// <summary>/// SapHana查询测试/// </summary>/// <returns></returns>[HttpGet("sap/GetAll")]public async Task<List<OuputKH>> GetAll(){using (HanaConnection conn = new HanaConnection(connectionStringHana)){//using (HanaDataAdapter dataAdapter = new HanaDataAdapter("SELECT PARTNER ,BU_GROUP FROM BUT000 WHERE  PARTNER = '0010001942'", conn))//{//    DataTable testTable = new DataTable();//    dataAdapter.Fill(testTable);//    var ouputKHs = testTable.ToList<OuputKH>();//    return ouputKHs;//}string sql = @"SELECT PARTNER ,BU_GROUP FROM BUT000 WHERE  BUT000.PARTNER=? AND CLIENT=?";HanaCommand command = new HanaCommand(sql, conn);command.Parameters.AddWithValue("@BUT000.PARTNER", "0010001942");command.Parameters.AddWithValue("@CLIENT", sapClient);using (HanaDataAdapter dataAdapter = new HanaDataAdapter(command)){DataTable testTable = new DataTable();dataAdapter.Fill(testTable);var ouputKHs = testTable.ToList<OuputKH>();return ouputKHs;}}}}
}