Listing 1, Inside the TFS Databases, Part 2

[ID] 			[int] 		NOT NULL,
[ParentID] 		[int] 		NOT NULL,
[Node Name] 		[nvarchar](255) NULL,
[Node Type] 		[nvarchar](128) NULL,
[InDeletedTreeFlag] 	[bit] 		NOT NULL,
[InAdminOnlyTreeFlag] 	[bit] 		NOT NULL,
[Team Project] 		[nvarchar](255) NULL,
[Area Level 1] 		[nvarchar](255) NULL,
[Area Level 2] 		[nvarchar](255) NULL,
[Area Level 3] 		[nvarchar](255) NULL,
[Area Level 4] 		[nvarchar](255) NULL,
[Area Level 5] 		[nvarchar](255) NULL,
[Area Level 6] 		[nvarchar](255) NULL,
[Area Level 7] 		[nvarchar](255) NULL,
[Iteration Level 1] 	[nvarchar](255) NULL,
[Iteration Level 2] 	[nvarchar](255) NULL,
[Iteration Level 3] 	[nvarchar](255) NULL,
[Iteration Level 4] 	[nvarchar](255) NULL,
[Iteration Level 5] 	[nvarchar](255) NULL,
[Iteration Level 6] 	[nvarchar](255) NULL,
[Iteration Level 7] 	[nvarchar](255) NULL,
[Area Path] 		[nvarchar](4000)NOT NULL,
[Iteration Path]  	AS ([Area Path]),
[Changed Date] 		[datetime] 	NOT NULL

About the Author

Jeff Levinson is the Application Lifecycle Management practice lead for Northwest Cadence specializing in process and methodology. He is the co-author of "Pro Visual Studio Team System with Database Professionals" (Apress 2007), the author of "Building Client/Server Applications with VB.NET" (Apress 2003) and has written numerous articles. He is an MCAD, MCSD, MCDBA, MCT and is a Team System MVP. He has a Masters in Software Engineering from Carnegie Mellon University and is a former Solutions Design and Integration Architect for The Boeing Company. You can reach him at [email protected].

comments powered by Disqus


  • Top 3 Blazor Extensions for Visual Studio Code

    Some developers prefer to create applications with Microsoft's open-source Blazor tooling from within the open-source, cross-platform Visual Studio Code editor. Here are the top tools in the VS Code Marketplace for those folk, as measured by the number of installations.

  • How to Invert a Machine Learning Matrix Using C#

    VSM Senior Technical Editor Dr. James McCaffrey, of Microsoft Research, explains why inverting a matrix -- one of the more common tasks in data science and machine learning -- is difficult and presents code that you can use as-is, or as a starting point for custom matrix inversion scenarios.

  • Microsoft Engineer: 'It's Time to Move OData to .NET 5'

    Microsoft engineer Sam Xu says "it’s time to move OData to .NET 5" and in a new blog post he shows how to do just that.

  • Microsoft Goes Virtual with Developer Education in Face of COVID-19

    Like many organizations that host developer educational events, Microsoft has gone virtual amid shelter-in-place directives and a surge in remote work stemming from the COVID-19 pandemic.

  • Microsoft Enhances Low-Code Power Apps

    Microsoft's nod to the low-code movement, Power Apps, has been enhanced with a bevy of new features, including mixed reality, canvas/model support in a new mobile app, UX improvements and more.

.NET Insight

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.

Upcoming Events