Microsoft 70-487: Consume WCF services

Exam Objectives

Generate proxies by using SvcUtil; generate proxies by creating a service reference; create and implement channel factories

Quick Overview of Training Materials

Exam Ref 70-487 - Chapter 3.5
[Book] Programming WCF Services

[MSDN] Clients

[MSDN] Accessing Services Using a WCF Client
[CSharpCorner] Channel Factory in WCF

PluralSight WCF Library
My github repo for WCF Examples

Microsoft 70-487: Configure WCF services by using the API

Exam Objectives

Configure service behaviors; configure service endpoints; configure binding; specify a service contract; expose service metadata (XSDs, WSDL, and metadata exchange); WCF routing and discovery features

Quick Overview of Training Materials

Exam Ref 70-487 - Chapter 3.3
[Book] Programming WCF Services (in particular, Appendix C: Discovery)
[MSDN] Configuring WCF Services in Code (.NET 4.5+)

[MSDN] How to: Publish Metadata for a Service Using Code

[MSDN] How to: Create a Service Endpoint in Code
[MSDN] WCF Discovery
[MSDN] Routing

PluralSight WCF Library - WCF Power Topics in particular (routing and discovery)
My post on file based config

My github repo for WCF Examples

Microsoft 70-487: Configure WCF services by using configuration settings

Exam Objectives

Configure service behaviors; configure service endpoints; configure bindings including WebSocket bindings; specify a service contract; expose service metadata (XSDs, WSDL, and metadata exchange endpoint); configure message compression and encoding

Quick Overview of Training Materials

Exam Ref 70-487 - Chapter 3.2
[MSDN] Configuring Services Using Configuration Files
[MSDN] Configuring and Extending the Runtime with Behaviors
[MSDN] Reference Source (.NET Source code search!)
[MSDN] Windows Communication Foundation Bindings
[MSDN] System-Provided Bindings
[MSDN] Choosing a Message Encoder

My Post - PluralSight WCF Library

My GitHub Repo with the WCF Examples.

Microsoft 70-487: Create a WCF service

Exam Objectives

Create contracts (service, data, message, callback, and fault); implement message inspectors; implement asynchronous operations in the service

Quick Overview of Training Materials

Exam Ref 70-487 - Chapter 3.1
[Book] Programming WCF Services
[MSDN] Define a Windows Communication Foundation Service Contract

[MSDN] Using Data Contracts
[MSDN] Using Message Contracts
[MSDN] Fault Contract
[MSDN] Create a Duplex Contract
[MSDN] Message Inspectors
[MSDN] How to inspect and modify WCF message via custom MessageInspector
[MSDN] How to modify a WCF message using an IDispatchMessageInspector?
[MSDN] Implement an Asynchronous Service Operation
[MSDN] Synchronous and Asynchronous Operations
[MSDN] Asynchronous Programming Patterns

PluralSight WCF Library

PluralSight has a pretty robust collection of WCF related courses.  I decided it would be useful to index the concepts covered in the courses I watched (as part of putting together to 70-487 study guide).

Microsoft 70-487: Implement transactions

Exam Objectives

Manage transactions by using the API from System.Transactions namespace; implement distributed transactions; specify transaction isolation level 

Quick Overview of Training Materials

Exam Ref 70-487 - Chapter 1.3
[MSDN] System.Transactions Namespace
[MSDN] Distributed Transactions
[MSDN] Distributed Transactions Overview
[MSDN] Introducing System.Transactions in the .NET Framework 2.0
[MSDN] Transactions in WCF Services
[MSDN] Transaction Processing
[MSDN] Long Running Transactions
[MSDN] Transaction Isolation Levels

[PluralSight] Understanding .NET and WCF Transactions
[Wikipedia] Transaction Processing
[StackOverflow] Why is TransactionScope default Isolation level Serializable
[Book] Database Management Systems (2nd Ed.) - Ch. 18
[YouTube] Database Management Systems Lecture 24 and Lecture 25

My post: Query data using ADO.NET
My code samples on GitHub

Microsoft 70-487: Implement data storage in Azure

Exam Objectives

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

Quick Overview of Training Materials

Exam Ref 70-487 - Chapter 1.4
[PluralSight] Windows Azure Storage In-Depth
[MSDN] Introduction to Microsoft Azure Storage (complete docs)
[MSDN] Storage Queues vs Service Bus Queues
[MSDN] Azure SQL Database Documentation
[MSDN] Azure Redis Cache FAQ
[MSDN] Azure Redis Videos
[MSDN] Azure Storage Client Library Retry Policy Recommendations
[MSDN] Transient fault handling
[MSDN] Retry Guidance for Specific Services
[MSDN] Overview of Azure CDN
[MSDN] What is the Azure SQL Database service?
[MSDN] Microsoft Azure Table Storage - Not Your Father's Database
[MSDN] Azure Storage Table Design Guide
[MSDN] Using Azure PowerShell with Azure Storage
[Channel9] Windows Azure Tables and Queues Deep Dive

Microsoft 70-487: Implement caching

Exam Objectives

Cache static data, apply cache policy (including expirations); use CacheDependency to refresh cache data; query notifications

Quick Overview of Training Materials

Exam Ref 70-487 - Chapter 1.2
[MSDN] System.Runtime.Caching
[MSDN] Detecting Changes with SqlDependency
[CodeProject] .NET 4.0 MemoryCache with SqlChangeMonitor
[CodeProject] Query Notification using SqlDependency and SqlCacheDependency

My GitHub Sample Code
70-486: Design a caching strategy

Microsoft 70-487: Manipulate XML data structures

Exam Objectives

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

Quick Overview of Training Materials

Exam Ref 70-487 - Chapter 1.6

[MSDN] XML Documents and Data
[MSDN] XML
[MSDN] Understanding XML
[MSDN] XPath Reference
[MSDN] What is XSLT?
[MSDN] XSLT Reference
[Hanselminutes] XML Tools and Technologies
[Hanselminutes] LINQ to XML
A Really, Really, Really Good Introduction to XML
[PluralSight] XML Fundamentals
[PluralSight] XML Processing in .NET Applications
[W3C] XML 1.1 Recommendation (Spec)
[W3C] Namespaces in XML 1.0 3rd Ed. (Spec)
[W3C] XSLT Recommendation (Spec)
[StackOverflow] JSON and XML comparison
[YouTube] XML and XSLT Transformation Explained
[YouTube] Using XSLT to Transform Your XML

My code samples on GitHub

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.

Microsoft 70-487: Query and manipulate data by using Data Provider for Entity Framework

Exam Objectives

Query and manipulate data by using Connection, DataReader, and Command from the System.Data.EntityClient namespace; perform synchronous and asynchronous operations; manage transactions (API); programmatically configure a Data Provider

Quick Overview of Training Materials

Exam Ref 70-487 - Chapter 2.2
[MSDN] EntityClient Provider for the Entity Framework
[MSDN] Entity Framework Code-Based Configuration (EF6 Onwards)

My post: Query and manipulate data by using ADO.NET

MIT 6.005 - Software Construction (edX)

The resources for MIT's "Software Construction" class are distributed between several disparate sources.  There is an entry for 6.005 on the MIT Open Courseware page, where it is called "Elements of Software Construction", and there are two classes on edX: 6.005.1x "Software Construction in Java" and 6.005.2x "Advanced Software Construction in Java".

I'm hoping that working through this class will sharpen my understanding of general software engineering concepts.  The emphasis of the class is writing bug free code that is easy to understand and easy to change, which is certainly something you can never be too good at, am I right?

Microsoft 70-487: Create an Entity Framework data model

Exam Objectives

Structure the data model using table per type, table per class, table per hierarchy; choose and implement an approach to manage a data model (code first vs. model first vs. database first); implement POCO objects; describe a data model by using conceptual schema definitions, storage schema definition, mapping language (CSDL, SSDL, MSL), and Custom Code First Conventions

Quick Overview of Training Materials

Exam Ref 70-487 - Chapter 2.5
Programming Entity Framework: Code First - Chapter 5
Programming Entity Framework - Chapter 14
[MSDN] Walkthrough: Mapping Inheritance - Table-per-Hierarchy

[MSDN] Walkthrough: Mapping Inheritance - Table-per-Type

[MSDN] Configuring/Mapping Properties and Types with the Fluent API
[MSDN] Specification for CSDL, SSDL, MSL

Inheritance Modelling Patterns with EF6 Code First

Inheritance with EF Code First: Part 1, Part 2, Part 3
[MSDN] Entity Framework Custom Code First Conventions (EF6 onwards)

[MSDN] Entity Framework Model-Based Conventions (EF6 onwards)

PluralSight Courses:
Getting Started With EF6, EF in the Enterprise

Instantiating an object in Java without calling a constructor

The Scenario

This isn't a cliche...

I was working on a Java project that talks to a web service with a custom "Client" class that was written internally.  In my project, the client is pulled in from a hosted maven repo as a dependency, so I didn't have access to the source (at least not from this project).  I'm trying to be better about writing characterization tests for existing code before I go in and change anything (if nothing else it's a good way to feel out the code). But I had a problem...

The Client has a single constructor, which takes an endpoint, a username, and a password. Calling this constructor tries to connect to the endpoint (and crashes if it fails).  Because this was the only defined constructor, subclassing wasn't going to help me.  It doesn't implement an interface, so that avenue was also closed down.

So there was no obvious way for me to create a test double to pass in to the code I was actually interested in testing.  How in the hell was I going to get around this???

Proxy Windows Authentication with a WCF Relay Service

Motivation

The problem I'm going to address here is pretty specific, and the solution I came up with isn't terribly intuitive, but it works.  I ran into a situation where we were trying to integrate web services with a vendor product.  This is a .NET app running on IIS, and we wanted to authenticate using Active Directory by passing in a username and password to a "UserLogin" soap action (this action returns a security token that is used to make other calls).  While initially we thought this worked, it turned out that it wasn't behaving the way we thought it should.  Any request was getting a security token, even if the username and password were garbage.

Yeah... not what we were going for...

MIT 6.046 - Design and Analysis of Algorithms

6.046 is described by Eric Demaine as the final undergraduate algorithms class, with more advanced and more specialized algorithms classes being at the graduate level.  I've had my eye on the advanced data structures and advanced algorithms classes for a while, and this class is a fundamental prerequisite for those.  Now, being that it's my MO to totally overdo it, naturally I had to find overlapping classes from some of my other favorite providers and watch everything.  Had I limited this to one overlapping class it probably wouldn't have been that bad... but I found three other classes: Berkeley CS170, Georgia Tech CS6505, and Stanford CS261.  All four classes are what I would call "intermediate" level algorithms courses, with significant overlap in concepts covered:

I probably would have been done a month ago if I hadn't gone so crazy with watching everyone's lectures...