Click here to Skip to main content
12,760,177 members (34,728 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as


1 bookmarked
Posted 13 Dec 2011

TFS 2011 API–How to Get Exploratory Testing And Feedback Manager Session Information Programmatically

, 13 Dec 2011 CPOL
Rate this:
Please Sign up or sign in to vote.
  In this blog post I’ll show you how to use the TFS 2011 API to get the Exploratory Testing & Feedback Manager session information programmatically.


In this blog post I’ll show you how to use the TFS 2011 API to get the Exploratory Testing & Feedback Manager session information programmatically.


TFS 2011 includes Exploratory Testing and Feedback Manager, the first empowers the testers to explore the application and second empowers the stake holders to explore the application. This rhymes a bit… that’s because… under the hood both use the same infrastructure to drive and store the session information. If you try to run both at the same time on a machine you will run in to the following warning message.


Note both Feedback manager and Exploratory testing store the results in the table [Tfs_DefaultCollection].[dbo].[tbl_Session] in the TFS operational database.


Note - Any direct interaction (including select statements) against the TFS operational databases is strongly discouraged by the Product Team. All such interactions should be done through the TFS SDK.  

How to get the Exploratory Session and Feedback Manager Session programmatically using TFS API…

Download Working Demo… Or follow the steps below,


1. Add references

<span style="color: blue">using </span>


2. Connect to TFS and select a Team Project

<span style="color: blue">private </span>

3. Get access to Session Helper

<span style="color: green">// Get the Session Helper 

4. Now use the session helper to query for the session Information, for example in the snippet below I am simply getting all sessions,

<span style="color: green">// Get Session by Query
<span style="color: green">// I could write a more specific query

BONUS – Go one step further...

5. Get Session Information by Link Id: In the Links section in a Bug you can see the test results attachment, you can use the ‘FindByLinkId’ method to get the details of that session programmatically.

<span style="color: green">// Get Session details for a bug raised during session testing
            // 1. Get the bug 



Download the working demo.

You might also enjoy reading => How to customize Process Template In TFS 2011.

Hope you enjoyed this post! Remember to subscribe to

Enjoy In love


Share this post :


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


About the Author

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)!

You may also be interested in...


Comments and Discussions

-- There are no messages in this forum --
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.170217.1 | Last Updated 14 Dec 2011
Article Copyright 2011 by Tarun_Arora
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid