private ColumnInfo GetColumn(XmlNode xnColumn, TableInfo ownerTable)
        {
            ColumnInfo mColumn = new ColumnInfo(ownerTable);
            XmlElement xe      = (XmlElement)xnColumn;

            mColumn.ColumnId = xe.GetAttribute("Id");
            XmlNodeList xnCProperty = xe.ChildNodes;

            foreach (XmlNode xnP in xnCProperty)
            {
                switch (xnP.Name)
                {
                case "a:ObjectID":
                    mColumn.ObjectId = xnP.InnerText;
                    break;

                case "a:Name":
                    mColumn.Name = xnP.InnerText;
                    break;

                case "a:Code":
                    mColumn.Code = xnP.InnerText;
                    break;

                case "a:CreationDate":
                    mColumn.CreationDate = String2DateTime(xnP.InnerText);
                    break;

                case "a:Creator":
                    mColumn.Creator = xnP.InnerText;
                    break;

                case "a:ModificationDate":
                    mColumn.ModificationDate = String2DateTime(xnP.InnerText);
                    break;

                case "a:Modifier":
                    mColumn.Modifier = xnP.InnerText;
                    break;

                case "a:Comment":
                    mColumn.Comment = xnP.InnerText;
                    break;

                case "a:DataType":
                    mColumn.DataType = xnP.InnerText;
                    break;

                case "a:Length":
                    mColumn.Length = xnP.InnerText;
                    break;

                case "a:Identity":
                    mColumn.Identity = ConvertToBooleanPg(xnP.InnerText);
                    break;

                case "a:Mandatory":
                    mColumn.Mandatory = ConvertToBooleanPg(xnP.InnerText);
                    break;

                case "a:PhysicalOptions":
                    mColumn.PhysicalOptions = xnP.InnerText;
                    break;

                case "a:ExtendedAttributesText":
                    mColumn.ExtendedAttributesText = xnP.InnerText;
                    break;

                case "a:Precision":
                    mColumn.Precision = xnP.InnerText;
                    break;
                }
            }
            return(mColumn);
        }
 public void AddColumn(ColumnInfo mColumn)
 {
     if (Columns == null)
         Columns = new List<ColumnInfo>();
     Columns.Add(mColumn);
 }
        private ColumnInfo GetColumn(XmlNode xnColumn, TableInfo ownerTable)
        {
            ColumnInfo mColumn = new ColumnInfo(ownerTable);
            XmlElement xe = (XmlElement)xnColumn;
            mColumn.ColumnId = xe.GetAttribute("Id");
            XmlNodeList xnCProperty = xe.ChildNodes;
            foreach (XmlNode xnP in xnCProperty)
            {
                switch (xnP.Name)
                {
                    case "a:ObjectID":
                        mColumn.ObjectId = xnP.InnerText;
                        break;

                    case "a:Name":
                        mColumn.Name = xnP.InnerText;
                        break;

                    case "a:Code":
                        mColumn.Code = xnP.InnerText;
                        break;

                    case "a:CreationDate":
                        mColumn.CreationDate = String2DateTime(xnP.InnerText);
                        break;

                    case "a:Creator":
                        mColumn.Creator = xnP.InnerText;
                        break;

                    case "a:ModificationDate":
                        mColumn.ModificationDate = String2DateTime(xnP.InnerText);
                        break;

                    case "a:Modifier":
                        mColumn.Modifier = xnP.InnerText;
                        break;

                    case "a:Comment":
                        mColumn.Comment = xnP.InnerText;
                        break;

                    case "a:DataType":
                        mColumn.DataType = xnP.InnerText;
                        break;

                    case "a:Length":
                        mColumn.Length = xnP.InnerText;
                        break;

                    case "a:Identity":
                        mColumn.Identity = ConvertToBooleanPg(xnP.InnerText);
                        break;

                    case "a:Mandatory":
                        mColumn.Mandatory = ConvertToBooleanPg(xnP.InnerText);
                        break;

                    case "a:PhysicalOptions":
                        mColumn.PhysicalOptions = xnP.InnerText;
                        break;

                    case "a:ExtendedAttributesText":
                        mColumn.ExtendedAttributesText = xnP.InnerText;
                        break;

                    case "a:Precision":
                        mColumn.Precision = xnP.InnerText;
                        break;
                }
            }
            return mColumn;
        }