Understanding the XML object
Posted on 2009-02-14
I manage a CMS system via a .NET middle tier that blends conventional (non-xml) db fields with external XMLs. Currently, these files are hand edited.
Going forward, we need to implement code-based management of these files. Since I _could do all the things the system requires via .NET code I'm not _forced to undertake the learning curve involved with SQL's xml datatype right now. I _could use .net's xml tools to read the external file, allow the user edits, and save back to the file. But since non-xml parts of our content is stored in the db, it stands to reason that sooner or later we'll want to bring those external files into the db as well.
I guess I'm looking for an excuse to procrastinate the sql/xml learning curve or a kick in the butt to get in gear.
In that context....
Where's the best place to get a 'narrative' overview of how I would use the XML datatype to bring existing XML structures from files to the db?