ORM to XML

[Michael]

How I can get XML data from ORM?

e.g.

public StoreDB pgData = new StoreDB();

public string ReadStorage()

{

    var result = from c in pgData.Objekats

                 orderby c.Naziv

                 select c;

   // how to convert, something like :

    string myXML = result.toXML()???

  // or there is another way?


}

Something like this :

string myXML;
DataSet myDS = new DataSet();
OleDbCommand MyCmd = new OleDbCommand(cSQL, oCn1.oCon);
OleDbDataAdapter myDA = new OleDbDataAdapter(MyCmd);
oCn1.ConOpen();
myDA.Fill(myDS, "Cursor1");
myXML = myDS.GetXml();

Thanks, Michael.

[Alexander]

Hello Michael,

I am afraid that currently OpenAccess does not provide such functionality. If the objects retrieved by the Linq query do not have circular references, you should be able to achieve similar results by using the standard XMLSerializer class and serializing the query result.

Best wishes,
Alexander
the Telerik team