Developer Tools

    Microsoft Data Access Development Overview

    This document describes how the Microsoft platform provides the underlying infrastructure to ensure access to disperate data sources.
    • Version:


      File Name:

      Data Access Overview.exe

      Date Published:


      File Size:

      364 KB

        Data access is a pillar of almost every business application. In fact, most business applications consist of programming that exists mainly to store, manipulate, integrate and present data about the business. Hence data access is one of the most critical aspects of any enterprise software development platform and a differentiating feature in the vendor choices facing corporate IT.
        In addition, as application development has evolved, newer applications have often become loosely coupled—based on a services-oriented and/or message-passing programming model. More and more of today's applications also use XML to encode data to be passed over network connections. This new model is very different from the connected, tightly coupled style of programming that characterized the client/server era, where a database operation was synchronous and the middle tier used a proprietary format for representing database records. In designing tools and technologies to meet the needs of today's developer, Microsoft recognized that an entirely new programming model for data access was needed, one that is built upon the .NET Framework. Building on the .NET Framework ensures that the data access technology will be uniform — components would share a common type system, design patterns, and naming conventions.
        ADO.NET is the cornerstone of data access within the Microsoft application development platform. It is the primary data access component within .NET, and is fully integrated into the .NET base framework classes. ADO.NET was designed to meet the needs of this new programming model: disconnected data architecture, tight integration with XML, common data representation with the ability to combine data from multiple and varied data sources, and optimized facilities for interacting with a database, all native to the .NET Framework. This combination of capabilities enables developers to very quickly build well-architected, scalable and secure business applications and provides a core competitive advantage for .NET developers: extremely high developer productivity.
    • Supported Operating System

      Longhorn (Windows Code Name), Windows 2000, Windows 98 Second Edition, Windows Server 2003, Windows XP

        Important: Make sure you have the latest service pack and critical updates for the version of Windows that you are running. To find recent security updates, visit Windows Update.

        1. Click the Download button on this page to start the download.
        2. Do one of the following:
          • To start the installation immediately, click Open or Run this program from its current location.
          • To copy the download to your computer for installation at a later time, click Save or Save this program to disk.

        3. Use Microsoft Word to view the document. If you do not have Microsoft Word, you can download the free Word Viewer.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Buy Office 365, get 1 TB OneDrive file storage.
    Get things done from virtually anywhere
    Buy Office 365 and get 1 TB of file storage from OneDrive.
    Buy now