How to convert Entity framework result from base to xml?

Question

SQL

How to easily convert a table using Entity framework connection to xml? Or maybe there is a way to convert an entity table into a DataTable?

Answer 1

Banners - a link to an IQueryable database
Banner - a class of objects from the Banners table
----------------------------------

XmlSerializer xsSubmit = new XmlSerializer(typeof(List<Banner>));
var subReq = Banners.ToList();

StringWriter sww = new StringWriter();
XmlWriter writer = XmlWriter.Create(sww);
xsSubmit.Serialize(writer, subReq);
var xml = sww.ToString().Dump();