Geen categorie

Exam 70-487 Preparation, Part I: Accessing Data

Note: this blog is no longer maintained. Please go here to see the latest updates of this post.

This is the first part in the Exam 70-487 preparation materials series. This post will cover all objectives regarding data access. If you want to see all of this in action, check out the Github repository.


  • Choose data access technologies
    • Choose a technology (ADO.NET, Entity Framework, WCF Data Services, Azure storage) based on application requirements
  • Implement caching
    • Cache static data, apply cache policy (including expirations); use CacheDependency to refresh cache data; query notifications
  • Implement transactions
    • Manage transactions by using the API from System.Transactions namespace; implement distributed transactions; specify transaction isolation level
  • Implement data storage in Azure
    • Access data storage in Azure; choose data storage mechanism in Azure (blobs, tables, queues, SQL Database); distribute data by using the Content delivery network (CDN); handle exceptions by using retries (SQL Database); manage Azure Caching
  • Create and implement a WCF Data Services service
    • Address resources; implement filtering; create a query expression; access payload formats (including JSON); use data service interceptors and service operators
  • Manipulate XML data structures
    • Read filter, create, modify XML data structures; Manipulate XML data by using XMLReader, XMLWriter, XMLDocument, XPath, LINQ to XML; transform XML by using XSLT transformations

Useful Links

Choose data access technologies


Entity Framework

Implement caching

Implement transactions

Implement data storage in Windows Azure

Create and implement a WCF Data Services service

Manipulate XML data structures






Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s