Skip to content

oracle/nosql-dotnet-sdk

.NET SDK for Oracle NoSQL Database

Overview

This is the .NET SDK for the Oracle NoSQL Database. The SDK provides interfaces, documentation, and examples to develop .NET applications that use the Oracle NoSQL Database Cloud Service and the On-Premise Oracle NoSQL Database.

Prerequisites

Installation

You may install this SDK either as a dependency of your project or in a separate directory. To install as a dependency of your project, cd to the directory containing your .Net project file and run:

dotnet add package Oracle.NoSQL.SDK

Alternatively, you may install the SDK independently into a directory of your choice by using nuget.exe CLI:

nuget.exe install Oracle.NoSQL.SDK -OutputDirectory <your-packages-directory>

Documentation

See the API and user guide documentation.

Changes

See Changelog for changes in each release.

Getting Started

The SDK API classes are in Oracle.NoSQL.SDK namespace.

using Oracle.NoSQL.SDK;

Connecting to Oracle NoSQL Database

To perform database operations, you need to create an instance of NoSQLClient.

Connecting to Oracle NoSQL Database Cloud Service

Running against the Cloud Service requires an Oracle Cloud account. See Configuring for the Cloud Service for information on getting an account and acquiring required credentials.

  1. Collect the following information:
  • Tenancy ID
  • User ID
  • API signing key (private key file in PEM format)
  • Fingerprint for the public key uploaded to the user's account
  • Private key passphrase, needed only if the private key is encrypted
  1. Decide on the region you want to use.

  2. Create NoSQLClient as follows, by substituting the values as indicated below:

var client = new NoSQLClient(
    new NoSQLConfig
    {
        Region = Region.<your-region-here>,
        AuthorizationProvider = new IAMAuthorizationProvider(
            new IAMCredentials
            {
                TenantId = "your tenancy OCID",
                UserId = "your user OCID",
                Fingerprint = "your public key fingerprint",
                PrivateKeyFile = "path to private key file",
                Passphrase = "passphrase if set for your private key"
            })
    });

Alternatively, you may put the credentials into an OCI configuration file. See Using a Configuration File. Put your credentials in a file ~/.oci/config (on Windows ~ stands for %USERPROFILE%) under profile named DEFAULT. Include your region together with the credentials. Then create NoSQLClient as follows:

var client = new NoSQLClient();

Connecting to Oracle NoSQL Cloud Simulator

Running against the Oracle NoSQL Cloud Simulator requires a running Cloud Simulator instance. See Using the Cloud Simulator for information on how to download and start the Cloud Simulator.

By default, Cloud Simulator runs on localhost and uses HTTP port 8080.

Create NoSQLClient as follows:

var client = new NoSQLClient(
    new NoSQLConfig
    {
        ServiceType = ServiceType.CloudSim,
        Endpoint = "localhost:8080"
    });

Connecting to On-Premise Oracle NoSQL Database

Running against the Oracle NoSQL Database on-premise requires a running Oracle NoSQL Database instance as well as a running NoSQL Proxy server instance. Your application will connect to the proxy server.

See Connecting to an On-Premise Oracle NoSQL Database for information on how to download and start the database instance and proxy server.

To get started, start the proxy in non-secure mode. By default, it runs on localhost and uses HTTP port 80.

Create NoSQLClient as follows:

var client = new NoSQLClient(
    new NoSQLConfig
    {
        ServiceType = ServiceType.KVStore,
        Endpoint = "localhost:80"
    });

If the proxy was started on a different host or port, change Endpoint accordingly.

A more complex setup is required to use the proxy in secure mode. See Configuring the SDK for a Secure Store.

Using Oracle NoSQL Database

The following example creates a table, inserts a row, reads a row, deletes a row and drops the table:

var tableName = "orders";

// Create a table
var tableResult = await client.ExecuteTableDDLWithCompletionAsync(
    $"CREATE TABLE IF NOT EXISTS {tableName}(id LONG, description STRING, " +
    "details JSON, PRIMARY KEY(id))", new TableLimits(1, 5, 1));
Console.WriteLine("Table {0} created, table state is {1}",
    tableName, tableResult.TableState);

// Put a row
var putResult = await client.PutAsync(TableName, new MapValue
{
    ["id"] = 1000,
    ["description"] = "building materials",
    ["details"] = new MapValue
    {
        ["total"] = 1000.00,
        ["quantity"] = new MapValue
        {
            ["nails"] = 500,
            ["pliers"] = 100,
            ["tape"] = 50
        }
    }
});

if (putResult.ConsumedCapacity != null)
{
    Console.WriteLine("Put used: {0}", putResult.ConsumedCapacity);
}

var primaryKey = new MapValue
{
    ["id"] = 1000
};

// Get a row
var getResult = await client.GetAsync(TableName, primaryKey);
if (getResult.Row != null)
{
    Console.WriteLine("Got row: {0}\n", getResult.Row.ToJsonString());
}
else
{
    Console.WriteLine("Row with primaryKey {0} doesn't exist",
    primaryKey.ToJsonString());
}

// Delete a row
var deleteResult = await client.DeleteAsync(tableName, primaryKey);
Console.WriteLine("Delete {0}.",
    deleteResult.Success ? "succeeded", "failed");

// Drop a table
tableResult = await client.ExecuteTableDDLWithCompletionAsync(
    $"DROP TABLE {tableName}");
Console.WriteLine("Table {0} dropped, table state is {1}",
    tableName, tableResult.TableState);

Examples

Examples are located under Oracle.NoSQL.SDK.Samples directory. In Visual Studio, you can open the examples solution Oracle.NoSQL.SDK.Samples.sln. Each example is in its own sub-directory and has its project file and the main program Program.cs.

You can run the examples

  • Against the Oracle NoSQL Database Cloud Service using your Oracle Cloud account and credentials.
  • Locally using the Oracle NoSQL Database Cloud Simulator.
  • Against On-Premise Oracle NoSQL Database via the proxy.

Each example takes one command line argument which is the path to the JSON configuration file used to create NoSQLClient instance.

Note: you may omit this command line argument if running against the cloud service and using default OCI configuration file. See Example Quick Start.

Use configuration file templates provided in Oracle.NoSQL.SDK.Samples directory. Make a copy of the template, fill in the appropriate values and remove unused properties. The following templates are provided:

  • cloud_template.json is used to access a cloud service instance and allows you to customize configuration. Copy that file and fill in appropriate values as described in Supply Credentials to the Application.
  • cloudsim.json is used if you are running against the cloud simulator. You may use this file directly as config file if you are running the cloud simulator on localhost on port 8080. If the cloud simulator has been started on a different host or port, change the endpoint. See Using the Cloud Simulator.
  • kvstore_template.json is used to access on-premise NoSQL Database via the proxy. Copy that file and fill in appropriate values as described in Configuring the SDK. Also see Example Quick Start.

To run an example, go to the example's directory and issue dotnet run command, providing JSON config file as the command line argument:

cd Oracle.NoSQL.SDK.Samples/<example>
dotnet run -f <target-framework> [-- /path/to/config.json]

where is the example directory and is the target framework moniker, supported values are net7.0, net6.0, net5.0 and netcoreapp3.1. The command above will build and run the example.

For example:

cd Oracle.NoSQL.SDK.Samples/BasicExample
dotnet run -f net5.0 -- my_config.json

Help

When requesting help please be sure to include as much detail as possible, including version of the SDK and simple, standalone example code as needed.

License

Please see the LICENSE file included in the top-level directory of the package for a copy of the license and additional information.

The THIRD_PARTY_LICENSES file contains third party notices and licenses.

The THIRD_PARTY_LICENSES_DEV file contains third party notices and licenses for running the test programs.

The Documentation directory contains the license files for the documentation. If you build and distribute a documentation bundle, these should be included in that bundle.

Contributing

This project welcomes contributions from the community. Before submitting a pull request, please review our contribution guide

Security

Please consult the security guide for our responsible security vulnerability disclosure process