Gustav Brock
Gustav at cactus.dk
Tue Oct 13 16:25:35 CDT 2009
Hi Shamil Thanks for the insight. But could you tell a bit of your reasons for not using datasets when you in your next post ask "do you know a way to implement XML in memory serialization using less code lines?" Don't get me wrong (that counts for JC as well) - I'm not on a mission for datasets - I just found them extremely convenient when I for a recent small project needed to read, list, and archive structured data as simple as possible using standardized methods (not reinventing anything) assuming I couldn't be the first on this planet having that need. With datasets I can design a table schema much the usual way with relations, referential integrity, autonumbers, required and/or unique fields etc. etc. - and write the whole stuff to an XML file with a single line of code. To me, this is one of the tools of VS which saves you much trouble and time. Of course, many cases can probably be listed where this is too limited but for quite a few projects the datasets will fill the bill. /gustav >>> shamil at smsconsulting.spb.ru 13-10-2009 21:26 >>> Hi John, You can use XMlArray attribute to define the name of XML group of serialized arrays, collections, lists,.. http://msdn.microsoft.com/en-us/library/system.xml.serialization.xmlattribut es.xmlarray.aspx BTW, guys and gals, I'm programming on C# every day - I forgot when I last time used DataSets typed or not, well, that could be specifics of my subject area, but for example for a large ASP.NET site I developed, multi-layered with several thousands of custom classes etc. , DataSets were not used at all - and that large ASP.NET site is a business application with MS SQL 2005 backend... Just out of curiosity I have just checked DotNetNuke Community Edition 5.1.4 sources http://dotnetnuke.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=33848 to find out how much times DataSet is used in these sources - here is my search result: === Matching lines: 22 Matching files: 5 Total files searched: 1414 === -- Shamil -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Tuesday, October 13, 2009 8:13 PM To: Discussion concerning Visual Basic and related programming issues. Subject: Re: [dba-VB] C# serialization > Of course, I can see an educational purpose by handcrafting a kind of database, but ... LOL. Well, this is after a CLASS in C# the purpose of which is to LEARN C#. You do not start at typed data sets, you start with "this is a variable" and "this is a for loop". I am very much at that level. I am quite sure that in a year I will be throwing out typed datasets with the best of them but right now I am still forgetting to put a ; at the end of the line. Have patience Master #2. John W. Colby www.ColbyConsulting.com Gustav Brock wrote: > Hi John > > Sounds like a quite normal database app to me ... > > If so, all the typed dataset stuff is ready at your hands. > To persist (to an XML file without the overhead you claim about) use method WriteXml. > To read it at load, use method ReadXml. Can't be simpler. > > Of course, I can see an educational purpose by handcrafting a kind of database, but ... > > /gustav