|
|
|
|
In application there is a utility to export 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 fails when trying to export the data around 100000 rows in table. Out of memory exception is raised
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]);
}
|
|
|
|
|
|
|
|
|
|
|
|