Export SQL Server Database Table to XML Using Linq

Question

I know how to do simple Linq To XML. Export a sql server database table data. A simple query like follow will work:

xmlDoc = new XElement("TestPoints",
                from test in myDB.TestPoints
                select
                new XElement("TestPoint",
                    new XElement("Id", test.Id),
                    new XElement("Value", test.Value),
                    new XElement("Time", test.Time),
                    new XElement("TestId", test.TestId)
                    )
                );
            xmlDoc.Save("test.xml");

However, in this case, i need to specify every database column those I need to export. What I need is to export a table which have more than 30 columns. Now, its a bit painful to make such repetitively task of creating new XElement. Is there any way to dump the full table and all its columns/rows to a xml file in LinQ easily please? Without specify each column externally. Thanks.

You can select the xml from db and the xml can be selected via LINQ. msdn.microsoft.com/en-us/library/ms345137%28v=sql.90%29.aspx — TcKs
– TcKs, Commented Jun 23, 2011 at 12:21

Pranay Rana · Accepted Answer · 2011-06-23 12:22:47Z

4

Put Data of sql server table in DataTable

and than use DataTable.WriteXml will do your task easily.

answered Jun 23, 2011 at 12:22

Pranay Rana

177k37 gold badges244 silver badges266 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export SQL Server Database Table to XML Using Linq

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related