{"id":304,"date":"2011-06-06T10:35:41","date_gmt":"2011-06-06T08:35:41","guid":{"rendered":"http:\/\/hen.co.za\/blog\/?p=304"},"modified":"2011-06-07T11:30:19","modified_gmt":"2011-06-07T09:30:19","slug":"xml-file-as-a-database-part-3","status":"publish","type":"post","link":"https:\/\/hen.co.za\/blog\/2011\/06\/xml-file-as-a-database-part-3\/","title":{"rendered":"Xml file as a database – part 3"},"content":{"rendered":"

Last time<\/a> I stopped with the sample code how to produce a DataSet in code and then save and load it from a file. This time I’ll just continue with the ‘typed’ DataSet version plus show what the output would look like. Interestingly, the output of both the untyped and typed versions looks (essentially) the same.<\/p>\n

First I’ll show how the Typed DataSet version works. Just to refresh the old minds – to create a Typed DataSet you use Visual Studio’s new template for a DataSet xsd and then use the designer to add tables, columns and relationships. Then in code you can do the following (the DataSet is named ‘DatabaseTest’):<\/p>\n

DatabaseTest <\/span>dbt = new DatabaseTest<\/span>();
\nDatabaseTest.SurnameRow<\/span> surname = (DatabaseTest.SurnameRow<\/span>)dbt.Surname.NewRow();
\nsurname.Surname = “Henning”;
\nsurname.TS = DateTime<\/span>.Now;
\ndbt.Surname.AddSurnameRow(surname);
\nsurname = (DatabaseTest.SurnameRow)dbt.Surname.NewRow();
\nsurname.Surname = “Van Der Merwe”;
\nsurname.TS = DateTime<\/span>.Now;
\ndbt.Surname.AddSurnameRow(surname);<\/p>\n

DatabaseTest.PersonRow<\/span> pa = (DatabaseTest.PersonRow<\/span>)dbt.Person.NewRow();
\npa.FirstName = “Daddy Koos”;
\npa.SurnameId = 1;
\npa.TS = DateTime<\/span>.Now;
\npa.YearOfBirth = 1945;
\ndbt.Person.AddPersonRow(pa);<\/p>\n

DatabaseTest.PersonRow<\/span> ma = (DatabaseTest.PersonRow<\/span>)dbt.Person.NewRow();
\nma.FirstName = “Mommy Johanna”;
\nma.SurnameId = 2;
\nma.TS = DateTime<\/span>.Now;
\nma.YearOfBirth = 1950;
\ndbt.Person.AddPersonRow(ma);<\/p>\n

DatabaseTest.PersonRow<\/span> guy = (DatabaseTest.PersonRow<\/span>)dbt.Person.NewRow();
\nguy.FirstName = “Little Koos”;
\nguy.SurnameId = 1;
\nguy.TS = DateTime<\/span>.Now;
\nguy.YearOfBirth = 1971;
\nguy.FatherID = 1;
\nguy.MotherID = 2;
\nguy.ChildNo = 1;
\ndbt.Person.AddPersonRow(guy);<\/p>\n

if <\/span>(saveFileDialogXml.ShowDialog() == System.Windows.Forms.DialogResult<\/span>.OK)
\n{<\/p>\n

if<\/span> (System.IO.File<\/span>.Exists(saveFileDialogXml.FileName))<\/p>\n

System.IO.File<\/span>.Delete(saveFileDialogXml.FileName);<\/p>\n

dbt.WriteXml(saveFileDialogXml.FileName, XmlWriteMode<\/span>.WriteSchema);<\/p>\n

var <\/span>people = (from<\/span> p in <\/span>dbt.Person
\njoin <\/span>s in dbt.Surname on <\/span>p.SurnameId equals <\/span>s.Id
\nselect<\/span> new
\n{<\/p>\n

PersonId = p.Id,
\nFirstName = p.FirstName,
\nSurname = s.Surname<\/p>\n

});
\nStringBuilder <\/span>sb = new StringBuilder<\/span>();
\nforeach <\/span>(var<\/span> p in <\/span>people)
\n{<\/p>\n

sb.AppendLine(string<\/span>.Format(“{0} {1}”, p.FirstName, p.Surname));<\/p>\n

}
\nMessageBox.Show(sb.ToString());<\/p>\n

System.Diagnostics.Process <\/span>pro = new <\/span>System.Diagnostics.Process<\/span>();
\npro.StartInfo = new<\/span> System.Diagnostics.ProcessStartInfo<\/span>(System.IO.Path<\/span>.Combine(System.Environment<\/span>.GetFolderPath(Environment.SpecialFolder.System), “notepad.exe”));
\npro.StartInfo.Arguments = “\\”” + saveFileDialogXml.FileName + “\\””;
\npro.Start();<\/p>\n

}<\/p><\/blockquote>\n

This provides the same functionality as before. The output looks something like this (sorry, I’m a bit lazy to format\/indend the output too much now):<\/p>\n

<?xml version=”1.0″ standalone=”yes”?>
\n<DatabaseTest xmlns=”http:\/\/tempuri.org\/DatabaseTest.xsd”>
\n<xs:schema id=”DatabaseTest” targetNamespace=”http:\/\/tempuri.org\/DatabaseTest.xsd” xmlns:mstns=”http:\/\/tempuri.org\/DatabaseTest.xsd” xmlns=”http:\/\/tempuri.org\/DatabaseTest.xsd” xmlns:xs=”http:\/\/www.w3.org\/2001\/XMLSchema” xmlns:msdata=”urn:schemas-microsoft-com:xml-msdata” attributeFormDefault=”qualified” elementFormDefault=”qualified”>
\n<xs:element name=”DatabaseTest” msdata:IsDataSet=”true” msdata:UseCurrentLocale=”true”>
\n<xs:complexType>
\n<xs:choice minOccurs=”0″ maxOccurs=”unbounded”>
\n<xs:element name=”Person<\/span>“>
\n<xs:complexType>
\n<xs:sequence>
\n<xs:element name=”Id<\/span>” msdata:AutoIncrement=”true” msdata:AutoIncrementSeed=”1″ type=”xs:int<\/span>” \/>
\n<xs:element name=”FirstName<\/span>” type=”xs:string<\/span>” \/>
\n<xs:element name=”SurnameId<\/span>” type=”xs:int<\/span>” \/>
\n<xs:element name=”Description<\/span>” type=”xs:string<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”YearOfBirth<\/span>” type=”xs:int<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”MonthOfBirth<\/span>” type=”xs:unsignedByte<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”DayOfBirth<\/span>” type=”xs:unsignedByte<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”TS<\/span>” type=”xs:dateTime<\/span>” \/>
\n<xs:element name=”FatherID<\/span>” type=”xs:int<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”MotherID<\/span>” type=”xs:int<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”PlaceOfBirthId<\/span>” type=”xs:int<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”YearOfDeath<\/span>” type=”xs:int<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”MonthOfDeath<\/span>” type=”xs:unsignedByte<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”DayOfDeath<\/span>” type=”xs:unsignedByte<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”PlaceOfDeathId<\/span>” type=”xs:int<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”GenealogicalNo<\/span>” type=”xs:string<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”ChildNo<\/span>” type=”xs:unsignedByte<\/span>” default=”0″ minOccurs=”0″ \/>
\n<xs:element name=”ProgenitorCode<\/span>” type=”xs:string<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”IsProgenitor<\/span>” type=”xs:boolean<\/span>” minOccurs=”0″ \/>
\n<\/xs:sequence>
\n<\/xs:complexType>
\n<\/xs:element>
\n<xs:element name=”Surname<\/span>“>
\n<xs:complexType>
\n<xs:sequence>
\n<xs:element name=”Id<\/span>” msdata:AutoIncrement=”true” msdata:AutoIncrementSeed=”1″ type=”xs:int<\/span>” \/>
\n<xs:element name=”Surname<\/span>” type=”xs:string<\/span>” \/>
\n<xs:element name=”TS<\/span>” type=”xs:dateTime<\/span>” \/>
\n<\/xs:sequence>
\n<\/xs:complexType>
\n<\/xs:element>
\n<xs:element name=”Place<\/span>“>
\n<xs:complexType>
\n<xs:sequence>
\n<xs:element name=”Id<\/span>” msdata:AutoIncrement=”true” msdata:AutoIncrementSeed=”1″ type=”xs:int<\/span>” \/>
\n<xs:element name=”Place<\/span>” type=”xs:string<\/span>” \/>
\n<xs:element name=”TS<\/span>” type=”xs:dateTime<\/span>” \/>
\n<\/xs:sequence>
\n<\/xs:complexType>
\n<\/xs:element>
\n<xs:element name=”Marriage<\/span>“>
\n<xs:complexType>
\n<xs:sequence>
\n<xs:element name=”Id<\/span>” msdata:AutoIncrement=”true” msdata:AutoIncrementSeed=”1″ type=”xs:int<\/span>” \/>
\n<xs:element name=”No<\/span>” type=”xs:unsignedByte<\/span>” default=”0″ minOccurs=”0″ \/>
\n<xs:element name=”HusbandId<\/span>” type=”xs:int<\/span>” \/>
\n<xs:element name=”WifeId<\/span>” type=”xs:int<\/span>” \/>
\n<xs:element name=”YearOfMarriage<\/span>” type=”xs:int<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”MonthOfMarriage<\/span>” type=”xs:unsignedByte<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”DayOfMarriage<\/span>” type=”xs:unsignedByte<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”PlaceOfMarriageId<\/span>” type=”xs:int<\/span>” minOccurs=”0″ \/>
\n<xs:element name=”YearOfDivorce<\/span>” type=”xs:int<\/span>” minOccurs=”0″ \/>
\n<\/xs:sequence>
\n<\/xs:complexType>
\n<\/xs:element>
\n<\/xs:choice>
\n<\/xs:complexType>
\n<xs:unique name=”Constraint1″ msdata:PrimaryKey=”true”>
\n<xs:selector xpath=”.\/\/mstns:Person” \/>
\n<xs:field xpath=”mstns:Id” \/>
\n<\/xs:unique>
\n<xs:unique name=”Surname_Constraint1″ msdata:ConstraintName=”Constraint1″ msdata:PrimaryKey=”true”>
\n<xs:selector xpath=”.\/\/mstns:Surname” \/>
\n<xs:field xpath=”mstns:Id” \/>
\n<\/xs:unique>
\n<xs:unique name=”Constraint2″>
\n<xs:selector xpath=”.\/\/mstns:Surname” \/>
\n<xs:field xpath=”mstns:Surname” \/>
\n<\/xs:unique>
\n<xs:unique name=”Place_Constraint1″ msdata:ConstraintName=”Constraint1″ msdata:PrimaryKey=”true”>
\n<xs:selector xpath=”.\/\/mstns:Place” \/>
\n<xs:field xpath=”mstns:Id” \/>
\n<\/xs:unique>
\n<xs:unique name=”Place_Constraint2″ msdata:ConstraintName=”Constraint2″>
\n<xs:selector xpath=”.\/\/mstns:Place” \/>
\n<xs:field xpath=”mstns:Place” \/>
\n<\/xs:unique>
\n<xs:unique name=”Marriage_Constraint1″ msdata:ConstraintName=”Constraint1″ msdata:PrimaryKey=”true”>
\n<xs:selector xpath=”.\/\/mstns:Marriage” \/>
\n<xs:field xpath=”mstns:Id” \/>
\n<\/xs:unique>
\n<xs:keyref name=”FK_Person_Marriage” refer=”Constraint1″>
\n<xs:selector xpath=”.\/\/mstns:Marriage” \/>
\n<xs:field xpath=”mstns:HusbandId” \/>
\n<\/xs:keyref>
\n<xs:keyref name=”FK_Person_Marriage1″ refer=”Constraint1″>
\n<xs:selector xpath=”.\/\/mstns:Marriage” \/>
\n<xs:field xpath=”mstns:WifeId” \/>
\n<\/xs:keyref>
\n<xs:keyref name=”FK_Person_Person1″ refer=”Constraint1″>
\n<xs:selector xpath=”.\/\/mstns:Person” \/>
\n<xs:field xpath=”mstns:MotherID” \/>
\n<\/xs:keyref>
\n<xs:keyref name=”FK_Person_Surname” refer=”Surname_Constraint1″>
\n<xs:selector xpath=”.\/\/mstns:Person” \/>
\n<xs:field xpath=”mstns:SurnameId” \/>
\n<\/xs:keyref>
\n<xs:keyref name=”FK_Place_Person” refer=”Place_Constraint1″>
\n<xs:selector xpath=”.\/\/mstns:Person” \/>
\n<xs:field xpath=”mstns:PlaceOfBirthId” \/>
\n<\/xs:keyref>
\n<xs:keyref name=”FK_Person_Person” refer=”Constraint1″>
\n<xs:selector xpath=”.\/\/mstns:Person” \/>
\n<xs:field xpath=”mstns:FatherID” \/>
\n<\/xs:keyref>
\n<\/xs:element>
\n<\/xs:schema><\/p>\n

<Person>
\n<Id>1<\/Id>
\n<FirstName>Daddy Koos<\/FirstName>
\n<SurnameId>1<\/SurnameId>
\n<YearOfBirth>1945<\/YearOfBirth>
\n<TS>2011-06-06T09:15:58.0021555+02:00<\/TS>
\n<ChildNo>0<\/ChildNo>
\n<\/Person>
\n<Person>
\n<Id>2<\/Id>
\n<FirstName>Mamma Johanna<\/FirstName>
\n<SurnameId>2<\/SurnameId>
\n<YearOfBirth>1950<\/YearOfBirth>
\n<TS>2011-06-06T09:52:51.4151521+02:00<\/TS>
\n<ChildNo>0<\/ChildNo>
\n<\/Person>
\n<Person>
\n<Id>3<\/Id>
\n<FirstName>Little Koos<\/FirstName>
\n<SurnameId>1<\/SurnameId>
\n<YearOfBirth>1971<\/YearOfBirth>
\n<TS>2011-06-06T09:52:51.4151521+02:00<\/TS>
\n<FatherID>1<\/FatherID>
\n<MotherID>2<\/MotherID>
\n<ChildNo>1<\/ChildNo>
\n<\/Person><\/p>\n

<Surname>
\n<Id>1<\/Id>
\n<Surname>Henning<\/Surname>
\n<TS>2011-06-06T09:15:57.9771555+02:00<\/TS>
\n<\/Surname>
\n<Surname>
\n<Id>2<\/Id>
\n<Surname>Van Der Merwe<\/Surname>
\n<TS>2011-06-06T09:52:51.4121521+02:00<\/TS>
\n<\/Surname><\/p>\n

<\/DatabaseTest><\/p><\/blockquote>\n

As you can see the xsd is actually embedded inside the xml file. This is helpful to see the structure of the data.<\/p>\n

Next step<\/h2>\n

The next step is to create a Data Access Layer because dealing with a DataSet directly in code is so… old fashioned… and so on. Stay tuned for the next iteration.<\/p>\n","protected":false},"excerpt":{"rendered":"

Last time I stopped with the sample code how to produce a DataSet in code and then save and load it from a file. This time I’ll just continue with the ‘typed’ DataSet version plus show what the output would …<\/p>\n

Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[7,9,35,37,36,303,34],"class_list":["post-304","post","type-post","status-publish","format-standard","hentry","category-development","tag-net","tag-code","tag-data","tag-database","tag-dataset","tag-development","tag-xml"],"_links":{"self":[{"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/posts\/304","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/comments?post=304"}],"version-history":[{"count":7,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/posts\/304\/revisions"}],"predecessor-version":[{"id":310,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/posts\/304\/revisions\/310"}],"wp:attachment":[{"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/media?parent=304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/categories?post=304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/tags?post=304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}