Add Stylesheet reference to XML Document in Linq?

Question

I create an XML Doc and wanted have a reference to the XSLT file.

//<?xml-stylesheet type="text/xsl" href="OBReport.xslt"?>

to this XML generation:

XElement xml = new XElement("ReportedOn",
                    from dl in EL.DocumentLog.ToList()
                    join o in EL.Organization
                    on dl.OrganizationID equals o.OrganizationId
                    where dl.ActionDate >= stDate &
                    dl.ActionDate <= enDate 
                    orderby dl.DefendantName, dl.DocumentName
                    select new XElement("persons",
                              new XAttribute("documentName", dl.DocumentName),
                              new XElement("defendantName", dl.DefendantName),
                              new XElement("actionDate", dl.ActionDate.ToString()),
                              new XElement("startDate", dl.StartDate.ToString()),
                           new XElement("endDate", dl.EndDate.ToString()),
                           new XElement("organizationName" , o.OrganizationName) ));

Answer 1

Add an XProcessingInstruction element.

And not to your XElement (which can be used as a document but with limitations) but to an enveloping XDocument. So, after your code:

 XElement body = ...; // root XElement from your Linq statement 
 XDocument doc = new XDocument(
      new XProcessingInstruction("xml-stylesheet", "type='text/xsl' ref='hello.xsl'"), 
      body);