How to make connection to Sap b1 Hana database.

Hi @Ramco Ramco,

To connect to the SAP B1 HANA database using the Sap.Data.Hana namespace in .NET, you will need to utilize the HanaConnection class. Below is a concise example demonstrating how to establish this connection:

using Sap.Data.Hana;
using System;

class Program
{
    static void Main()
    {
        string connectionString = "Server=your_server;Port=30015;UserID=your_user;Password=your_password;Database=your_database;";
        
        using (HanaConnection connection = new HanaConnection(connectionString))
        {
            try
            {
                connection.Open();
                Console.WriteLine("Connection to SAP B1 HANA database established successfully.");
            }
            catch (Exception ex)
            {
                Console.WriteLine($"Error: {ex.Message}");
            }
            finally
            {
                connection.Close();
                Console.WriteLine("Connection closed.");
            }
        }
    }
}

In this example, replace your_server, your_user, your_password, and your_database with your actual database credentials. This code snippet opens a connection to the SAP B1 HANA database, handles exceptions, and ensures the connection is closed properly.