Tool or framwork to persist XML to relational tables?

I am working with the Yahoo! Developer API and there are a lot of responses that I would like to persist to relational tables (SQL Server) so that I can query it later (and over time). Is there a tool or framework that will automatically script these tables for me from sample XML or d开发者_开发问答o I have to build it manually?

XML is a type in MSSQL Server 2008 (I am assuming you're using this version). You can store the XML directly in a column and then use XPATH http://www.w3schools.com/xpath or XQUERY /xquery to mine the data later. This will prevent the pain that you would likely encounter if the schema or XSD for the XML changed over time. I haven't found any good tools or frameworks to parse the XML and generate well typed data structures to store the content.