Linq to Xml

[shapper]

Hello,

I am getting records from an SQL database using Linq.
I want to write these records in a XML file.

Each record would be a node in my XML file.
However, the attributes in the XML file have different names from the
columns of my object in the list.

How can I do this?

Thanks,
Miguel

 

[Jon Skeet [C# MVP]]

I am getting records from an SQL database using Linq.
I want to write these records in a XML file.

Each record would be a node in my XML file.
However, the attributes in the XML file have different names from the
columns of my object in the list.

How can I do this?

Assuming you've got a variable called "query" which does the relevant
SQL query, retrieving columns "Sql1", "Sql2" and you want to call them
"Xml1" and "Xml2":

XElement container = new XElement("container",
query.Select (sqlRow => new XElement("XmlNode",
new XElement("Xml1", sqlRow.Sql1),
new XElement("Xml2", sqlRow.Sql2))
);