I'm attempting to write a web application that helps us keep track of
our PC fleet. Data on our PC's is collected by a 3rd party application
that outputs XML.
I want to load this data into Sql Server, and allow people to query it
via a web application.
My previous experience in this kind of this is using PHP and Oracle,
but now that I've moved to .Net, I want to do things the right way.
After making a few false starts, I've used the xsd inference tools to
generate a C# class that can de-serialize the XML documents.
From there I've manually created an SQL Server database, schema and
some t-sql procedures to load the data. Now that i'm coming to retrieve
the data I've realised that this was a bit cumbersome.
Can anyone let me know if the following makes sense.
--------
1. Use XSLT to convert the basic XML into a format that more accurately
reflects how I need to use the data.
2. Generate an ADO.NET dataset for these new XML documents.
3. Somehow create an SQL db schema that maps to my new DataSet file.
4. Load XML->XSLT->ADO.NET DataSet->SQL Database
5. Return AD0.NET DataSet that matches Web Query
6. Display in a custom ascx control.
Assuming that process makes sence, I know what needs to be done for
steps 1, 2 and 6.
For step 3, what tool can be used to take an ADO.NET Dataset and create
a matching set of SQL tables?
Step 4, I should be ok... but if there are any examples people can
point me at...
Step 5. Assuming that a SQL persisted dataset has a PK of some kind,
how do i retrieve all the data from that?
Thanks for any help at all.
Peter Bates