Need a C# app that will do the following:
1. Connect to our TFS server using the TFS SDK
2. Run existing query in an existing Team Project
3. Export query to .csv
4. Open saved .csv in Excel
The reason we need to do this, is the query spans multiple projects and the current export to Excel functionality that exists in .NET for TFS today doesn't allow this. It only allows you to import work items from a single project.
This will need to access a TFS 2010 server.
For development and testing of this project, you will need to use your own TFS 2010 server. Our TFS server is located within our firewall and for security reasons cannot be accessed from outside.