convert LinqToSQL result to xml

See more:

XML

LINQ

I want to convert my L2S result into XML

here is my code

Dim linq_result = From c in db.customers select c

dim xml1 as New XElement("customers",from xc in linq_result Select xc )

dim xml2 as New XElement("customers",from xc in linq_result Select xc.field1,xc.field2 )

xml1.Save(c:\folder\xml1.xml)

xml2.Save(c:\folder\xml2.xml)

xml1 result is not valid

xml2 result is valid because I explicitly chose the fields

let say I have 25 fields, should I write them all ? is there * such as sql server?

Thanks