Hello Faraz,

I am assuming you are using WorkItem Object Model to get the work items. One easy way to get the work items in each project would be

WorkItemStore

Hi,

This is a worst pratice, you should consider the TFS Databases like "Black Box". Data Schema could be updated in the futures versions and a lot of your code would not work anymore.

You should only ask TFS server using the API.

Updating values in database is tricker than it seems. Here are some questions to think about: If you do update the value, do you expect it to be updated only on latest revision or on all old revisions? If you update it on specific existing revision, during auditing it seems as if the actual user who created the revision added that value when in fact an admit directly changed the db. Sometimes we do cache strings and place ids in table to reduce data size, in which case it is tricky to get the string id. For various reasons like this, changing data directly is discouraged and will void support.

You can update fields of many items easily by exporting into excel and then bulk changing field values, it requires no coding.