DAT433UndertheHoodofVisualStudioTeamEditionfor.pptVIP

DAT433 Under the Hood ofVisual Studio Team Editionfor Database Professionals Gert E.R. Drapers Architect/Development Manager Microsoft Corporation Agenda The Project System Understanding the Schema The Schema Object Container Build and Deploy Data Generation Generator Extensibility Distributor Extensibility Generating from the Command Line Database Unit Testing Using the Code Underneath Data Driven Testing Project ModelThe center of gravity Offline Model Project model Schema Objects representation Collection of T-SQL DDL fragments Objects are Parsed and Interpreted at: Project Load Time Object Change (save) Source Control Sync (external change) Shredding in to SQL Fragments Loading, importing or reverse engineering shreds the schema definition into the smallest possible DDL fragments, for example: Table CREATE TABLE [dbo].[Territories]( [TerritoryID] [nvarchar] (20) NOT NULL, [TerritoryDescription] [nchar] (50) NOT NULL, [RegionID] [int] NOT NULL) ON [PRIMARY] Primary Key ALTER TABLE [dbo].[Territories] ADD CONSTRAINT [PK_Territories] PRIMARY KEY NONCLUSTERED ([TerritoryID]) ON [PRIMARY] FK ALTER TABLE [dbo].[Territories] ADDCONSTRAINT [FK_Territories_Region] FOREIGN KEY ([RegionID]) REFERENCES [dbo].[Region] ([RegionID]) Understanding Your Schema Build-up understanding of the DDL Fragments in Stages Phase-1 Parsing Retrieve the object identifier and object type Phase-1 Interpretation Retrieve additional type specifics like schemabinding Phase-1 SQL Server Compile Validation Perform compile time validation against (local) SQL Server, design database with is associated with the project Phase-2 Parsing Build a full AST (Abstract Syntax Tree, aka the parse tree) for the DDL fragment Phase-2 Interpretation Retrieve the remaining type specific detail from the AST All stages contribute to building and maintaining the schema context Object symbol list Object dependency graph (tracking) Understanding Schema Objects File Naming Extension Scheme Everything is a .