C# 连接HANA 数据库(元宝建议,未验证)

. 使用ADO.NET Data Provider(推荐)

安装NuGet包

Install-Package Sap.Data.Hana.v4.0

示例:

using System;
using Sap.Data.Hana;public class HanaConnection
{public void Connect(){string connectionString = "Server=your_server:30015;UserID=your_username;Password=your_password;";using (HanaConnection connection = new HanaConnection(connectionString)){try{connection.Open();Console.WriteLine("连接成功!");// 执行查询string query = "SELECT * FROM SCHEMA_NAME.TABLE_NAME";using (HanaCommand command = new HanaCommand(query, connection)){using (HanaDataReader reader = command.ExecuteReader()){while (reader.Read()){Console.WriteLine(reader.GetString(0));}}}}catch (Exception ex){Console.WriteLine($"连接失败: {ex.Message}");}}}
}