public ConnectionStrings() { using (var store = new DocumentStore()) { #region add_raven_connection_string PutConnectionStringOperation <RavenConnectionString> operation = new PutConnectionStringOperation <RavenConnectionString>( new RavenConnectionString { Name = "raven2", Database = "Northwind2", TopologyDiscoveryUrls = new[] { "http://rvn2:8080" } }); PutConnectionStringResult connectionStringResult = store.Maintenance.Send(operation); #endregion } using (var store = new DocumentStore()) { #region add_sql_connection_string 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); #endregion } using (var store = new DocumentStore()) { #region get_all_connection_strings GetConnectionStringsOperation operation = new GetConnectionStringsOperation(); GetConnectionStringsResult connectionStrings = store.Maintenance.Send(operation); Dictionary <string, SqlConnectionString> sqlConnectionStrings = connectionStrings.SqlConnectionStrings; Dictionary <string, RavenConnectionString> ravenConnectionStrings = connectionStrings.RavenConnectionStrings; #endregion } using (var store = new DocumentStore()) { #region get_connection_string_by_name 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"]; #endregion } using (var store = new DocumentStore()) { RavenConnectionString connectionString = null; #region remove_raven_connection_string RemoveConnectionStringOperation <RavenConnectionString> operation = new RemoveConnectionStringOperation <RavenConnectionString>( connectionString); store.Maintenance.Send(operation); #endregion } using (var store = new DocumentStore()) { SqlConnectionString connectionString = null; #region remove_sql_connection_string RemoveConnectionStringOperation <SqlConnectionString> operation = new RemoveConnectionStringOperation <SqlConnectionString>( connectionString); store.Maintenance.Send(operation); #endregion } }
public ConnectionStrings() { using (var store = new DocumentStore()) { #region add_raven_connection_string PutConnectionStringOperation <RavenConnectionString> operation = new PutConnectionStringOperation <RavenConnectionString>( new RavenConnectionString { Name = "raven2", Database = "Northwind2", TopologyDiscoveryUrls = new[] { // Be sure to include the "s" in https for secure servers. "https://rvn2:8080" } }); PutConnectionStringResult connectionStringResult = store.Maintenance.Send(operation); #endregion } using (var store = new DocumentStore()) { #region add_sql_connection_string 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); #endregion } #region 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; } #endregion #region get_connection_string_by_name 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"]; } #endregion using (var store = new DocumentStore()) { RavenConnectionString connectionString = null; #region remove_raven_connection_string RemoveConnectionStringOperation <RavenConnectionString> operation = new RemoveConnectionStringOperation <RavenConnectionString>( connectionString); store.Maintenance.Send(operation); #endregion } using (var store = new DocumentStore()) { SqlConnectionString connectionString = null; #region remove_sql_connection_string RemoveConnectionStringOperation <SqlConnectionString> operation = new RemoveConnectionStringOperation <SqlConnectionString>( connectionString); store.Maintenance.Send(operation); #endregion } using (var store = new DocumentStore()) #region raven_etl_connection_string { //define connection string var ravenConnectionString = new RavenConnectionString() { //name connection string Name = "raven-connection-string-name", //define appropriate node //Be sure that the node definition in the connection string has the "s" in https TopologyDiscoveryUrls = new[] { "https://127.0.0.1:8080" }, //define database to connect with on the node Database = "Northwind", }; //create the connection string var resultRavenString = store.Maintenance.Send( new PutConnectionStringOperation <RavenConnectionString>(ravenConnectionString)); } #endregion using (var store = new DocumentStore()) #region sql_etl_connection_string { // define new connection string PutConnectionStringOperation <SqlConnectionString> operation = new PutConnectionStringOperation <SqlConnectionString>( new SqlConnectionString { // name connection string Name = "local_mysql", // define FactoryName FactoryName = "MySql.Data.MySqlClient", // define database - may also need to define authentication and encryption parameters // by default, encrypted databases are sent over encrypted channels ConnectionString = "host=127.0.0.1;user=root;database=Northwind" }); // create connection string PutConnectionStringResult connectionStringResult = store.Maintenance.Send(operation); } #endregion }