application there is a utility for exporting the data from database to XML file and then import the same in another system.
The system is designed using .NET Framework 3.5.
The utility is now failing when trying to export the data around 100000 rows in table. It is giving out of memory exception.
The code snippet is as follows
private void ExportTableAsXml(ref XmlNode rootElement,Hashtable externalParameters)
{
DataTable result = null;
if (commandTypeField == CommandType.StoredProcedure)
{
}
else if (commandTypeField == CommandType.Text)
{
DataSet resultDataSet = xdo.ExecDataSetSQL(sqlStatementField);
if (resultDataSet != null && resultDataSet.Tables.Count > 0)
result = resultDataSet.Tables[0];
}
XmlNode containerElement = rootElement;
if (result != null && result.Rows.Count != 0)
{
if (containerNameField != string.Empty)
containerElement = rootElement.OwnerDocument.CreateElement(containerNameField);
if (!ResultIsXml)
ConvertTableToXml(ref containerElement, result);
else
{
StringBuilder xmlBuilder = new StringBuilder();
if (result.Columns.Count == 1)
{
foreach(DataRow row in result.Rows)
{
if (!row.IsNull(result.Columns[0]))
{
xmlBuilder.Append(row[0]);
}
}
if (xmlBuilder.Length != 0)
{
containerElement.InnerXml += xmlBuilder.ToString();
}
}
else
{
throw new Exception("The provided xml query returned more than one column.");
}
}
if (AllowEmptyElement || (!AllowEmptyElement && containerElement.InnerXml != null && containerElement.InnerXml != string.Empty))
{
if (rootElement != containerElement)
rootElement.AppendChild(containerElement);
}
}
}
The line highlighted above is throwing exception