Please enable Javascript to correctly display the contents on Dot Net Tricks!

Create xml from database using LINQ

 Print 
  Author : Shailendra Chauhan
Posted On : 31 May 2012
Total Views : 56,195   
Updated On : 24 Jun 2014
 

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.

 CREATE TABLE Product (
 ProductID int IDENTITY(1,1) NOT NULL,
 ProductName varchar(50) NOT NULL,
 Price float NOT NULL,
 Stock int NOT NULL
)
GO
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)
GO
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
XElement.Save(Server.MapPath(@"~/export.xml")); 
Summary
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.


Free Interview Books
 
COMMENTS
20 SEP
MEAN Stack (Online)
07:00 AM-09:00 AM IST
20 SEP
ASP.NET MVC with Angular4 (Online)
9:00PM- 11:00PM IST(+5:30GMT)
16 SEP
Angular2 and Angular4 (Online)
08:00 AM-10:00 AM IST(+5.30 GMT)
16 SEP
Microsoft Azure Infrastructure Solutions (Online)
08:00 PM-11:00 PM IST / 9:30 AM-12:30 PM CST
7 SEP
ASP.NET MVC with Angular4 (Online)
09:00 PM to 11:00 PM IST (+5:30 GMT)
22 AUG
ASP.NET Core with Angular4 (Online)
07:00 AM - 9:00 AM IST(+5:30 GMT)
19 AUG
MEAN Stack 2 (Online)
5:30 Pm - 7:00 PM IST (+5:30 GMT)
19 AUG
ASP.NET MVC with Angular4 (Online)
10:30 Am to 12:30 PM IST (+ 5:30 GMT)
19 AUG
NodeJS with Angular4 (Classroom)
04:00 PM to 07:00 PM IST (+5:30 GMT)
12 AUG
ASP.NET MVC with Angular4 (Classroom)
11:30 AM - 1:30 PM IST (+5:30GMT)
15 JUL
ASP.NET MVC with Angular4 (Online)
03:30 PM - 05:30 PM IST(+5.30 GMT)
LIKE US ON FACEBOOK
 
+