Generate sitemap XML file from sql database?

[mzak14]

Hi I would like to generate site map xml from my database. So far from my research I have found that 1.Generating it with c# code and writing dataset in to xml formathttp://www.c-sharpcorner.com/blogs/8115/generating-xml-file-from-sql-database-using-c-sharp.aspx[*]Second procedure is directly writing data into xml format from database.Can you guys tell me which is the best way and my database is huge. And i want my xml to look like this\[code\]<url><location>http://xxx.com/default.aspx?page=PageID</location><title>xxxxxxxx</title><lastmodified>01-01-1900</lastmodified></url>\[/code\]PageID, page title and date will come from database tables.Thanks