Converting JSON data to XML

Question

 

My webservice returning JSON data as output. Is it possible to convert JSON data into XML in .net?. Actually i need to store that data into Sql server. If its XML format we can use sp_XML_Preparedocument and openXML fuction for storing into database. So guide me in how to convert JSON to XML or hoe to store JSON data into Sqlserver using stored procedure. If both are possible which one is best way?

Answer 1

Hi,

In .NET 3.5 there is a new class:

http://msdn2.microsoft.com/en-us/library/system.runtime.serialization.json(VS.90).aspx

Also you could consider http://jayrock.berlios.de/ or the ASP.NET AJAX stuff which I beleive has JSON serialisation also:  http://www.asp.net/ajax/.

I hope this helps.

J

Answer 2

 

Thanks for ur reply j.

 

 As you mentiond its for .NET 3.5 . But i am looking for .NET 2.0.

 In jayrock and ASP.NET AJAX concepts they serialize the JSON data to .NET objects. Like arrays, classes

 

I need to convert JSON to XML directly. Is it possible?

 

Answer 3

Based on 2.0 this is how can do it:

 

JSON data --> ASP.NET JSON DeSerialize --> .Net Object --> XmlSerializer Serialize --> Xml

 

and reverse the process to get back the JSON.