Hello Experts, I have to migrate an application that receives some XML files through a network interface. It parses them and saves them in a Oracle 10g database. The XML file is quite complicated and can mandate updates in 7 tables, depending on its content. Since this app that I must develop is .NET, I don't care about recordsets anymore. Instead it should use ADO.NET and the Oracle .NET Data Provider that comes with 10g. One approach is to instantiate some structures with information from the XML file (can those structure be generated automatically, based on the XML schema in VS.NET 2003?) and then have those structures saved in the database, each structure in its corresponding table. However, I have the feeling that there must be a more elegant solution (for Christ Sake, this is year 2004 and we have VS.NET 2K3, a wonderful RAD tool). Is there a way to tie the XmlDocument to some DataSets and then just save the DataSets in the database in just a few code statements? Options, ideas, suggested articles, web resources or anything else that can help will be much appreciated.
Thanks, Eddie =================================== This list is hosted by DevelopMentor� http://www.develop.com Some .NET courses you may be interested in: Essential .NET: building applications and components with C# November 29 - December 3, in Los Angeles http://www.develop.com/courses/edotnet View archives and manage your subscription(s) at http://discuss.develop.com
