健康一贴灵,专注医药行业管理信息化

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}");
            }
        }
    }
}

 

posted @ 2025-11-10 09:13  一贴灵  阅读(9)  评论(0)    收藏  举报
学以致用,效率第一