TSF.UmlToolingFramework.Wrappers.EA.Model.SQLQuery C# (CSharp) Method

SQLQuery() public method

public SQLQuery ( string sqlQuery ) : XmlDocument
sqlQuery string
return System.Xml.XmlDocument
        public XmlDocument SQLQuery(string sqlQuery)
        {
            sqlQuery = this.formatSQL(sqlQuery);
            XmlDocument results = new XmlDocument();
              	results.LoadXml(this.wrappedModel.SQLQuery(sqlQuery));
              	return results;
        }

Usage Example

        public static bool isItemUsedInASchema(UML.Classes.Kernel.Element element, TSF_EA.Model model)
        {
            var sqlGetCountSchemas = @"select count(*) as countresult from t_document d 
                                        inner join t_object o on o.ea_guid = d.ElementID
                                        where d.DocType = 'SC_MessageProfile' "
                                     + $"and d.StrContent like '%{element.uniqueID}%'";
            var resultXml = model.SQLQuery(sqlGetCountSchemas);
            var countNode = resultXml.SelectSingleNode(model.formatXPath("//countresult"));

            return(countNode.InnerText != "0");
        }
All Usage Examples Of TSF.UmlToolingFramework.Wrappers.EA.Model::SQLQuery