Example #1
0
        public (bool Success, string Message, DataTable Output) ExecuteSql(string sql)
        {
            SqlType type = GetSqlType(sql);

            switch (type)
            {
            case SqlType.SELECT:
                var queryResult = _dbOperator.UniversalQuery(sql);
                return(queryResult);

            case SqlType.INVALID:
                return(false, "Invalid query!", null);

            default:
                var commandResult = _dbOperator.Execute(sql);
                return(commandResult.Success, commandResult.Message, null);
            }
        }