public static DataSet ExecuteQueryUsingForXml(string server, string database, string query)
{
DataSet resultsDataSet = new DataSet();
// Wrap in XML
string newQuery = $@"DECLARE @xmlData XML
SET @xmlData = ({query} FOR XML AUTO, ELEMENTS, XMLSCHEMA('PowerShellDataExportXsdSchema'), ROOT('Root'))
SELECT @xmlData AS XmlResult";
// Execute select statement
DataSet intermediateDataSet = ExecuteQuery(server, database, newQuery);
if (intermediateDataSet.Tables.Count == 1 && intermediateDataSet.Tables[0].Rows.Count == 1)
{
resultsDataSet = DataParser.NewDataSetFromXml(intermediateDataSet.Tables[0].Rows[0]["XmlResult"].ToString());
}
return(resultsDataSet);
}
