public List<ConnectorWrapper> getRelationsByQuery(string SQLQuery)
{
// get the nodes with the name "Connector_ID"
XmlDocument xmlrelationIDs = this.SQLQuery(SQLQuery);
XmlNodeList relationIDNodes =
xmlrelationIDs.SelectNodes(formatXPath("//Connector_ID"));
List<ConnectorWrapper> relations = new List<ConnectorWrapper>();
foreach( XmlNode relationIDNode in relationIDNodes ) {
int relationID;
if (int.TryParse( relationIDNode.InnerText, out relationID)) {
ConnectorWrapper relation = this.getRelationByID(relationID);
relations.Add(relation);
}
}
return relations;
}