30
MarCreate xml from database using LINQ
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.
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"));