Data Access Guidance – Reference Implementation

    This guide has an accompanying reference implementation of an online ordering system. The sample code illustrates how to implement a polyglot solution that stores data in a variety of SQL and NoSQL databases, and how to decouple the data access logic from the business logic of the application.
    • Version:


      File Name:

      Patterns and Practices Data Access Guide.Source.Exe

      Date Published:


      File Size:

      1.4 MB

        This sample code is the reference implementation of an online ordering system that illustrates how to design and architect a polyglot solution. The application stores data in SQL and NoSQL databases.

        The application utilizes SQL Server as a relational database for holding customer and order details, but stores the product catalog and order history information in a document database, product recommendations in a graph database, and shopping cart data in a key-value database. The sample code shows how to implement operations that require transactional consistency across different data stores. It also illustrates how to use the Repository pattern to eliminate dependencies between the structure of the data in each database and the business logic that processes this data.

        See the Readme and Release Notes for information about installing and configuring the reference implementation.
    • Supported Operating System

      Windows 7, Windows 8, Windows 8.1, Windows Server 2008 R2 SP1, Windows Server 2012

      • Select the 'Download Now' link to commence the download.

        Save the file to your hard drive. The samples are packaged as a self-extractable zip file.

        Run the file and accept the End User Licensing Agreement to proceed.

        The files will be extracted to your chosen destination folder. This must not be a folder in your profile. Use a folder near the root of your drive with a short name to avoid issues with the length of filenames.

        See the Readme and Release Notes for information about the specific versions required, and installing and configuring the reference implementation.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

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

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial