Esempio n. 1
0
        public CommandResult DROP_SCHEMA(IConnectToDB _Connect, string SchemaName)
        {
            CommandResult _result  = new CommandResult();
            ER_Tools      er_tools = new ER_Tools();
            ER_Query      er_query = new ER_Query();
            ER_DML        er_dml   = new ER_DML();

            StringBuilder SQLBuffer = new StringBuilder();

            string _Schema = ER_DB.GetSchema(_Connect);

            SQLBuffer.Append("DROP SCHEMA " + SchemaName);

            string SuccessMessage = "Success " + SchemaName + " has been dropped.";

            _result._Response   = er_query.RUN_NON_QUERY(_Connect, SQLBuffer.ToString(), SuccessMessage).ToString();
            _result._Successful = _result._Response.IndexOf(SuccessMessage) > -1 ? true : false;
            _result._EndTime    = DateTime.Now;

            if (_result._Successful)
            {
                er_dml.DROP_Dictionary_View(_Connect, SchemaName);
            }

            return(_result);
        }