How to unload data from ms sql based on xsd schema?

Question

C++ / C#

Is it possible to unload data from the ms sql database to xml in a "programmatic" way, based on the xsd schema? The structure of this database is created in advance based on xsd (I use DataSet.ReadXmlSchema and create a database structure based on it).

Answer 1

For example, you can immediately generate xml on the server using a query like "select ... from table where column = 1 FOR XML PATH" Read more MSDN