Stuart wrote: > Tony, > I'm interested, why not just use xslt to convert the > XML directly into a U2 string and then pass in the > data using uodotnet subroutines. Is there some > advantage in using an extra step of converting to ADO?
If you know xslt, xpath, xquery, etc, knock your socks off. I'd guess there are about 5 people in this entire group who have a working proficiency with them. You can apply transformations to SGML (XML, HTML, etc) with .NET too but I wouldn't recommend it, unless you actually know how. Personally, I still consider transformations a beta technology and not quite mainstream enough to use for regular coding. YMMV, but that's another reason why I'd prefer to avoid it. A better reason is that (again very subjectively) I don't see a reason to write a transformation into a string which then needs to be reparsed via string manipulation in yet another program. If you're going to do that, just parse the data manually in UniBasic anyway. ADO.NET is a sort of universal (no pun intended) middleground for data. The dataset is pseudo-relational so it is compatible with any relational database or with MV through one of the aforementioned tools with full support for ADO.NET. You don't need to know how to put it into that format - so the process of writing a transformation manually is eliminated. And getting the data into MV is done with simple mapping through the tools provided, so again, no manual coding is required. Now that's subject to implementation, you might choose to code the mapping of dataset data directly to your database, and probably would since the XML schema almost definitely wouldn't match your application schema. While moving relational data to MV is simple, I won't pretend that it's brainless - but moving XML to relational certainly is. I guess the answer to your question is that it's simpler - not really an extra step at all. (Writing this from Las Vegas airport - wireless connectivity Rocks.) Tony >From Tony > It's very easy to create/parse XML with .NET > technologies. If you have a > schema then you can read an XML document, > convert it into an ADO.NET > dataset in one statement... ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
