Operations: How to Get Connection String
-
Get a connection string's properties using the GetConnectionStringsOperation method.
-
To learn how to Create a connection string see: Add Connection String
In this page:
GetConnectionStringsOperation
public GetConnectionStringsOperation()
public GetConnectionStringsOperation(string connectionStringName, ConnectionStringType type)| Parameters | Data Type | Description |
|---|---|---|
| connectionStringName | string |
Connection string name |
| type | ConnectionStringType |
Connection string type: Raven or Sql |
| Type | Return Value | Return Value Type | Description |
|---|---|---|---|
SqlConnectionStrings |
Dictionary<string, SqlConnectionString> | Dictionary which maps sql connection string name to definition | |
RavenConnectionStrings |
Dictionary<string, RavenConnectionString> | Dictionary which maps raven connection string name to definition |
Definitions
RavenConnectionString
A Raven connection string definition:
public class RavenConnectionString : ConnectionString
{
public string Database { get; set; } // target database name
public string[] TopologyDiscoveryUrls; // list of server urls
public ConnectionStringType Type => ConnectionStringType.Raven;
}SqlConnectionString
An Sql connection string definition:
public class SqlConnectionString : ConnectionString
{
public string ConnectionString { get; set; }
public string FactoryName { get; set; }
public ConnectionStringType Type => ConnectionStringType.Sql;
}ConnectionString
A generic connection string definition:
public class ConnectionString
{
public string Name { get; set; } // name of connection string
}
Code Samples
Get all Connection Strings
using (var store = new DocumentStore())
{
GetConnectionStringsOperation operation = new GetConnectionStringsOperation();
GetConnectionStringsResult connectionStrings = store.Maintenance.Send(operation);
Dictionary<string, SqlConnectionString> sqlConnectionStrings = connectionStrings.SqlConnectionStrings;
Dictionary<string, RavenConnectionString> ravenConnectionStrings = connectionStrings.RavenConnectionStrings;
}Get Connection String By Name and Type
using (var store = new DocumentStore())
{
GetConnectionStringsOperation operation =
new GetConnectionStringsOperation("local_mysql", ConnectionStringType.Sql);
GetConnectionStringsResult connectionStrings = store.Maintenance.Send(operation);
Dictionary<string, SqlConnectionString> sqlConnectionStrings = connectionStrings.SqlConnectionStrings;
SqlConnectionString mysqlConnectionString = sqlConnectionStrings["local_mysql"];
}
Related Articles