How to create xml file using linq in C#?

In this example I will show you how to create xml document using Linq .In order to extract data from a database and create an xml document we need to include the namespace using System.Xml.Linq. The important class with the Linq to Xml hierarchy XElements and XDocument, XElement class represents an XML element node that contains child elements as child nodes.The output xml file will be saved at a specified location of the project folder.

This example I used northwind sample database for more detail about how to download click link button it will show a popup.

Example:  

  protected void Page_Load(object sender, EventArgs e)
        {
            models db = new models();
            var customerOrders = from customer in db.Customers
                                 where customer.ContactName.StartsWith("C") && customer.Orders.Count> 0
                                 orderby customer.ContactName
                                 select customer;
            var xml = new XElement("customers", from customer in customerOrders.ToList()
                                               select new XElement("ContactName",
                                                  new XAttribute("ContactName", customer.ContactName), new XAttribute("phone", customer.Phone)));
            var path = Path.Combine(Server.MapPath("~/Xmlfiles"), "file1" + ".xml");
           System.IO.File.WriteAllText(path,xml.ToString());
        }

Output: