C# IDatabase.GetView方法代码示例

        public Mapping DeserialiseMapping(XmlNode node, IDatabase database, EntitySet set)
        {
            NodeProcessor proc = new NodeProcessor(node);
            Mapping mapping = new MappingImpl();

            mapping.FromTable = database.GetTable(proc.GetString("FromTable"), proc.GetString("FromSchema"));

            if (mapping.FromTable == null)
                mapping.FromTable = database.GetView(proc.GetString("FromTable"), proc.GetString("FromSchema"));

            mapping.ToEntity = set.GetEntity(proc.GetString("ToEntity"));

            if (mapping.FromTable == null || mapping.ToEntity == null)
                return null;

            var columnNodes = node.SelectNodes("FromColumns/Column");
            var propNodes = node.SelectNodes("ToProperties/Property");
            if (columnNodes == null) throw new DeserialisationException("There were no columns in this Mapping xml");
            if (propNodes == null) throw new DeserialisationException("There were no properties in this Mapping xml");

            List<IColumn> columns = new List<IColumn>();
            foreach (XmlNode columnNode in columnNodes)
                columns.Add(mapping.FromTable.GetColumn(columnNode.InnerText));

            List<Property> properties = new List<Property>();
            foreach (XmlNode propNode in propNodes)
                properties.Add(mapping.ToEntity.GetProperty(propNode.InnerText));

            if (columns.Count != properties.Count) throw new DeserialisationException("Mapping contains different numbers of columns and properties");

            for (int i = 0; i < columns.Count; i++)
            {
                if (properties[i] != null && columns[i] != null)
                    mapping.AddPropertyAndColumn(properties[i], columns[i]);
            }

            ProcessScriptBase(mapping, node);

            return mapping;
        }

        private void ProcessViewIndexesNode(IDatabase database, XmlNode indexesNode)
        {
            // ReSharper disable PossibleNullReferenceException
            if (indexesNode == null)
                return;

            ITable parent = database.GetView(indexesNode.SelectSingleNode("../Name").InnerText, indexesNode.SelectSingleNode("../Schema").InnerText);

            foreach (XmlNode indexNode in indexesNode.SelectNodes("Index"))
            {
                IIndex index = ProcessIndexNode(indexNode, parent, database);
                parent.AddIndex(index);
            }
            // ReSharper restore PossibleNullReferenceException
        }

        private void ProcessKeysNode(IDatabase database, XmlNode keysNode)
        {
            // ReSharper disable PossibleNullReferenceException
            if (keysNode == null)
                return;

            string parentName = keysNode.SelectSingleNode("../Name").InnerText;
            string parentSchema = keysNode.SelectSingleNode("../Schema").InnerText;

            ITable parent = database.GetTable(parentName, parentSchema);

            if (parent == null)
                parent = database.GetView(parentName, parentSchema);

            if (parent == null)
                throw new Exception(string.Format("Table/View not found: {0}.{1}", parentSchema, parentName));

            foreach (XmlNode keyNode in keysNode.SelectNodes("Key"))
            {
                IKey key = ProcessKeyNode(keyNode, parent, database);
                parent.AddKey(key);
            }
            // ReSharper restore PossibleNullReferenceException
        }

        private void DeserialiseViewKeys(IDatabase database, XmlNodeList nodes)
        {
            // 1) Deserialise Primary Keys.
            foreach (XmlNode tableNode in nodes)
            {
                var keyElements = tableNode.SelectSingleNode("Keys");
                ProcessKeysNode(database, keyElements);
            }

            // 2) Deserialise Foreign Keys.
            foreach (XmlNode tableNode in nodes)
            {
                ITable parent = database.GetView(tableNode.SelectSingleNode("Name").InnerText, tableNode.SelectSingleNode("Schema").InnerText);
                var keyElements = tableNode.SelectNodes("Keys/Key");
                if (keyElements == null) continue;

                foreach (XmlNode keyElement in keyElements)
                {
                    IKey key = parent.GetKey(keyElement.SelectSingleNode("Name").InnerText);
                    ProcessReferencedKey(key, keyElement, database);
                }
            }
        }

 private void DeserialiseViewColumns(IDatabase database, XmlNodeList nodes)
 {
     foreach (XmlNode tableNode in nodes)
     {
         var columnsElement = tableNode.SelectSingleNode("Columns");
         ITable table = database.GetView(tableNode.SelectSingleNode("Name").InnerText, tableNode.SelectSingleNode("Schema").InnerText);
         ProcessColumnsNode(table, columnsElement);
     }
 }

        public Relationship DeserialiseRelationship(XmlNode node, IDatabase database)
        {
            NodeProcessor proc = new NodeProcessor(node);

            var rel = new RelationshipImpl();

            rel.Identifier = proc.Attributes.GetGuid("identifier");
            rel.Name = proc.GetString("Name");

            ITable table1 = database.GetTable(proc.GetString("PrimaryTable"), proc.GetString("PrimarySchema"));
            ITable table2 = database.GetTable(proc.GetString("ForeignTable"), proc.GetString("ForeignSchema"));

            if (table1 == null)
                table1 = database.GetView(proc.GetString("PrimaryTable"), proc.GetString("PrimarySchema"));

            if (table2 == null)
                table2 = database.GetView(proc.GetString("ForeignTable"), proc.GetString("ForeignSchema"));

            if (table1 == null || table2 == null)
                return null;

            var key1 = table1.GetKey(proc.GetString("PrimaryKey"));
            var key2 = table2.GetKey(proc.GetString("ForeignKey"));

            if (key1 == null || key2 == null)
                return null; // The foreign key has probably been removed

            if (key1.Keytype == DatabaseKeyType.Foreign)
            {
                // The keys are around the wrong way.
                var tempKey = key2;
                key2 = key1;
                key1 = tempKey;

                var tempTable = table2;
                table2 = table1;
                table1 = tempTable;
            }

            rel.AddThisTo(table1, table2);
            rel.PrimaryKey = key1;
            rel.ForeignKey = key2;
            rel.PrimaryCardinality = rel.ForeignKey.IsUnique ? Cardinality.One : Cardinality.Many;
            rel.ForeignCardinality = rel.PrimaryKey.IsUnique ? Cardinality.One : Cardinality.Many;
            rel.Database = database;

            return rel;
        }