GridGain.Ignite 9.0.6

Prefix Reserved
There is a newer version of this package available.
See the version list below for details.
dotnet add package GridGain.Ignite --version 9.0.6                
NuGet\Install-Package GridGain.Ignite -Version 9.0.6                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="GridGain.Ignite" Version="9.0.6" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add GridGain.Ignite --version 9.0.6                
#r "nuget: GridGain.Ignite, 9.0.6"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install GridGain.Ignite as a Cake Addin
#addin nuget:?package=GridGain.Ignite&version=9.0.6

// Install GridGain.Ignite as a Cake Tool
#tool nuget:?package=GridGain.Ignite&version=9.0.6                

Apache Ignite 3 .NET Client

.NET client for Apache Ignite - a distributed database for high‑performance applications with in‑memory speed.

Key Features

  • Full support of all Ignite APIs: SQL, Transactions, Key/Value, Compute.
  • Connects to any number of Ignite nodes at the same time.
  • Partition awareness: sends key-based requests to the right node.
  • Load-balancing, failover, automatic reconnection and request retries.
  • Built-in LINQ provider for strongly-typed SQL queries.
  • Integrates with NodaTime to provide precise mapping to Ignite date/time types.
  • Logging and metrics.
  • High performance and fully asynchronous.

Getting Started

Below are a few examples of basic usage to get you started:

// Connect to the cluster.
var cfg = new IgniteClientConfiguration("127.0.0.1:10800");
IIgniteClient client = await IgniteClient.StartAsync(cfg);

// Start a read-only transaction.
await using var tx = await client.Transactions.BeginAsync(
    new TransactionOptions { ReadOnly = true });

// Get table by name.
ITable? table = await client.Tables.GetTableAsync("Person");

// Get a strongly-typed view of table data using Person record.
IRecordView<Person> view = table!.GetRecordView<Person>();

// Upsert a record with KV (NoSQL) API.
await view.UpsertAsync(tx, new Person(1, "John"));

// Query data with SQL.
await using var resultSet = await client.Sql.ExecuteAsync<Person>(
    tx, "SELECT * FROM Person");
    
List<Person> sqlResults = await resultSet.ToListAsync();

// Query data with LINQ.
List<string> names  = view.AsQueryable(tx)
    .OrderBy(person => person.Name)
    .Select(person => person.Name)
    .ToList();

// Execute a distributed computation.
IList<IClusterNode> nodes = await client.GetClusterNodesAsync();
int wordCount = await client.Compute.ExecuteAsync<int>(
    nodes, "org.foo.bar.WordCountTask", "Hello, world!");

API Walkthrough

Configuration

IgniteClientConfiguration is used to configure connections properties (endpoints, SSL), retry policy, logging, and timeouts.

var cfg = new IgniteClientConfiguration
{
    // Connect to multiple servers.
    Endpoints = { "server1:10800", "server2:10801" },

    // Enable TLS.
    SslStreamFactory = new SslStreamFactory
    {
        SslClientAuthenticationOptions = new SslClientAuthenticationOptions
        {
            // Allow self-signed certificates.
            RemoteCertificateValidationCallback = 
                (sender, certificate, chain, errors) => true
        }
    },    
        
    // Retry all read operations in case of network issues.
    RetryPolicy = new RetryReadPolicy { RetryLimit = 32 }
};

SQL

SQL is the primary API for data access. It is used to create, drop, and query tables, as well as to insert, update, and delete data.

using var client = await IgniteClient.StartAsync(new("localhost"));

await client.Sql.ExecuteAsync(
    null, "CREATE TABLE Person (Id INT PRIMARY KEY, Name VARCHAR)");

await client.Sql.ExecuteAsync(
    null, "INSERT INTO Person (Id, Name) VALUES (1, 'John Doe')");

await using var resultSet = await client.Sql.ExecuteAsync(
    null, "SELECT Name FROM Person");

await foreach (IIgniteTuple row in resultSet)
    Console.WriteLine(row[0]);

Mapping SQL Results to User Types

SQL results can be mapped to user types using ExecuteAsync<T> method. This is cleaner and more efficient than IIgniteTuple approach above.

await using var resultSet = await client.Sql.ExecuteAsync<Person>(
    null, "SELECT Name FROM Person");
    
await foreach (Person p in resultSet)
    Console.WriteLine(p.Name);
    
public record Person(int Id, string Name);

Column names are matched to record properties by name. To map columns to properties with different names, use ColumnAttribute.

DbDataReader (ADO.NET API)

Another way to work with query results is System.Data.Common.DbDataReader, which can be obtained with ExecuteReaderAsync method.

For example, you can bind query results to a DataGridView control:

await using var reader = await Client.Sql.ExecuteReaderAsync(
    null, "select * from Person");

var dt = new DataTable();
dt.Load(reader);

dataGridView1.DataSource = dt;

NoSQL

NoSQL API is used to store and retrieve data in a key/value fashion. It can be more efficient than SQL in certain scenarios. Existing tables can be accessed, but new tables can only be created with SQL.

First, get a table by name:

ITable? table = await client.Tables.GetTableAsync("Person");

Then, there are two ways to look at the data.

Record View

Record view represents the entire row as a single object. It can be an IIgniteTuple or a user-defined type.

IRecordView<IIgniteTuple> binaryView = table.RecordBinaryView;
IRecordView<Person> view = table.GetRecordView<Person>();

await view.UpsertAsync(null, new Person(1, "John"));

KeyValue View

Key/Value view splits the row into key and value parts.

IKeyValueView<IIgniteTuple, IIgniteTuple> kvBinaryView = table.KeyValueBinaryView;
IKeyValueView<PersonKey, Person> kvView = table.GetKeyValueView<PersonKey, Person>();

await kvView.PutAsync(null, new PersonKey(1), new Person("John"));

LINQ

Data can be queried and modified with LINQ using AsQueryable method. LINQ expressions are translated to SQL queries and executed on the server.

ITable? table = await client.Tables.GetTableAsync("Person");
IRecordView<Person> view = table!.GetRecordView<Person>();

IQueryable<string> query = view.AsQueryable()
    .Where(p => p.Id > 100)
    .Select(p => p.Name);

List<string> names = await query.ToListAsync();

Generated SQL can be retrieved with ToQueryString extension method, or by enabling debug logging.

Bulk update and delete with optional conditions are supported via ExecuteUpdateAsync and ExecuteDeleteAsync extensions methods on IQueryable<T>

Transactions

All operations on data in Ignite are transactional. If a transaction is not specified, an explicit transaction is started and committed automatically.

To start a transaction, use ITransactions.BeginAsync method. Then, pass the transaction object to all operations that should be part of the same transaction.

ITransaction tx = await client.Transactions.BeginAsync();

await view.UpsertAsync(tx, new Person(1, "John"));

await client.Sql.ExecuteAsync(
    tx, "INSERT INTO Person (Id, Name) VALUES (2, 'Jane')");

await view.AsQueryable(tx)
    .Where(p => p.Id > 0)
    .ExecuteUpdateAsync(p => new Person(p.Id, p.Name + " Doe"));

await tx.CommitAsync();

Compute

Compute API is used to execute distributed computations on the cluster. Compute jobs should be implemented in Java, deployed to server nodes, and called by the full class name.

IList<IClusterNode> nodes = await client.GetClusterNodesAsync();
string result = await client.Compute.ExecuteAsync<string>(
    nodes, "org.acme.tasks.MyTask", "Task argument 1", "Task argument 2");

Failover, Retry, Reconnect, Load Balancing

Ignite client implements a number of features to improve reliability and performance:

  • When multiple endpoints are configured, the client will maintain connections to all of them, and load balance requests between them.
  • If a connection is lost, the client will try to reconnect, assuming it may be a temporary network issue or a node restart.
  • Periodic heartbeat messages are used to detect connection issues early.
  • If a user request fails due to a connection issue, the client will retry it automatically according to the configured IgniteClientConfiguration.RetryPolicy.

Logging

To enable logging, set IgniteClientConfiguration.LoggerFactory property. It uses the standard Microsoft.Extensions.Logging API.

For example, to log to console (requires Microsoft.Extensions.Logging.Console package):

var cfg = new IgniteClientConfiguration
{
    LoggerFactory = LoggerFactory.Create(builder => builder.AddConsole().SetMinimumLevel(LogLevel.Debug))
};

Or with Serilog (requires Serilog.Extensions.Logging and Serilog.Sinks.Console packages):

var cfg = new IgniteClientConfiguration
{
    LoggerFactory = LoggerFactory.Create(builder =>
        builder.AddSerilog(new LoggerConfiguration()
            .MinimumLevel.Debug()
            .WriteTo.Console()
            .CreateLogger()))
};

Metrics

Ignite client exposes a number of metrics with Apache.Ignite meter name through the System.Diagnostics.Metrics API that can be used to monitor system health and performance.

For example, dotnet-counters tool can be used like this:

dotnet-counters monitor --counters Apache.Ignite,System.Runtime --process-id PID

Documentation

Full documentation is available at https://ignite.apache.org/docs.

Feedback

Use any of the following channels to provide feedback:

Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (7)

Showing the top 5 NuGet packages that depend on GridGain.Ignite:

Package Downloads
GridGain.Ignite.Linq

Apache Ignite LINQ Provider. Query distributed in-memory data in a strongly-typed manner and with IDE support. All Ignite SQL features are supported: distributed joins, groupings, aggregates, field queries, and more.

GridGain

The GridGain In-Memory Computing Platform, built on Apache Ignite, enables you to dramatically accelerate and scale out your existing data-intensive applications without ripping and replacing your existing databases.

GridGain.Ignite.NLog

Apache Ignite NLog Logger.

GridGain.Ignite.Log4Net

Apache Ignite log4net Logger.

GridGain.Ignite.AspNet

Apache Ignite ASP.NET Integration. Output Cache Provider: caches page output in a distributed in-memory cache. Session State Store Provider: stores session state data in a distributed in-memory cache.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
9.0.8 79 10/30/2024
9.0.7 104 10/8/2024
9.0.6 97 9/24/2024
9.0.5 109 9/9/2024
9.0.4 86 8/28/2024
9.0.3 123 8/15/2024
9.0.2 77 7/31/2024
9.0.1 167 7/18/2024
9.0.0-g4d770d8f1f 83 7/9/2024
8.9.14 36 11/7/2024
8.9.13 270 10/24/2024
8.9.12 354 10/9/2024
8.9.11 378 9/12/2024
8.9.10 889 8/16/2024
8.9.9 1,029 7/26/2024
8.9.8 399 7/19/2024
8.9.7.1 401 9/11/2024
8.9.7 487 6/14/2024
8.9.6 455 5/29/2024
8.9.5 777 5/10/2024
8.9.4 622 4/18/2024
8.9.3 609 3/15/2024
8.9.2 762 2/28/2024
8.9.1.1 447 6/6/2024
8.9.1 645 1/19/2024
8.9.0.1 2,387 10/23/2023
8.9.0 682 10/4/2023
8.8.43 254 9/26/2024
8.8.42 265 8/5/2024
8.8.41 289 6/12/2024
8.8.40 368 5/29/2024
8.8.39 416 4/8/2024
8.8.38 394 2/9/2024
8.8.37.1 317 1/24/2024
8.8.37 661 12/29/2023
8.8.36 450 12/6/2023
8.8.35 2,910 11/3/2023
8.8.34 1,544 9/20/2023
8.8.33 685 8/25/2023
8.8.32 736 8/9/2023
8.8.31 5,258 6/27/2023
8.8.30 1,433 5/25/2023
8.8.29 788 5/5/2023
8.8.28 5,206 4/19/2023
8.8.27 3,557 3/16/2023
8.8.26 1,189 2/27/2023
8.8.25.1 2,970 2/9/2023
8.8.25 995 2/7/2023
8.8.24 2,748 12/30/2022
8.8.23.3 1,030 2/9/2023
8.8.23.2 1,138 2/8/2023
8.8.23.1 1,344 12/6/2022
8.8.23 1,362 11/29/2022
8.8.22.2 689 4/25/2023
8.8.22.1 2,392 11/15/2022
8.8.22 1,850 9/29/2022
8.8.21 4,768 8/31/2022
8.8.20 2,076 7/15/2022
8.8.19.1 1,257 12/6/2022
8.8.19 3,565 5/30/2022
8.8.18.1 1,857 7/7/2022
8.8.18 2,019 5/4/2022
8.8.17 3,196 3/25/2022
8.8.16.1 2,098 3/15/2022
8.8.16 2,212 2/24/2022
8.8.15 2,475 2/11/2022
8.8.14 2,248 1/28/2022
8.8.13.2 2,176 2/17/2022
8.8.13.1 2,178 1/24/2022
8.8.13 2,358 12/27/2021
8.8.12 1,268 12/17/2021
8.8.11 2,173 11/29/2021
8.8.10 1,951 10/22/2021
8.8.9.1 1,467 10/11/2021
8.8.9 1,577 10/4/2021
8.8.8.1 1,245 11/12/2021
8.8.8 1,672 9/9/2021
8.8.7 2,589 7/30/2021
8.8.6 1,761 7/1/2021
8.8.5 2,233 5/28/2021
8.8.4 1,795 4/23/2021
8.8.3 2,173 3/24/2021
8.8.2.1 1,339 10/8/2021
8.8.2 1,876 2/8/2021
8.8.1 1,854 12/24/2020
8.7.43 2,134 1/31/2022
8.7.42.2 2,094 3/15/2022
8.7.42.1 2,195 2/8/2022
8.7.42 1,131 12/27/2021
8.7.41 1,092 12/17/2021
8.7.40 1,845 12/9/2021
8.7.39.3 633 6/6/2023
8.7.39.1 1,973 6/16/2022
8.7.39 1,402 9/10/2021
8.7.38 1,448 7/30/2021
8.7.37 1,382 7/2/2021
8.7.36 1,416 5/26/2021
8.7.35 1,428 4/27/2021
8.7.34 1,357 3/1/2021
8.7.33.3 1,356 8/20/2021
8.7.33.2 1,379 2/20/2021
8.7.33.1 1,355 2/9/2021
8.7.33 1,497 1/21/2021
8.7.32.3 1,222 11/4/2021
8.7.32 2,596 12/4/2020
8.7.31 1,420 11/19/2020
8.7.30 1,636 11/10/2020
8.7.29.1 1,383 11/12/2020
8.7.29 1,518 10/26/2020
8.7.28 1,784 10/13/2020
8.7.27.1 1,521 11/9/2020
8.7.27 1,648 9/30/2020
8.7.26 1,681 9/11/2020
8.7.25 1,451 8/31/2020
8.7.24 1,461 8/19/2020
8.7.23 1,670 8/3/2020
8.7.22 1,530 7/21/2020
8.7.21 1,601 7/10/2020
8.7.20 1,652 6/23/2020
8.7.19 1,590 6/5/2020
8.7.18 1,575 6/1/2020
8.7.17 1,573 5/26/2020
8.7.16 1,531 5/12/2020
8.7.15 1,556 4/23/2020
8.7.14 1,592 3/27/2020
8.7.13 1,495 3/18/2020
8.7.12 1,497 2/18/2020
8.7.11 1,787 2/6/2020
8.7.10 2,226 1/1/2020
8.7.9 1,948 12/19/2019
8.7.8 2,020 12/5/2019
8.7.7 2,168 11/5/2019
8.7.6 2,146 8/12/2019