Create xml from database using LINQ

Create xml from database using LINQ

29 Mar 2024
1 min read
Learn via Video Course & by Doing Hands-on Labs

ASP.NET MVC with WebAPI Course

XML data is often used to transfer data from one application to another. Since XML is language independent, hence it is a good choice to use xml for transferring data between two different platform applications. In C#, it is easy to make xml from database by using LINQ to SQL and LINQ to XML.

Create XML from Database

Suppose we have below table in database. Now I want to make xml of all the products which have stock greater than 0. Here I am using LINQ Pad to query data from the database. It is a great tool to query data from database using LINQ to SQL, LINQ to XML, LINQ to Entity Framework.

 ProductID int IDENTITY(1,1) NOT NULL,
 ProductName varchar(50) NOT NULL,
 Price float NOT NULL,
 Stock int NOT NULL
INSERT INTO Product (ProductName,Price,Stock)VALUES('P001',12.12,100)
INSERT INTO Product (ProductName,Price,Stock)VALUES('P002',102.12,200)
INSERT INTO Product (ProductName,Price,Stock)VALUES('P003',104.12,500)
INSERT INTO Product (ProductName,Price,Stock)VALUES('P004',108.12,100)
INSERT INTO Product (ProductName,Price,Stock)VALUES('P005',72.12,10)
INSERT INTO Product (ProductName,Price,Stock)VALUES('P006',72.12,0)
SELECT * FROM Product 

Now, query the data from above table using LINQ. We can also save the output to xml file.

 //Export above xml to xmlfile
In this article I try to explain how to create xml from database using LINQ with example. I hope after reading this article you will be able to create xml from database. I would like to have feedback from my blog readers. Please post your feedback, question, or comments about this article.
Share Article
Batches Schedule
About Author
Shailendra Chauhan (Microsoft MVP, Founder & CEO at Scholarhat by DotNetTricks)

Shailendra Chauhan is the Founder and CEO at ScholarHat by DotNetTricks which is a brand when it comes to e-Learning. He provides training and consultation over an array of technologies like Cloud, .NET, Angular, React, Node, Microservices, Containers and Mobile Apps development. He has been awarded Microsoft MVP 8th time in a row (2016-2023). He has changed many lives with his writings and unique training programs. He has a number of most sought-after books to his name which has helped job aspirants in cracking tough interviews with ease.
Self-paced Membership
  • 22+ Courses
  • 750+ Hands-On Labs
  • 300+ Quick Notes
  • 55+ Skill Tests
  • 45+ Interview Q&A
  • 10+ Real-world Projects
  • Career Coaching
  • Email Support
Upto 66% OFF

To get full access to all courses

Accept cookies & close this