TFS API: Using LINQpad to query TFS

Comments (2) | Share

In this blog post I’ll be showing you how to query TFS using LINQpad.

1. Download LINQpad

Those who are familiar with LINQpad know its benefits and ease of use, i would urge others to try it. You can download LINQpad and read more about it from here => http://www.linqpad.net/

2. Download TFS SDK

I have a blog post on where and how to download the TFS SDK from => here

3. Querying TFS using LINQpad

• Open LINQpad

• Select Query Properties by selecting Query from menu bar and clicking on ‘Query Properties’ you could also press F4 to get to the query properties.

• Add reference to TFS SDK dlls, click ‘Browse’ and navigate to ‘C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\ReferenceAssemblies\v2.0’ and select the following references and click open.

• At this point you should be able to see the following in ‘Additional References’

• Click on Additional Namespace import and enter the following namespaces

        - Microsoft.TeamFoundation.Client
        - Microsoft.TeamFoundation.VersionControl.Client

• Change the Language to C# Program, the query window should look like below now

• Lets connect to the TFS server using the TFSTeamProjectConnectionFactory

void Main()
{
    var tfs = TfsTeamProjectCollectionFactory
                .GetTeamProjectCollection(new Uri("https://tfs.codeplex.com/tfs/tfs34"));
    tfs.EnsureAuthenticated();
    tfs.Dump();
}

• See the results window, LINQpad gracefully dumps the results for you, no worrying about parsing or binding the results

Doesn’t that make querying TFS for information so much easier?

Share this post :

CodeProject