Informix.EntityFramework.Core-lnx 4.1501.2.2026

HCL Informix Entity Framework Core Provider

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

Description

Informix database provider for Entity Framework 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 Entity Framework Core Provider into your project, follow these steps:

1. Install .NET SDK Ensure that you have the .NET SDK installed on your system. You can download it from the official .NET website: https://dotnet.microsoft.com/download You can verify the installation by running: dotnet --version

2. Add Provider Package: Add the Informix EF 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 commands in the terminal:

   dotnet add package Informix.EntityFramework.Core
   dotnet add package Informix.Net.Core --version 4.0.2
   dotnet add package Microsoft.EntityFrameworkCore --version 5.0.17
   dotnet add package Microsoft.EntityFrameworkCore.Relational --version 5.0.17
   

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 EF 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 System.Globalization;
using Microsoft.EntityFrameworkCore;
using Informix.EntityFramework.Core; // Import Informix EF Core Provider

namespace MyConsoleApp
{
    public class MyDbContext : DbContext
    {
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseInformix(
                "Database=dotnetdb;Server=ol_informix1410;User ID=informix;Password=password;");
        }
    }

    class Program
    {
        static void Main(string[] args)
        {
            CultureInfo.DefaultThreadCurrentCulture =
                CultureInfo.CreateSpecificCulture("de-DE");

            try
            {
                using (var dbContext = new MyDbContext())
                {
                    Console.WriteLine("Checking database connection...");

                    bool canConnect = dbContext.Database.CanConnect();

                    if (canConnect)
                    {
                        Console.WriteLine("Connection successful!");
                    }
                    else
                    {
                        Console.WriteLine("Could not connect to database.");
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Connection failed:");
                Console.WriteLine(ex.Message);
            }
        }
    }
}

Running the Application

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

dotnet run

The Informix EF 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/netcoreapp5.0/native/ LD_LIBRARY_PATH=$INFORMIXDIR/lib 
informix@host1:/work$ dotnet run
Checking database connection...
Connection successful!

on Windows use:

d:\work\cs>set PATH=%cd%\bin\Debug\netcoreapp5.0\native\bin;%PATH%
d:\work\work\cs>dotnet run
Checking database connection...
Connection successful!

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 Entity Framewok Core Provider.