Creating XML files using a given Schmea

[Sindarian]

I have a Schema from the folk that shows how they want the data received. I
have my own database that has that data, but in a different way (they use 33
freaking tables to store what I do in 1). Now then, do I:
a) Create a data source that jives with their schema (say, a number of views
or store procedure to represent those 33 tables, but gets it's data from my 1
table) and then create the XML file off of that or...
b) Read their Schema, seek out those elements that are of interest to me,
fill-in the data for these elements as I go and write it all to the XML file
or...
c) Do this in some other basic way that hasn't occurred to me, if so, what?

[Scott Allen]

Are you talking about a database schema or a XML schema (xsd) ?

--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 15 Feb 2005 10:45:02 -0800, Sindarian
<Si*******@discussions.microsoft.com> wrote:

I have a Schema from the folk that shows how they want the data received. I
have my own database that has that data, but in a different way (they use 33
freaking tables to store what I do in 1). Now then, do I:
a) Create a data source that jives with their schema (say, a number of views
or store procedure to represent those 33 tables, but gets it's data from my 1
table) and then create the XML file off of that or...
b) Read their Schema, seek out those elements that are of interest to me,
fill-in the data for these elements as I go and write it all to the XML file
or...
c) Do this in some other basic way that hasn't occurred to me, if so, what?

[Sindarian]

An XML Schema (xsd).

"Scott Allen" wrote:

Are you talking about a database schema or a XML schema (xsd) ?

--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 15 Feb 2005 10:45:02 -0800, Sindarian
<Si*******@discussions.microsoft.com> wrote:

I have a Schema from the folk that shows how they want the data received. I
have my own database that has that data, but in a different way (they use 33
freaking tables to store what I do in 1). Now then, do I:
a) Create a data source that jives with their schema (say, a number of views
or store procedure to represent those 33 tables, but gets it's data from my 1
table) and then create the XML file off of that or...
b) Read their Schema, seek out those elements that are of interest to me,
fill-in the data for these elements as I go and write it all to the XML file
or...
c) Do this in some other basic way that hasn't occurred to me, if so, what?

[Scott Allen]

One solution is to generate code from the XML schema file.

The XSD.EXE tool from the .NET SDK can generate typed DataSets or a
set of classes that correspond to the schema. Creating the file can be
as easy as populating a typed DataSet and calling GetXml(). This
approach is not the best fit in all scenarios, so you'll have to give
it a try and see how easy it will be to develop and maintain in your
environment.

--
Scott
http://www.OdeToCode.com/blogs/scott/
On Wed, 16 Feb 2005 08:03:03 -0800, Sindarian
<Si*******@discussions.microsoft.com> wrote:

An XML Schema (xsd).

"Scott Allen" wrote:

Are you talking about a database schema or a XML schema (xsd) ?

--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 15 Feb 2005 10:45:02 -0800, Sindarian
<Si*******@discussions.microsoft.com> wrote:

>I have a Schema from the folk that shows how they want the data received. I
>have my own database that has that data, but in a different way (they use 33
>freaking tables to store what I do in 1). Now then, do I:
>a) Create a data source that jives with their schema (say, a number of views
>or store procedure to represent those 33 tables, but gets it's data from my 1
>table) and then create the XML file off of that or...
>b) Read their Schema, seek out those elements that are of interest to me,
>fill-in the data for these elements as I go and write it all to the XML file
>or...
>c) Do this in some other basic way that hasn't occurred to me, if so, what?