So one of
the things I needed to do was write an ASP.Net MVC based application for our senior execs to manage a set of arbitrary attributes against stories, bugs etc to be able to attribute whether
the item was related to Research and Development, and if so, what kind. We are using TFS Azure and don’t have
the option of custom templates. I have decided on using a string based field within
the template that is not very visible and which we don’t use to write a small set of custom which will determine
the research and development association. However, this string munging on
the field is not very user friendly so we need a simple tool that can display attributes against items
in a simple dropdown list or something similar. Enter a custom web app that accesses our TFS items
in Azure (Note: We are also using Visual Studio 2012) Now TFS Azure uses your Live ID and it is not really possible to easily do this
in a server based app where no interaction is available. Even if you capture
the Live ID credentials yourself and try to submit them to TFS Azure, it wont work. Bottom line is that it is not straightforward nor obvious what you have to do.
In fact, it is a real pain to find and there are some answers out there which don’t appear to be answers at all given they didn’t work
in my scenario. So for anyone else who wants to do this, here is a simple breakdown on what you have to do: Go here and get
the “TFS Service Credential Viewer”. Install it, run it and connect to your TFS instance
in azure and create a service account. Note
the username and password exactly as it presents it to you. This is
the magic identity that will allow unattended, programmatic access. Without this step, don’t bother trying to do anything else.
In your MVC app, reference
the following assemblies from “C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\ReferenceAssemblies\v2.0”: Microsoft.TeamFoundation.Client.dll Microsoft.TeamFoundation.Common.dll Microsoft.TeamFoundation.VersionControl.Client.dll Microsoft.TeamFoundation.VersionControl.Common.dll Microsoft.TeamFoundation.WorkItemTracking.Client.DataStoreLoader.dll Microsoft.TeamFoundation.WorkItemTracking.Client.dll Microsoft.TeamFoundation.WorkItemTracking.Common.dll If hosting this
in Internet Information Server, for
the application pool this app runs under, you will need to enable 32 Bit support. You also have to allow
the TFS client assemblies to store a cache of files on your system. If you don’t do this, you will authenticate fine, but then get an exception saying that it is unable to access
the cache at some directory path when you query work items. You can set this up by adding
the following to your web.config,
in the <appSettings> element as shown below: <appSettings> <!-- Add reference to TFS Client Cache -->
<add key="WorkItemTrackingCacheRoot" value="C:\windows\temp" />
</appSettings>
With all that
in place, you can write
the following code:
var token = new Microsoft.TeamFoundation.Client.SimpleWebTokenCredential("{you-service-account-name", "{your-service-acct-password}");
var clientCreds = new Microsoft.TeamFoundation.Client.TfsClientCredentials(token);
var currentCollection = new TfsTeamProjectCollection(new Uri(“https://{yourdomain}.visualstudio.com/defaultcollection”), clientCreds);
TfsConfigurationServercurrentCollection.EnsureAuthenticated();
In the above code, not
the URL contains
the “defaultcollection” at
the end of
the URL. Obviously replace {yourdomain} with whatever is defined for your TFS
in Azure instance.
In addition, make sure
the service user account and password that was generated
in the first step is substituted
in here.
Note: If something is not right,
the “EnsureAuthenticated()” call will throw an exception with
the message being you are not authorised. If you forget
the “defaultcollection” on
the URL, it will still fail but with a message saying you are not authorised. That is, a similar but different exception message.
And that is it. You can then query
the collection using something like:
var service = currentCollection.GetService<WorkItemStore>();
var proj = service.Projects[0];
var allQueries = proj.StoredQueries;
for (int qcnt = 0; qcnt < allQueries.Count; qcnt++)
{
var query = allQueries[qcnt];
var queryDesc = string.format(“Query found named: {0}”,query.Name);
}
You get
the idea.
If you search around, you will find references to
the ServiceIdentityCredentialProvider which is referenced
in this article. I had no luck with this method and it all looked too hard since it required an extra KB article and other magic
sauce.
So I hope that helps. This article certainly would have helped me save a boat load of time and frustration.
