Click here to Skip to main content
15,892,674 members
Articles / Web Development / ASP.NET

Generate SQL Database Schema from XML - Part 2 (Code Model)

Rate me:
Please Sign up or sign in to vote.
4.83/5 (10 votes)
29 Nov 2010CPOL11 min read 42.5K   1.1K   25  
Part 2 of 3 in a series of articles about generating SQL from an XML file format. This part describes the development of a code model for the new file format.
//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated by a tool.
//     Runtime Version:2.0.50727.4952
//
//     Changes to this file may cause incorrect behavior and will be lost if
//     the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

// 
// This source code was auto-generated by xsd, Version=2.0.50727.3038.
// 
namespace DatabaseSchemaModel.Raw {
    using System.Xml.Serialization;
    
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    [System.Xml.Serialization.XmlRootAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd", IsNullable=false)]
    public partial class database {
        
        private table[] tablesField;
        
        private procedure[] proceduresField;
        
        private string nameField;
        
        private string exampleFolderPathField;
        
        private string sQLServerOutputPathField;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlArrayItemAttribute(IsNullable=false)]
        public table[] tables {
            get {
                return this.tablesField;
            }
            set {
                this.tablesField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlArrayItemAttribute(IsNullable=false)]
        public procedure[] procedures {
            get {
                return this.proceduresField;
            }
            set {
                this.proceduresField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string name {
            get {
                return this.nameField;
            }
            set {
                this.nameField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string ExampleFolderPath {
            get {
                return this.exampleFolderPathField;
            }
            set {
                this.exampleFolderPathField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string SQLServerOutputPath {
            get {
                return this.sQLServerOutputPathField;
            }
            set {
                this.sQLServerOutputPathField = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class table {
        
        private column[] columnsField;
        
        private primaryKey primaryKeyField;
        
        private constraint[] uniqueConstraintsField;
        
        private index[] indexesField;
        
        private relationship[] relationshipsField;
        
        private string nameField;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlArrayItemAttribute(IsNullable=false)]
        public column[] columns {
            get {
                return this.columnsField;
            }
            set {
                this.columnsField = value;
            }
        }
        
        /// <remarks/>
        public primaryKey primaryKey {
            get {
                return this.primaryKeyField;
            }
            set {
                this.primaryKeyField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlArrayItemAttribute(IsNullable=false)]
        public constraint[] uniqueConstraints {
            get {
                return this.uniqueConstraintsField;
            }
            set {
                this.uniqueConstraintsField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlArrayItemAttribute(IsNullable=false)]
        public index[] indexes {
            get {
                return this.indexesField;
            }
            set {
                this.indexesField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlArrayItemAttribute(IsNullable=false)]
        public relationship[] relationships {
            get {
                return this.relationshipsField;
            }
            set {
                this.relationshipsField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string name {
            get {
                return this.nameField;
            }
            set {
                this.nameField = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class column {
        
        private object itemField;
        
        private ItemChoiceType itemElementNameField;
        
        private string nameField;
        
        private bool allowNullsField;
        
        private bool allowNullsFieldSpecified;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlElementAttribute("bigint", typeof(bigint))]
        [System.Xml.Serialization.XmlElementAttribute("binary", typeof(binary))]
        [System.Xml.Serialization.XmlElementAttribute("bit", typeof(bit))]
        [System.Xml.Serialization.XmlElementAttribute("char", typeof(@char))]
        [System.Xml.Serialization.XmlElementAttribute("date", typeof(parameterlessStringType))]
        [System.Xml.Serialization.XmlElementAttribute("datetime", typeof(parameterlessStringType))]
        [System.Xml.Serialization.XmlElementAttribute("datetime2", typeof(variablePrecisionTime))]
        [System.Xml.Serialization.XmlElementAttribute("datetimeoffset", typeof(variablePrecisionTime))]
        [System.Xml.Serialization.XmlElementAttribute("decimal", typeof(@decimal))]
        [System.Xml.Serialization.XmlElementAttribute("decimalScale0", typeof(decimalScale0))]
        [System.Xml.Serialization.XmlElementAttribute("float", typeof(@float))]
        [System.Xml.Serialization.XmlElementAttribute("hierarchyid", typeof(parameterlessStringType))]
        [System.Xml.Serialization.XmlElementAttribute("image", typeof(parameterlessType))]
        [System.Xml.Serialization.XmlElementAttribute("int", typeof(@int))]
        [System.Xml.Serialization.XmlElementAttribute("money", typeof(money))]
        [System.Xml.Serialization.XmlElementAttribute("nchar", typeof(nchar))]
        [System.Xml.Serialization.XmlElementAttribute("ntext", typeof(parameterlessStringType))]
        [System.Xml.Serialization.XmlElementAttribute("numeric", typeof(@decimal))]
        [System.Xml.Serialization.XmlElementAttribute("numericScale0", typeof(decimalScale0))]
        [System.Xml.Serialization.XmlElementAttribute("nvarchar", typeof(nchar))]
        [System.Xml.Serialization.XmlElementAttribute("real", typeof(real))]
        [System.Xml.Serialization.XmlElementAttribute("rowversion", typeof(parameterlessType))]
        [System.Xml.Serialization.XmlElementAttribute("smalldatetime", typeof(parameterlessStringType))]
        [System.Xml.Serialization.XmlElementAttribute("smallint", typeof(smallint))]
        [System.Xml.Serialization.XmlElementAttribute("smallmoney", typeof(smallmoney))]
        [System.Xml.Serialization.XmlElementAttribute("sql_variant", typeof(parameterlessStringType))]
        [System.Xml.Serialization.XmlElementAttribute("text", typeof(parameterlessStringType))]
        [System.Xml.Serialization.XmlElementAttribute("time", typeof(variablePrecisionTime))]
        [System.Xml.Serialization.XmlElementAttribute("tinyint", typeof(tinyint))]
        [System.Xml.Serialization.XmlElementAttribute("uniqueidentifier", typeof(uniqueidentifier))]
        [System.Xml.Serialization.XmlElementAttribute("varbinary", typeof(binary))]
        [System.Xml.Serialization.XmlElementAttribute("varchar", typeof(@char))]
        [System.Xml.Serialization.XmlElementAttribute("xml", typeof(parameterlessStringType))]
        [System.Xml.Serialization.XmlChoiceIdentifierAttribute("ItemElementName")]
        public object Item {
            get {
                return this.itemField;
            }
            set {
                this.itemField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public ItemChoiceType ItemElementName {
            get {
                return this.itemElementNameField;
            }
            set {
                this.itemElementNameField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string name {
            get {
                return this.nameField;
            }
            set {
                this.nameField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public bool allowNulls {
            get {
                return this.allowNullsField;
            }
            set {
                this.allowNullsField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool allowNullsSpecified {
            get {
                return this.allowNullsFieldSpecified;
            }
            set {
                this.allowNullsFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class bigint {
        
        private identity identityField;
        
        private string defaultExpressionField;
        
        private long defaultField;
        
        private bool defaultFieldSpecified;
        
        /// <remarks/>
        public identity identity {
            get {
                return this.identityField;
            }
            set {
                this.identityField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public long @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool defaultSpecified {
            get {
                return this.defaultFieldSpecified;
            }
            set {
                this.defaultFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class identity {
        
        private string seedField;
        
        private string incrementField;
        
        private bool notForReplicationField;
        
        private bool notForReplicationFieldSpecified;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute(DataType="integer")]
        public string seed {
            get {
                return this.seedField;
            }
            set {
                this.seedField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute(DataType="integer")]
        public string increment {
            get {
                return this.incrementField;
            }
            set {
                this.incrementField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public bool notForReplication {
            get {
                return this.notForReplicationField;
            }
            set {
                this.notForReplicationField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool notForReplicationSpecified {
            get {
                return this.notForReplicationFieldSpecified;
            }
            set {
                this.notForReplicationFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class procedure {
        
        private string nameField;
        
        private string pathField;
        
        private platform platformField;
        
        private bool platformFieldSpecified;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string name {
            get {
                return this.nameField;
            }
            set {
                this.nameField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string path {
            get {
                return this.pathField;
            }
            set {
                this.pathField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public platform platform {
            get {
                return this.platformField;
            }
            set {
                this.platformField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool platformSpecified {
            get {
                return this.platformFieldSpecified;
            }
            set {
                this.platformFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public enum platform {
        
        /// <remarks/>
        SQLServer,
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class primaryKeyTable {
        
        private relationshipColumn[] columnField;
        
        private string nameField;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlElementAttribute("column")]
        public relationshipColumn[] column {
            get {
                return this.columnField;
            }
            set {
                this.columnField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string name {
            get {
                return this.nameField;
            }
            set {
                this.nameField = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class relationshipColumn {
        
        private string nameField;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string name {
            get {
                return this.nameField;
            }
            set {
                this.nameField = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class relationship {
        
        private relationshipColumn[] foreignKeyColumnsField;
        
        private primaryKeyTable primaryKeyTableField;
        
        private string nameField;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlArrayItemAttribute("column", IsNullable=false)]
        public relationshipColumn[] foreignKeyColumns {
            get {
                return this.foreignKeyColumnsField;
            }
            set {
                this.foreignKeyColumnsField = value;
            }
        }
        
        /// <remarks/>
        public primaryKeyTable primaryKeyTable {
            get {
                return this.primaryKeyTableField;
            }
            set {
                this.primaryKeyTableField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string name {
            get {
                return this.nameField;
            }
            set {
                this.nameField = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class constraintColumn {
        
        private string nameField;
        
        private sortOrder sortOrderField;
        
        private bool sortOrderFieldSpecified;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string name {
            get {
                return this.nameField;
            }
            set {
                this.nameField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public sortOrder sortOrder {
            get {
                return this.sortOrderField;
            }
            set {
                this.sortOrderField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool sortOrderSpecified {
            get {
                return this.sortOrderFieldSpecified;
            }
            set {
                this.sortOrderFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public enum sortOrder {
        
        /// <remarks/>
        Ascending,
        
        /// <remarks/>
        Descending,
    }
    
    /// <remarks/>
    [System.Xml.Serialization.XmlIncludeAttribute(typeof(index))]
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class constraint {
        
        private constraintColumn[] columnField;
        
        private string nameField;
        
        private bool clusteredField;
        
        private string fillFactorField;
        
        private bool padIndexField;
        
        private bool padIndexFieldSpecified;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlElementAttribute("column")]
        public constraintColumn[] column {
            get {
                return this.columnField;
            }
            set {
                this.columnField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string name {
            get {
                return this.nameField;
            }
            set {
                this.nameField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public bool clustered {
            get {
                return this.clusteredField;
            }
            set {
                this.clusteredField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute(DataType="integer")]
        public string fillFactor {
            get {
                return this.fillFactorField;
            }
            set {
                this.fillFactorField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public bool padIndex {
            get {
                return this.padIndexField;
            }
            set {
                this.padIndexField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool padIndexSpecified {
            get {
                return this.padIndexFieldSpecified;
            }
            set {
                this.padIndexFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class index : constraint {
        
        private bool uniqueField;
        
        private bool uniqueFieldSpecified;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public bool unique {
            get {
                return this.uniqueField;
            }
            set {
                this.uniqueField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool uniqueSpecified {
            get {
                return this.uniqueFieldSpecified;
            }
            set {
                this.uniqueFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class primaryKey {
        
        private constraint keyField;
        
        /// <remarks/>
        public constraint key {
            get {
                return this.keyField;
            }
            set {
                this.keyField = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class uniqueidentifier {
        
        private string defaultExpressionField;
        
        private string defaultField;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class parameterlessType {
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class binary {
        
        private string lengthField;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string length {
            get {
                return this.lengthField;
            }
            set {
                this.lengthField = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class nchar {
        
        private string defaultExpressionField;
        
        private string defaultField;
        
        private string lengthField;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string length {
            get {
                return this.lengthField;
            }
            set {
                this.lengthField = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class @char {
        
        private string defaultExpressionField;
        
        private string defaultField;
        
        private string lengthField;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string length {
            get {
                return this.lengthField;
            }
            set {
                this.lengthField = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class variablePrecisionTime {
        
        private string defaultExpressionField;
        
        private string defaultField;
        
        private string fractionalSecondsPrecisionField;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute(DataType="integer")]
        public string fractionalSecondsPrecision {
            get {
                return this.fractionalSecondsPrecisionField;
            }
            set {
                this.fractionalSecondsPrecisionField = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class parameterlessStringType {
        
        private string defaultExpressionField;
        
        private string defaultField;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class real {
        
        private string defaultExpressionField;
        
        private decimal defaultField;
        
        private bool defaultFieldSpecified;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public decimal @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool defaultSpecified {
            get {
                return this.defaultFieldSpecified;
            }
            set {
                this.defaultFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class @float {
        
        private string defaultExpressionField;
        
        private string mantissaBitsField;
        
        private decimal defaultField;
        
        private bool defaultFieldSpecified;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute(DataType="integer")]
        public string mantissaBits {
            get {
                return this.mantissaBitsField;
            }
            set {
                this.mantissaBitsField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public decimal @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool defaultSpecified {
            get {
                return this.defaultFieldSpecified;
            }
            set {
                this.defaultFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class money {
        
        private string defaultExpressionField;
        
        private decimal defaultField;
        
        private bool defaultFieldSpecified;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public decimal @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool defaultSpecified {
            get {
                return this.defaultFieldSpecified;
            }
            set {
                this.defaultFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class tinyint {
        
        private identity identityField;
        
        private string defaultExpressionField;
        
        private sbyte defaultField;
        
        private bool defaultFieldSpecified;
        
        /// <remarks/>
        public identity identity {
            get {
                return this.identityField;
            }
            set {
                this.identityField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public sbyte @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool defaultSpecified {
            get {
                return this.defaultFieldSpecified;
            }
            set {
                this.defaultFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class @int {
        
        private identity identityField;
        
        private string defaultExpressionField;
        
        private int defaultField;
        
        private bool defaultFieldSpecified;
        
        /// <remarks/>
        public identity identity {
            get {
                return this.identityField;
            }
            set {
                this.identityField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public int @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool defaultSpecified {
            get {
                return this.defaultFieldSpecified;
            }
            set {
                this.defaultFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class smallmoney {
        
        private string defaultExpressionField;
        
        private decimal defaultField;
        
        private bool defaultFieldSpecified;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public decimal @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool defaultSpecified {
            get {
                return this.defaultFieldSpecified;
            }
            set {
                this.defaultFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class smallint {
        
        private identity identityField;
        
        private string defaultExpressionField;
        
        private short defaultField;
        
        private bool defaultFieldSpecified;
        
        /// <remarks/>
        public identity identity {
            get {
                return this.identityField;
            }
            set {
                this.identityField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public short @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool defaultSpecified {
            get {
                return this.defaultFieldSpecified;
            }
            set {
                this.defaultFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class bit {
        
        private string defaultExpressionField;
        
        private bool defaultField;
        
        private bool defaultFieldSpecified;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public bool @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool defaultSpecified {
            get {
                return this.defaultFieldSpecified;
            }
            set {
                this.defaultFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class decimalScale0 {
        
        private identity identityField;
        
        private string defaultExpressionField;
        
        private string precisionField;
        
        private decimal defaultField;
        
        private bool defaultFieldSpecified;
        
        /// <remarks/>
        public identity identity {
            get {
                return this.identityField;
            }
            set {
                this.identityField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute(DataType="integer")]
        public string precision {
            get {
                return this.precisionField;
            }
            set {
                this.precisionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public decimal @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool defaultSpecified {
            get {
                return this.defaultFieldSpecified;
            }
            set {
                this.defaultFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd")]
    public partial class @decimal {
        
        private string defaultExpressionField;
        
        private string precisionField;
        
        private string scaleField;
        
        private decimal defaultField;
        
        private bool defaultFieldSpecified;
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public string defaultExpression {
            get {
                return this.defaultExpressionField;
            }
            set {
                this.defaultExpressionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute(DataType="integer")]
        public string precision {
            get {
                return this.precisionField;
            }
            set {
                this.precisionField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute(DataType="integer")]
        public string scale {
            get {
                return this.scaleField;
            }
            set {
                this.scaleField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlAttributeAttribute()]
        public decimal @default {
            get {
                return this.defaultField;
            }
            set {
                this.defaultField = value;
            }
        }
        
        /// <remarks/>
        [System.Xml.Serialization.XmlIgnoreAttribute()]
        public bool defaultSpecified {
            get {
                return this.defaultFieldSpecified;
            }
            set {
                this.defaultFieldSpecified = value;
            }
        }
    }
    
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace="http://olduwan.com/DatabaseSchemaModel.xsd", IncludeInSchema=false)]
    public enum ItemChoiceType {
        
        /// <remarks/>
        bigint,
        
        /// <remarks/>
        binary,
        
        /// <remarks/>
        bit,
        
        /// <remarks/>
        @char,
        
        /// <remarks/>
        date,
        
        /// <remarks/>
        datetime,
        
        /// <remarks/>
        datetime2,
        
        /// <remarks/>
        datetimeoffset,
        
        /// <remarks/>
        @decimal,
        
        /// <remarks/>
        decimalScale0,
        
        /// <remarks/>
        @float,
        
        /// <remarks/>
        hierarchyid,
        
        /// <remarks/>
        image,
        
        /// <remarks/>
        @int,
        
        /// <remarks/>
        money,
        
        /// <remarks/>
        nchar,
        
        /// <remarks/>
        ntext,
        
        /// <remarks/>
        numeric,
        
        /// <remarks/>
        numericScale0,
        
        /// <remarks/>
        nvarchar,
        
        /// <remarks/>
        real,
        
        /// <remarks/>
        rowversion,
        
        /// <remarks/>
        smalldatetime,
        
        /// <remarks/>
        smallint,
        
        /// <remarks/>
        smallmoney,
        
        /// <remarks/>
        sql_variant,
        
        /// <remarks/>
        text,
        
        /// <remarks/>
        time,
        
        /// <remarks/>
        tinyint,
        
        /// <remarks/>
        uniqueidentifier,
        
        /// <remarks/>
        varbinary,
        
        /// <remarks/>
        varchar,
        
        /// <remarks/>
        xml,
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior) Olduwan Ltd.
United Kingdom United Kingdom
Entertainment software.
Web development.

Comments and Discussions