RenanStr
RenanStr

Reputation: 1688

How to create database on OritentDB using OrientDB-NET.binary driver for C#?

I'm starting to learn OrientDB using OrientDB-NET.binary driver for C# and I have successfully configured and ran OrientDB as server.

Now I just tried to run a connection using OClient.CreateDatabasePool as described here https://github.com/yojimbo87/OrientDB-NET.binary/wiki

OClient.CreateDatabasePool(
"127.0.0.1",
2424,
"TestDatabaseName",
ODatabaseType.Graph,
"admin",
"admin",
10,
"myTestDatabaseAlias");

and Im getting this error:

com.orientechnologies.orient.core.exception.OConfigurationException: Database 'TestManualy' is not configured on server (home=E:/orientdb-community-2.1.16/databases/)

Is it possible to create "TestDatabaseName" database using the .NET driver?

If not, how to create database on OritentDB?

I will apreciate some sample code.

Thank you in advance!

Upvotes: 1

Views: 1607

Answers (1)

LucaS
LucaS

Reputation: 1418

I created the following example using OrientDB 2.1.16 and the .NET driver. Main steps:

  1. If TestDatabaseName database already exists, I drop it;
  2. Creating a new TestDatabaseName database;
  3. Connecting and populating it.

C# CODE:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Orient.Client;

namespace OrientTestCreateDB

{
    class CreateDB

    {

    private static string _hostname = "127.0.0.1";
    private static int _port = 2424;
    private static string _rootUserName = "root";
    private static string _rootUserPassword = "root";

    private static OServer _server;

    private static string _DBname = "TestDatabaseName";
    private static string _username = "admin";
    private static string _password = "admin";

    static void Main(string[] args)

    {

        _server = new OServer(_hostname, _port, _rootUserName, _rootUserPassword);

        //If the DB already exists I delete it
        if (_server.DatabaseExist(_DBname, OStorageType.PLocal))

        {

            _server.DropDatabase("TestDatabaseName", OStorageType.PLocal);

            Console.WriteLine("Database " + _DBname + " deleted");

        }

        //Creating the new DB
        _server.CreateDatabase(_DBname, ODatabaseType.Graph, OStorageType.PLocal);

        Console.WriteLine("Database " + _DBname + " created");

        //Connect to the DB and populate it
        OClient.CreateDatabasePool(
        "127.0.0.1",
        2424,
        _DBname,
        ODatabaseType.Graph,
        _username,
        _password,
        10,
        "myTestDatabaseAlias"
        );

        Console.WriteLine("Connected to the DB " + _DBname);

        using (ODatabase database = new ODatabase("myTestDatabaseAlias"))

            {

                database
                     .Create.Class("TestClass")
                     .Extends<OVertex>()
                     .Run();

                OVertex createdVertex = database
                     .Create.Vertex("TestClass")
                     .Set("name", "LucaS")
                     .Run();

                Console.WriteLine("Created vertex with @rid " + createdVertex.ORID);

           }

       }

    }

}

Output:

enter image description here

OrientDB Studio output:

enter image description here

Second connection:

enter image description here

Hope it helps

Upvotes: 3

Related Questions