How to export a sql server table with your data to xml

0

hello I have a table in sql server which I must export it to xml and I'm doing it but I do not export it in the format I want, I'm trying the following:

 string select = "select * from TEMPTABLE FOR XML AUTO, XMLDATA";

XmlDocument xmlDoc;

var cmd = new SqlCommand(query, con); 
con.Open();

var reader = cmd.ExecuteXmlReader();
xmlDoc = new XmlDocument();

while (reader.Read())
{
xmlDoc.Load(reader);
}
xmlDoc.Save("C:/temp/table.xml");

but this returns the xml in this format:

<?xml version="1.0" standalone="yes"?><NewDataSet>
<Table>
<ID>1</ID>
<DESCRIPCION>una empresa</DESCRIPCION>
<NUM_DOC>11111111111</NUM_DOC>
<TE>111111111111111111111</TE>
</Table>
</NewDataSet>

And I need it in the following way:

<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly' rs:updatable='true'>
<s:AttributeType name='ID' rs:number='1' rs:writeunknown='true' rs:basecatalog='obras' rs:basetable='EMPRESAS'
rs:basecolumn='ID' rs:keycolumn='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='15' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='DESCRIPCION' rs:number='2' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='obras'
rs:basetable='EMPRESAS' rs:basecolumn='DESCRIPCION'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='100'/>
</s:AttributeType>
<s:AttributeType name='NUM_DOC' rs:number='3' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='obras'
rs:basetable='EMPRESAS' rs:basecolumn='NUM_DOC'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='13'/>
</s:AttributeType>
<s:AttributeType name='TE' rs:number='4' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='obras' rs:basetable='EMPRESAS'
rs:basecolumn='TE'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='30'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row ID='1' DESCRIPCION='una empresa' NUM_DOC='11111111111' TE='111111111111111111111'/>
</rs:data>
</xml>

What can I do to achieve it, I'm using .NET MVC

    
asked by Raidel Fonseca 31.05.2018 в 03:27
source

0 answers