Microsoft 70-487: Create and implement a WCF Data Services service

Exam Objectives

Address resources; implement filtering; create a query expression; access payload formats (including JSON); use data service interceptors and service operators

Quick Overview of Training Materials

Exam Ref 70-487 - Chapter 1.5

[Teched] Best Practices: Creating OData Services Using WCF Data Services (High Quality WMV)
[MSDN] Practical OData (2010 Article)
[Channel 9] Practical OData (2015 Conference talk)
[MSDN] WCF Data Services 5.0 Overview (Complete Docs)
[MSDN] How to: Create a Data Service Using the Reflection Provider
OData Version 4.0 URL Conventions Specification
[MSDN] Interceptors (WCF Data Services)

Microsoft 70-487: Choose data access technologies

Exam Objectives

Choose a technology (ADO.NET, Entity Framework, WCF Data Services, Azure storage) based on application requirements

Quick Overview of Training Materials

Exam Ref 70-487 - Chapter 1.1
[Teched] Data Development GPS: Choosing the Right Data Access (slides)
[Teched] Building OData Services with ASP.NET Web API
[Teched] Microsoft Azure Storage Overview

[MSDN] Summary of Data Access Guidance
[StackOverflow] Entity Framework VS LINQ to SQL VS ADO.NET
[StackOverflow] Are there good reasons not to use an ORM?
[StackExchange] Is Entity Framework Suitable For High-Traffic Websites?
[StackOverflow] When to use WCF data services and when not?
[StackOverflow] Why would you not use WCF Data Services for querying data?
[StackOverflow] What is the need of OData when I have JSON?
[MSDN] WCF Data Services 4.5
Azure Storage Service landing page
Introduction to Microsoft Azure Storage
Azure Storage 5 Minute Overview (video)
ASP.NET Data Access - Recommended Resources
[Channel9] All Data/All Day Dive into .NET Data Access
[Channel9] OData Overview (2015)
Why Entity Framework Can Be Your Best Friend
[MSDN] Storage queues vs Service Bus queues

Pluralsight Courses:
ADO.NET Fundamentals, Introduction to OData, Anything by Julie Lerman

How To Create an On-Prem Windows Build Agent for Visual Studio Team Services

Motivation

I've been working on migrating our code repositories from CVS into git hosted on Visual Studio Team Services (VSTS)... formerly Visual Studio Online.  While I've reduced the CVS migrations to running a single script, I also wanted to start exploring some of the other CI functionality VSTS offers.  Many of our projects are Maven projects, and while Maven builds are supported, I ran into a snag trying to connect to our on-prem Nexus repository.  Using the VSTS "hosted" build agents would involve one of a couple of bad work arounds:

• expose an endpoint in IIS to talk to the Nexus repo outside our firewall.  While a one-off point to point fix might solve this issue... the scenario is likely to recur, especially when I start looking at deployments
• open a vpn connection from the hosted build agent to the network.  Eww.  This would feel like a clunky solution, assuming I could get it working at all.  I could see authentication being a real obstacle for this route

The obvious solution was a private (i.e. on-prem) build agent running within our network.  I shied away from this approach at first because I didn't want to deal with the server configuration (rightly so, yuck!), but it rapidly became clear that this actually was the simpler solution. The final straw was after I tried to create a Hudson job and ended up fighting with git the whole time (couldn't find the installed binary, installed it again, long file names choked, couldn't get authentication working... quelle nightmare!)

Microsoft 70-487: Query data by using LINQ to Entities

Exam Objectives

Query data by using LINQ operators (for example, project, skip, aggregate, filter, and join); log queries and database commands; implement query boundaries (IQueryable vs. IEnumerable); implement async query

Quick Overview of Training Materials

Exam Ref 70-487 - Chapter 2.3
PluralSight - Querying the Entity Framework (Julie Lerman)
PluralSight - LINQ Fundamentals with C# 6.0 (Scott Allen)
PluralSight - Practical LINQ (Deborah Kurata)
PluralSight - More Effective LINQ (Mark Heath)
[MSDN] - LINQ to Entities
[MSDN] - DbExtensions Methods
[MSDN] - Enumerable Class
[MSDN] - Queryable Class
[MSDN] - ObjectQuery Class
StackOverflow - Returning IEnumerable<T> vs IQueryable<T>
Entity Framework: IQueryable vs. IEnumerable

My post on Basic LINQ

LINQ Basics by Example

While working on my 70-487 study guide I wrote up a looong section on basic LINQ operators that, while certainly germane, was not really the subject at hand.  So I'm refactoring that stuff into it's own post.  I look at the LINQ extension methods provided by Enumerable and Queryable (basically the same operations, just different underlying behavior), with lots of example code and console screenshots.  All the code samples can be found on my Github page for the study guide examples.