Informix.Net.Core-lnx 4.700.7.2021

HCL Informix .NET Core Provider

This README provides a brief overview of the Informix .NET Core Provider and instructions on how to integrate it into your project and run it.

Description

Informix database provider for .NET Core. This package contains all the necessary native libraries and resource files needed for connecting to an Informix database server.

Installation

To integrate the Informix .NET Core Provider into your project, follow these steps:

1. Install .NET Core SDK: Ensure that you have the .NET Core SDK installed on your system. You can download it from the official .NET Core website.

2. Add Provider Package: Add the Informix .NET Core Provider package to your project using your preferred package manager. For example, if you're using NuGet, you can add it by running the following command in the terminal:

   dotnet add package Informix.Net.Core
   

3. Reference Provider in Code: After adding the package, reference the provider in your code where you intend to use it. Import necessary namespaces and classes to access its functionalities.

Usage

Once you've integrated the Informix .NET Core Provider into your project, you can utilize its features according to your requirements. Here's a basic example of how you can use it:

using System;
using Informix.Net.Core; // Import Informix .NET Core Provider

class Program
{
    static void Main(string[] args)
    {
        // Connection string for Informix database
        string connectionString = "Database=sysmaster;Host=host1;Protocol=onsoctcp;Server=ol_informix1410_1;Service=13808;User ID=informix;Password=mypassword";

        // SQL query to select a row from a table
        string query = "SELECT * FROM systables WHERE tabid = ?";

        // ID of the row you want to select
        int tabId = 101; // Change the row ID as per your requirement

        // Create a connection to the Informix database
        using (IfxConnection connection = new IfxConnection(connectionString))
        {
            try
            {
                // Open the database connection
                connection.Open();

                // Create a command to execute the SQL query
                using (IfxCommand command = connection.CreateCommand())
                {
                    // Set the SQL query and parameter values
                    command.CommandText = query;
                    IfxParameter param1 = new IfxParameter(null, IfxType.Integer);
                    param1.Value = tabId;
                    command.Parameters.Add(param1);

                    // Execute the query and retrieve the data
                    using (IfxDataReader reader = command.ExecuteReader())
                    {
                        // Check if there is any data returned
                        if (reader.Read())
                        {
                            // Retrieve data from the reader (change column names as per your database)
                            int id = reader.GetInt32(reader.GetOrdinal("tabid"));
                            string name = reader.GetString(reader.GetOrdinal("tabname"));
                            // Add additional columns as needed

                            // Print the retrieved data
                            Console.WriteLine($"TABID: {id}, TABNAME: {name}");
                        }
                        else
                        {
                            Console.WriteLine("No rows found.");
                        }
                    }
                }
            }
            catch (IfxException ex)
            {
                // Handle any exceptions
                Console.WriteLine($"Informix Exception: {ex.Message}");
            }
            finally
            {
                // Ensure the connection is closed
                connection.Close();
            }
        }
    }
}

Running the Application

To run your application after integrating the Informix .NET Core Provider, execute the following command in the terminal within your project directory:

dotnet run

The Informix .NET Core provider relies on accessing certain native libraries and resource files. Therefore, to execute it, you must define specific environment variables depending on the platform.

On Linux use:

informix@host1:/work$ INFORMIXDIR=bin/Debug/net7.0/native/ LD_LIBRARY_PATH=$INFORMIXDIR/lib dotnet run
TABID: 101, TABNAME: systabnames
informix@host1:/work$ 

on Windows use:

d:\work\cs>set PATH=%cd%\bin\Debug\net7.0\native\bin;%PATH%

d:\work\work\cs>dotnet run
TABID: 101, TABNAME: systabnames
d:\work\cs>

Note: Remember, for Linux systems, set the INFORMIXDIR and LD_LIBRARY_PATH environment variables. On Windows, simply update the PATH variable before executing the "dotnet run" command.

Support

If you encounter any issues or have questions regarding the Informix .NET Core Provider, contact HCL Customer Support

For detailed guidance on effectively utilizing this component, refer to the resources and documentation available at Informix .NET Core Provider.