Whats the best way of building xml document based on few oracle queries in C#
select orderID,qty,orderDate,deliveryDate from Orders
<orders>
<order>
<orderID>1</orderID>
<qty>10</qty>
<orderDate>22-Jan-2012</orderDate>
<deliveryDate>25-Jan-2012</deliveryDate>
</order>
<order>
<orderID>2</orderID>
<qty>10</qty>
<orderDate>22-Jan-2012</orderDate>
<deliveryDate>25-Jan-2012</deliveryDate>
</order>
</orders>
Please advice
You may use XElement.
Code Example:
using (SqlConnection con = new SqlConnection(ConnectionString))
{
con.Open();
using(SqlCommand command = new SqlCommand("select orderID,qty,orderDate,deliveryDate from Orders", con))
{
SqlDataReader reader = command.ExecuteReader();
XElement root = new XElement("Orders");
while(reader.Read())
{
root.AddFirst(
new XElement("Order",
from i in Enumerable.Range(0, reader.FieldCount)
select
new XElement(reader.GetName(i), reader.GetValue(i))
)
);
}
root.Save(Console.Out);
}
}
Please refer to this example: http://support.microsoft.com/kb/301271
Except instead of SqlConnection & SqlDataAdapter, use OracleConnection & OracleDataAdapter.
You can do it in the oracle query itself.
Please find the below link
https://forums.oracle.com/forums/thread.jspa?threadID=1034099
