Exemplo n.º 1
0
 internal bool Initialize(ConnectionOptions connectionOptions)
 {
     this.connectionOptions = connectionOptions;
     if (connectionOptions.serverName == null)
     {
         if (false) //ProgramInfo.InSQLMode
         {
             string[] localInstances = null;
             try
             {
                 localInstances = SqlServerEnumerator.GetLocalInstances();
             }
             catch (Exception)
             {
             }
             if ((localInstances != null) && (localInstances.Length > 0))
             {
                 this.connectionOptions.serverName = localInstances[0];
             }
             else
             {
                 this.connectionOptions.serverName = ".";
             }
         }
         else
         {
             this.connectionOptions.serverName = @".\SQLEXPRESS";
         }
     }
     if (connectionOptions.promptForPassword)
     {
         //try
         //{
         //  this.connectionOptions.password = ConsoleUtil.PromptForPassword("Enter password for user '" + connectionOptions.userName + "': ");
         //  Console.WriteLine("");
         //}
         //catch (UserCanceledException)
         //{
         //  return false;
         //}
     }
     if (!string.IsNullOrEmpty(connectionOptions.runningAs) && !connectionOptions.useMainInstance)
     {
         IDbConnection connection = this.BuildMasterConnection(true);
         string str = "SELECT owning_principal_name, instance_pipe_name FROM sys.dm_os_child_instances";
         IDbCommand command = DataUtil.CreateCommand(this, connection);
         command.CommandText = str;
         connection.Open();
         try
         {
             SqlDataReader reader = (SqlDataReader)command.ExecuteReader();
             if (reader != null)
             {
                 try
                 {
                     if (reader.HasRows)
                     {
                         int ordinal = reader.GetOrdinal("owning_principal_name");
                         int num2 = reader.GetOrdinal("instance_pipe_name");
                         while (reader.Read())
                         {
                             if (string.Equals(reader.GetString(ordinal), connectionOptions.runningAs, StringComparison.OrdinalIgnoreCase))
                             {
                                 string str3 = reader.GetString(num2);
                                 if (this.originalServerName == null)
                                 {
                                     Console.WriteLine("Using instance '" + str3 + "'.");
                                     Console.WriteLine("");
                                     this.originalServerName = connectionOptions.serverName;
                                     this.connectionOptions.serverName = str3;
                                     this.connectionOptions.useMainInstance = true;
                                 }
                                 else
                                 {
                                     Console.WriteLine("Multiple child instances were found to run under the principal name you specified. The first one will be used.");
                                 }
                             }
                         }
                     }
                     if (this.originalServerName == null)
                     {
                         throw new Exception("No child instance is running under the principal name you specified.");
                     }
                 }
                 finally
                 {
                     reader.Close();
                 }
             }
         }
         finally
         {
             connection.Close();
         }
     }
     return true;
 }
Exemplo n.º 2
0
        internal static void DetachDatabase(string database)
        {
            ConnectionOptions connectionOptions = new ConnectionOptions();
            ConnectionManager connectionManager = new ConnectionManager();
            connectionManager.Initialize(connectionOptions);

            if (string.IsNullOrEmpty(database))
            {
                throw new Exception("Detach requires a file path or database name (within brackets).");
            }
            bool flag = false;
            DatabaseIdentifier identifier = DatabaseIdentifier.Parse(database);
            database = identifier.Value;
            if (identifier.IsDatabaseName)
            {
                if (string.IsNullOrEmpty(database))
                {
                    throw new Exception("Invalid database name specified.");
                }
            }
            else
            {
                if (database.EndsWith("*"))
                {
                    database = database.Substring(0, database.Length - 1);
                    flag = true;
                }
                database = PathUtil.EnsureFullPath(database);
            }
            IDbConnection connection = connectionManager.BuildMasterConnection();
            connection.Open();
            try
            {
                List<DatabaseInfo> list = DataUtil.BuildDatabaseInfoList(connectionManager, connection);
                if (list != null)
                {
                    bool flag2 = false;
                    foreach (DatabaseInfo info in list)
                    {
                        bool flag3 = false;
                        try
                        {
                            if (identifier.IsDatabaseName)
                            {
                                if (string.Equals(database, info.Name, StringComparison.OrdinalIgnoreCase))
                                {
                                    flag3 = true;
                                }
                            }
                            else
                            {
                                string b = PathUtil.EnsureFullPath(info.Path);
                                if (flag)
                                {
                                    if (b.StartsWith(database, StringComparison.OrdinalIgnoreCase))
                                    {
                                        flag3 = true;
                                    }
                                }
                                else if (string.Equals(database, b, StringComparison.OrdinalIgnoreCase))
                                {
                                    flag3 = true;
                                }
                            }
                            if (flag3 &&
                                    (((string.Compare(info.Name, "master", StringComparison.OrdinalIgnoreCase) == 0) ||
                                        (string.Compare(info.Name, "tempdb", StringComparison.OrdinalIgnoreCase) == 0)) ||
                                     ((string.Compare(info.Name, "model", StringComparison.OrdinalIgnoreCase) == 0) ||
                                        (string.Compare(info.Name, "msdb", StringComparison.OrdinalIgnoreCase) == 0))))
                            {
                                Console.WriteLine("Warning: Not detaching system database '{0}'. Use SQL commands in the console to do it.",
                                                                    info.Name);
                                flag3 = false;
                            }
                        }
                        catch
                        {
                        }
                        if (flag3)
                        {
                            DataUtil.DetachDatabase(connectionManager, connection, info.Name, false);
                            flag2 = true;
                        }
                    }
                    if (!flag2)
                    {
                        if (identifier.IsDatabaseName)
                        {
                            Console.WriteLine("No valid database name matches the value specified.");
                        }
                        else
                        {
                            Console.WriteLine("No valid database path matches the value specified.");
                        }
                    }
                }
            }
            finally
            {
                connection.Close();
            }
        }