Operations: How to Add a Connection String

public PutConnectionStringOperation(T connectionString)

ConnectionString

public class ConnectionString
{
    public string Name { get; set; } // name of connection string        
}

PutConnectionStringOperation<RavenConnectionString> operation
    = new PutConnectionStringOperation<RavenConnectionString>(
        new RavenConnectionString
        {
            Name = "raven2",
            Database = "Northwind2",
            TopologyDiscoveryUrls = new[]
            {
                "https://rvn2:8080"
            }
        });

PutConnectionStringResult connectionStringResult
    = store.Maintenance.Send(operation);

• RavenConnectionString

  public class RavenConnectionString : ConnectionString
  {
      public string Database { get; set; } // target database name
      public string[] TopologyDiscoveryUrls; // list of server urls
  
      public ConnectionStringType Type => ConnectionStringType.Raven;
  
  }

PutConnectionStringOperation<SqlConnectionString> operation
    = new PutConnectionStringOperation<SqlConnectionString>(
        new SqlConnectionString
        {
            Name = "local_mysql",
            FactoryName = "MySql.Data.MySqlClient",
            ConnectionString = "host=127.0.0.1;user=root;database=Northwind"
        });

PutConnectionStringResult connectionStringResult
    = store.Maintenance.Send(operation);

• SqlConnectionString

  public class SqlConnectionString : ConnectionString
  {
      public string ConnectionString { get; set; }
  
      public string FactoryName { get; set; }
  
      public ConnectionStringType Type => ConnectionStringType.Sql;
  
  }

To a Local Machine

OlapConnectionString olapConnectionString = new OlapConnectionString
{
    Name = (string)connectionStringName,
    LocalSettings = new LocalSettings
    {
        FolderPath = path
    }
};

var resultOlapString = store.Maintenance.Send
    (new PutConnectionStringOperation<OlapConnectionString>(olapConnectionString));

To a Cloud-Based Server

To learn how to connect to a cloud instance, see the Olap ETL article.

The following code sample is for a connection string to Amazon AWS.
If you use the following cloud-based servers, change the parameters accordingly:

• Google
• Azure
• Glacier
• S3
• FTP

var myOlapConnectionString = new OlapConnectionString
{
    Name = "myConnectionStringName",
    S3Settings = new S3Settings
    {
        BucketName = "myBucket",
        RemoteFolderName = "my/folder/name",
        AwsAccessKey = "myAccessKey",
        AwsSecretKey = "myPassword",
        AwsRegionName = "us-east-1"
    }
};

var resultOlapString = store.Maintenance.Send(new PutConnectionStringOperation<OlapConnectionString>(myOlapConnectionString));

• OlapConnectionString

  public class OlapConnectionString : ConnectionString
  {
      public string Name { get; set; }
      public LocalSettings LocalSettings { get; set; }
      public S3Settings S3Settings { get; set; }
      public AzureSettings AzureSettings { get; set; }
      public GlacierSettings GlacierSettings { get; set; }
      public GoogleCloudSettings GoogleCloudSettings { get; set; }
      public FtpSettings FtpSettings { get; set; }
  
      public ConnectionStringType Type => ConnectionStringType.Olap;
  }

// Create a Connection String to Elasticsearch
var elasticSearchConnectionString = new ElasticSearchConnectionString
{
    // Connection String Name
    Name = "ElasticConStr",
    // Elasticsearch Nodes URLs
    Nodes = new[] { "http://localhost:9200" },
    // Authentication Method
    Authentication = new Raven.Client.Documents.Operations.ETL.ElasticSearch.Authentication
    {
        Basic = new BasicAuthentication
        {
            Username = "John",
            Password = "32n4j5kp8"
        }
    }
};

store.Maintenance.Send(new PutConnectionStringOperation<ElasticSearchConnectionString>(elasticSearchConnectionString));

• ElasticSearchConnectionString

  public class ElasticsearchConnectionString : ConnectionString
  {
      public string Name { get; set; }
      public string Nodes { get; set; }
      public string Authentication { get; set; }
      public string Basic { get; set; }
      public string Username { get; set; }
      public string Password { get; set; }
  
      public ConnectionStringType Type => ConnectionStringType.ElasticSearch;
  }