Microsoft KB Archive/313649

= Roadmap for XML integration with ADO.NET =

Article ID: 313649

Article Last Modified on 6/7/2006

-

APPLIES TO


 * Microsoft .NET Framework 1.1 Service Pack 1
 * Microsoft .NET Framework 1.1

-



This article was previously published under Q313649



CONTENTS
 SUMMARY

OverviewArchitectureQuickstart TutorialsWalkthroughsMicrosoft Knowledge Base HowTo ArticlesTroubleshooting

 REFERENCES



SUMMARY
This article provides a roadmap to understand the integration of Extensible Markup Language with ADO.NET.

To assist you with learning a Microsoft product or technology, roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and white papers.

back to the top

Overview
Often programmers must integrate XML with relational data. The Microsoft .NET Framework recognizes this need and can integrate ADO.NET with XML at multiple levels. Two key classes facilitate this integration: the DataSet class and the XmlDataDocument class. These classes provide two different views on that same data: hierarchical view and relational view.

DataSet can be populated from a relational backend or XML backend. This provides a relational view on the data. After DataSet is populated, regardless of the choice of backend, you can extract XML data from it.

XmlDataDocument provides a bridge between hierarchical and relational views. It binds with a DataSet to provide an XML view on the same data. As a result, all XML services [such as Extensible Stylesheets Language Transformations (XSLT) and XML Path Language (XPath)] are available on relational data.

You can save or load the structure of a DataSet as XML schema. In addition, you can use XML schemas to make typed DataSet classes. As the name implies, a typed DataSet is strongly typed and can access tables and columns by name instead of collection-based methods.

For more specific information about XML and the DataSet class, refer to the &quot;XML and the DataSet&quot; topics in the Visual Studio .NET Online Help documentation.

For an overview of ADO.NET integration with XML, refer to the following MSDN Magazine article:

Introducing ADO+: data access services for the Microsoft .NET Framework

http://msdn.microsoft.com/msdnmag/issues/1100/adoplus/default.aspx

back to the top

Architecture
For architectural (or internal) information about XmlDataDocument and DataSet integration, refer to the following Microsoft Web site:

How do I...use XML and the DataSet?

http://samples.gotdotnet.com/quickstart/howto/doc/xml/xmldataset.aspx

back to the top

Quickstart Tutorials
For ADO.NET and XML Quickstart tutorials, refer to the following Microsoft Web sites:

How do I...read and write XML?

http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/adoplus/readandwritexml.aspx

How do I...generate XML with data from SQL Server?

http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/adoplus/xmlfromsqlsrv.aspx

How do I...load a DataSet with XML?

http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/xml/loaddatasetxmldata.aspx

How do I...save a DataSet as XML?

http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/xml/savedatasetxml.aspx

How do I...create DataSet mappings from an XSD schema?

http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/xml/datasetmapxsdschema.aspx

How do I...save DataSet mappings to an XSD schema file?

http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/xml/savedatasetmapxsdschema.aspx

How do I...load XML data into an XmlDataDocument?

http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/xml/loadxmldocument.aspx

How do I...read XML from an XmlDataDocument?

http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/xml/streamxmldocument.aspx

How do I...infer DataSet mappings from XML?

http://samples.gotdotnet.com/quickstart/howto/doc/Xml/DataSetMapXMLData.aspx

back to the top

Walkthroughs
Walkthroughs provide short tutorials and hands-on instructions that walk you through typical application development scenarios. To access the walkthroughs on this topic, refer to the Visual Studio .NET Online Help documentation:
 * 1) In Visual Studio .NET, on the Help menu, click Contents.
 * 2) Click to expand the following nodes:
 * 3) * Visual Studio .NET
 * 4) * Visual Basic and Visual C#
 * 5) * Accessing Data
 * 6) * XML Schemas and Data
 * 7) * XML Walkthroughs

You can also use the Search feature on Help menu, and use the Walkthrough and XML keywords to search for walkthroughs.

back to the top

Microsoft Knowledge Base How To articles
Microsoft Knowledge Base How To articles provide step-by-step instructions to accomplish a specific task.

309702 How to read XML data into a DataSet by using Visual Basic .NET

311566 How to read XML data into a DataSet by using Visual C# .NET

307224 How to use XML in connected and disconnected ADO.NET applications

308064 How to persist an ADO.NET DataSet as XML by using Visual Basic .NET

309183 How to persist an ADO.NET DataSet as XML by using Visual C# .NET

310345 How to render DataTable columns as XML attributes by using Visual Basic .NET

311937 How to render DataTable columns as XML attributes instead of elements by using C# .NET

301271 How to save a DataSet class as XML in .NET Framework SDK

311570 How to read XML data into dataset by using Visual C++ .NET

309184 How to persist an ADO.NET DataSet into XML by using Visual C++ .NET

You can also perform the following search at the Microsoft Help and Support Web site

http://support.microsoft.com/search/?adv=1


 * In the Search Product list, select More Products, click Others, and then select .NET Framework.
 * In the Using list, click Boolean (text contains AND/OR).
 * In the For text box, type the following Boolean query (or type a subset of the following Boolean query): kbXML AND (DataSet OR XmlDataDocument or SQL or ADO).
 * In the For text box, type the following Boolean query (or type a subset of the following Boolean query): kbXML AND (DataSet OR XmlDataDocument or SQL or ADO).

back to the top

Troubleshooting
If you encounter problems and need answers to your questions, consult the MSDN newsgroups. The MSDN newsgroups are the best place to obtain answers to your questions. In the MSDN newsgroups, you can share your experiences with your peers or search the Microsoft Knowledge Base for articles about specific issues:

MSDN Newsgroups

http://msdn.microsoft.com/newsgroups/

Searching the Knowledge Base

http://support.microsoft.com/search

microsoft.public.dotnet.xml newsgroup

http://msdn.microsoft.com/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microsoft.public.dotnet.xml

NOTE: If you already subscribed to the microsoft.public.dotnet.xml newsgroup, you can access the newsgroup from the following URL:

news://msnews.microsoft.com/microsoft.public.dotnet.xml

You can also post questions on this topic to following ADO.NET newsgroup:

microsoft.public.dotnet.framework.adonet newsgroup

http://msdn.microsoft.com/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microsoft.public.dotnet.framework.adonet

NOTE: If you already subscribed to the microsoft.public.dotnet.framework.adonet newsgroup, you can access the newsgroup from the following URL:

news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet

back to the top

