Today I read a thread on mycsharp.de asking about how man can work with a database whose type is a interlace XML. The XML file has following structure

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DatenbankSpiel" targetNamespace="http://Weltkarte/DantenbankAll" elementFormDefault="qualified" xmlns="http://Weltkarte/DantenbankAll.xsd" xmlns:mstns="http://Weltkarte/DantenbankAll.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="Staedte">
<xs:complexType>
<xs:sequence>
<xs:element name="Name" type="xs:string"/>
<xs:element name="Fraktion" type="xs:int"/>
<xs:element name="Position-X" type="xs:int"/>
<xs:element name="Position-Y" type="xs:int"/>
<xs:element name="Verteidigung-Anzahl">
<xs:complexType>
<xs:sequence>
<xs:element name="Anzahl" />
<xs:element name="Typ" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

As you can see that there is a child table “Verteidigung-Anzahl” …

Today when I start to play around with developing on Windows Phone 7, I would like to write a first small database application because Windows Phone does not support SQL Server any more. Therefore I must use either LINQ over XML or store the database somewhere on server/Windows Azure and provide services so that the client can access and make query to get and update data. In this small example, I would like to work …