How to generate XML from LINQ query

Question

we often work with dataset and after populate dataset we can use getxml() function to have the data in xml format. so i like to know is there any similar technique exist for linq to generate xml from linq query. please guide. thanks

IEnumerable<Books> books = Books.GetBooks();
   IEnumerable<Salesdetails> sales = 
                       Salesdetails.getsalesdetails();
   var booktitles = from b in books
             join s in sales
             on b.ID equals s.ID
             select new { Name = b.Title, Pages = s.pages };
   foreach (var title in booktitles)
      lblbooks.Text += String.Format("{0} <br />", title);

You may use Data Contract Serializer to serialize the Query Result and that will be XML. — Emran Hussain
– Emran Hussain, Commented Apr 3, 2014 at 19:36

Selman Genç · Accepted Answer · 2014-04-03 19:36:25Z

1

Yes, here is an example:

var rootElement = new XElement("Books",
                booktitles.Select(
                    x => new XElement("Book",
                        new XElement("Name", x.Name),
                        new XElement("Pages", x.Pages))));

rootElement.Save("path");

You might want to take a look at documentation: Creating XML Trees in C# (LINQ to XML)

answered Apr 3, 2014 at 19:36

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

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

1 Comment

Mou Over a year ago

how to store the xml in string variable instead of saving to file?

Collectives™ on Stack Overflow

How to generate XML from LINQ query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related