Can I generate XML Data from the SQLite Database?

Question

In such DBMS as Oracle or PostgreSQL there are functions for generating XML Data from the database: http://docs.oracle.com/cd/B19306_01/appdev.102/b14259/xdb13gen.htm or http://www.postgresql.org/docs/current/static/functions-xml.html#AEN15086

My question are there something similar in SQLite database? May be there are some additional tools, libraries or even standard tools for this purpose?

Answer 1

If you are using C#.NET there can be two ways for it.

1. You can get the data into datasets and use the .WriteXml() method to write into the xml file.

   var sqc = new SqlConnection(ConfigurationManager.ConnectionStrings["AddsConnectionString"].ConnectionString);       
   
   sqc.Open();
   
   var q = "select * from adv";
   
   var sqd = new SqlDataAdapter(q, sqc);
   
   var ds = new DataSet();
   
   sqd.Fill(ds,"adv");
   
   ds.WriteXml("d:/data.xml");
   

Do not forget to include System.Xml

2. OR else you can use Linq.