I recommend that when using hidden child and parent id's in nested tables, that they should be in the last column. This is because if they are not saved in the XML file, the .NET dataset will automatically add them into the last column. So putting them in the last column at the start will ensure that they are always in the same place.
On a second note, it is usually better practice to save the schema along with the XML file and to leave the child and parent id's intact in the XML file (i.e. do not set them their mapping types as hidden). However, in my place, the consumers of data are very likely to include non .NET platforms such as linux and embedded code (e.g. in this case the Atmel AVR).
My first intended use for this is to create XML files to store different phrases in different languages for a globalised application that I am working on at work. When I have perfected my method of internationalisation in .NET, I will probably write a little article about that and how to make a sample application.
No comments:
Post a Comment