DBTool for Oracle - Part 1

using System;
using System.Collections.Generic;
using System.Data;
using System.Text;

using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;

using Harlinn.Oracle.DBTool.Types.Common;
using System.Reflection;
using Harlinn.Oracle.DBTool.Utils.DB;
using System.ComponentModel;




namespace Harlinn.Oracle.DBTool.Types.Database
{
    public class DBFields : DBElement
    {
        private static readonly log4net.ILog sfLog = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

        private static void LogException(Exception exc, System.Reflection.MethodBase method)
        {
            Logger.LogException(sfLog, exc, method);
        }

        string qualifiedName;

        public DBFields()
        {
            
        }
        public DBFields(NodeBase parent, string qualifiedName)
            : base(parent, "Fields")
        {
            this.qualifiedName = qualifiedName;
        }

        [Browsable(false)]
        public DBUserTable Table
        {
            get
            {
                DBUserTable result = Parent as DBUserTable;
                return result;
            }
        }

        [Browsable(false)]
        public DBUserView View
        {
            get
            {
                DBUserView result = Parent as DBUserView;
                return result;
            }
        }

        [Browsable(false)]
        public DBField this[string name]
        {
            get
            {
                DBField result = GetChildByName<DBField>(name);
                return result;
            }
        }

        [Browsable(false)]
        public DBField this[int index]
        {
            get
            {
                DBField result = (DBField)Children[index];
                return result;
            }
        }


        public override DBElementType ElementType
        {
            get 
            {
                return DBElementType.Fields;
            }
        }

        public override void Refresh()
        {
            try
            {
                base.Refresh();

                OracleConnection connection = ConnectionManager.Connection;
                OracleCommand command = connection.CreateCommand();
                using (command)
                {
                    command.CommandText = "SELECT * FROM " + qualifiedName;
                    OracleDataReader reader = command.ExecuteReader(CommandBehavior.SchemaOnly | CommandBehavior.KeyInfo);
                    using (reader)
                    {
                        DataTable schemaInfo = reader.GetSchemaTable();
                        foreach (DataRow fieldDefinition in schemaInfo.Rows)
                        {
                            DBField field = new DBField(this, fieldDefinition);
                            Children.Add(field);
                        }
                    }
                }
            }
            catch (Exception exc)
            {
                LogException(exc, MethodBase.GetCurrentMethod());
                //throw;
            }
        }

    }
}