Click here to Skip to main content
Click here to Skip to main content
Technical Blog

Tagged as

TFS API: Using LINQpad to query TFS

, 13 Sep 2011 CPOL
Rate this:
Please Sign up or sign in to vote.
TFS API: Using LINQpad to query TFS

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

image

  • 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.

image

  • 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.

image

image

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

image

  • Click on Additional Namespace import and enter the following namespaces:
    • Microsoft.TeamFoundation.Client
    • Microsoft.TeamFoundation.VersionControl.Client

image

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

image

  • Let's 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. Hot smile

image

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

Share this post:

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Tarun_Arora
Software Developer (Senior) Avanade
United Kingdom United Kingdom
Solution Developer - C# .NET, ALM
 
Tarun Arora is a Microsoft Certified professional developer for Enterprise Applications. He has over 5 years of experience developing 'Energy Trading & Risk Management' solutions using Microsoft Technologies. Tarun has great passion for technology and travel (not necessarily in the same order)!
Follow on   Twitter

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.1411023.1 | Last Updated 13 Sep 2011
Article Copyright 2011 by Tarun_Arora
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid