Beispiel #1
0
        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
            }
        }
Beispiel #2
0
        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
        }