Databases
StackOverflow2013
Postsdbo
POProper way to implement IXmlSerializable?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POProper way to implement IXmlSerializable?
    primarykey
    data
    text
    <p>Once a programmer decides to implement <code>IXmlSerializable</code>, what are the rules and best practices for implementing it? I've heard that <code>GetSchema()</code> should return <code>null</code> and <code>ReadXml</code> should move to the next element before returning. Is this true? And what about <code>WriteXml</code> - should it write a root element for the object or is it assumed that the root is already written? How should child objects be treated and written?</p> <p>Here's a sample of what I have now. I'll update it as I get good responses.</p> <pre><code>public class MyCalendar : IXmlSerializable { private string _name; private bool _enabled; private Color _color; private List&lt;MyEvent&gt; _events = new List&lt;MyEvent&gt;(); public XmlSchema GetSchema() { return null; } public void ReadXml(XmlReader reader) { if (reader.MoveToContent() == XmlNodeType.Element &amp;&amp; reader.LocalName == "MyCalendar") { _name = reader["Name"]; _enabled = Boolean.Parse(reader["Enabled"]); _color = Color.FromArgb(Int32.Parse(reader["Color"])); if (reader.ReadToDescendant("MyEvent")) { while (reader.MoveToContent() == XmlNodeType.Element &amp;&amp; reader.LocalName == "MyEvent") { MyEvent evt = new MyEvent(); evt.ReadXml(reader); _events.Add(evt); } } reader.Read(); } } public void WriteXml(XmlWriter writer) { writer.WriteAttributeString("Name", _name); writer.WriteAttributeString("Enabled", _enabled.ToString()); writer.WriteAttributeString("Color", _color.ToArgb().ToString()); foreach (MyEvent evt in _events) { writer.WriteStartElement("MyEvent"); evt.WriteXml(writer); writer.WriteEndElement(); } } } public class MyEvent : IXmlSerializable { private string _title; private DateTime _start; private DateTime _stop; public XmlSchema GetSchema() { return null; } public void ReadXml(XmlReader reader) { if (reader.MoveToContent() == XmlNodeType.Element &amp;&amp; reader.LocalName == "MyEvent") { _title = reader["Title"]; _start = DateTime.FromBinary(Int64.Parse(reader["Start"])); _stop = DateTime.FromBinary(Int64.Parse(reader["Stop"])); reader.Read(); } } public void WriteXml(XmlWriter writer) { writer.WriteAttributeString("Title", _title); writer.WriteAttributeString("Start", _start.ToBinary().ToString()); writer.WriteAttributeString("Stop", _stop.ToBinary().ToString()); } } </code></pre> <p>Corresponding Sample XML</p> <pre><code>&lt;MyCalendar Name="Master Plan" Enabled="True" Color="-14069085"&gt; &lt;MyEvent Title="Write Code" Start="-8589241828854775808" Stop="-8589241756854775808" /&gt; &lt;MyEvent Title="???" Start="-8589241828854775808" Stop="-8589241756854775808" /&gt; &lt;MyEvent Title="Profit!" Start="-8589247048854775808" Stop="-8589246976854775808" /&gt; &lt;/MyCalendar&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGreg
    1. USGreg
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POProper way to implement IXmlSerializable?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POProper way to implement IXmlSerializable?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POProper way to implement IXmlSerializable?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCould you add an xml sample to this question? It would make it simpler to read along with the code. Thanks!
      singulars
      1. POProper way to implement IXmlSerializable?
      1. USRory
    2. COWhat about dealing with the case where there's an XML comment etc after the last Event in your xml. ie should you finish the ReadXml() method with something that checks that you read through to the end element? Currently this assumes the last Read() does that but it might not always.
      singulars
      1. POProper way to implement IXmlSerializable?
      1. USRory
    3. CO@Rory - Sample added. Better late than never?
      singulars
      1. POProper way to implement IXmlSerializable?
      1. USGreg
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload