C# sample program for.NET Core Provider to demonstrate retrieval/RecordSet of data from OneDB Server

• In the command prompt run “dotnet build”.
• It will create the binaries for the sample program.
• You can run the binary “dotnet <name of the DLL created in the ‘dotnet build’ phase>”
• The program will display the data and number of records it fetched from the database on its successful execution.
• You can refer below image for actual outputs in the environment where its executed.

using System;
using System.Data;
using Informix.Net.Core;
class TestClass
{
static void Main(string[] args)
{
IfxConnection conn = null;
int rows = 0;
String value = "";
Console.WriteLine("OneDB .NET Core Provider test");
conn = new IfxConnection("Server=onedb_6;User ID=informix;password=xxxx;Database=sysmaster;");
conn.Open();
IfxCommand Selcmd = conn.CreateCommand();
Selcmd.CommandText = "select tabname from systables where tabid<5;";
Selcmd.CommandType = CommandType.Text;
Selcmd.Connection = conn;
IfxDataReader DReader = Selcmd.ExecuteReader();
while (DReader.Read())
{
rows++;
value = DReader[0].ToString();
Console.WriteLine("Value: " + value);
}
Console.WriteLine("Number of Rows Retrieved: " + rows);
DReader.Close();
conn.Close();
conn.Dispose();
}
}