本文整理汇总了C#中IDatabase.GetView方法的典型用法代码示例。如果您正苦于以下问题:C# IDatabase.GetView方法的具体用法?C# IDatabase.GetView怎么用?C# IDatabase.GetView使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IDatabase
的用法示例。
在下文中一共展示了IDatabase.GetView方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: DeserialiseMapping
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;
}
示例2: ProcessViewIndexesNode
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
}
示例3: ProcessKeysNode
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
}
示例4: DeserialiseViewKeys
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);
}
}
}
示例5: DeserialiseViewColumns
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);
}
}
示例6: DeserialiseRelationship
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;
}