Hi Jerry,

As for XML schema, if you want to generate physical tables in DBMS
system(such as SQL Server 2005), I'm afraid .net framework haven't built-in
component or classes that can help do such direct convertion. Such task is
mostly restricted by the DBMS side.

For .NET data access classes such as DataSet, DataTables, I think you can
also use the xsd.exe tool to generate them from a given XML schem:

#XML Schema Definition Tool (Xsd.exe)
http://msdn2.microsoft.com/en-us/library/x6c1kb0s(VS.71).aspx

In the document, you can find that the xsd.exe has an command option called
"/d" which means the classes you want to generate is not normal custom
classes, but DataSet/DataTable classes.  You can try it for your XML
schemas:

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================
   

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

<OT5kLmvcIHA.148@TK2MSFTNGP04.phx.gbl>

<URL:http://msdn2.microsoft.com/en-us/library/system.data.dataset.readxmlsch
ema.aspx>