Knowledge Base

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

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 "XML and the DataSet" 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:

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:

In Visual Studio .NET, on the Help menu, click Contents.
Click to expand the following nodes:
- Visual Studio .NET
- Visual Basic and Visual C#
- Accessing Data
- XML Schemas and Data
- 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).

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

REFERENCES

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

313828 Roadmap for executing XPath queries in .NET applications

313816 Roadmap for programming XML with the pull-model parser in the .NET Framework

313824 Roadmap for programming XML with the DOM-model parser in the .NET Framework

313826 Roadmap for XML schemas in the .NET Framework

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

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

For more information and other Microsoft Roadmap articles, click the following article numbers to view the articles in the Microsoft Knowledge Base:

313651 Roadmap for XML in the .NET Framework

314150 Roadmap for XML serialization in the .NET Framework

313997 Roadmap for executing XSLT transformations in .NET applications

Keywords: kbinfo kbarttyperoadmap kbwebservices KB313649

Microsoft KB Archive/313649

Contents

Roadmap for XML integration with ADO.NET

CONTENTS

SUMMARY

Overview

Architecture

Quickstart Tutorials

Walkthroughs

Microsoft Knowledge Base How To articles

Troubleshooting

REFERENCES