API Reference for Database Features of Visual Studio

By using the information in this section, you can extend the features of Visual Studio Premium in the following ways:

• Create custom data generators to produce test data that meets specific needs.

• Create custom data distributions to control the distribution of your test data.

• Create custom conditions for database unit tests to test for specific pass-or-fail criteria.

• Create custom refactoring types to perform additional refactoring operations on your database project.

• Create custom refactoring contributors so that you and your team can use refactoring on additional targets in your database project.

• Create custom rules to identify additional design, naming, or performance issues in database code.

In This Section

This section contains the following key namespaces:

• Microsoft.Data.Schema.UnitTesting
  Provides classes that you can use to create and execute database unit tests.

• Microsoft.Data.Schema.Refactoring
  Provides classes that you can use to create custom types and targets for refactoring.

• Microsoft.Data.Schema.StaticCodeAnalysis
  Provides classes that you can use to create additional rules for analyzing database code.

• Microsoft.Data.Schema.Build
  Provides classes that you can use to create build and deployment contributors that perform additional operations when database projects are built or deployed.

This section also includes the following namespaces:

• Microsoft.Data.Schema

  Supports the .NET Framework infrastructure and is not intended to be used directly from your code.

• Microsoft.Data.Schema.Tools.Compare

  Provides components that are used to compare both data and schemas.

• Microsoft.Data.Schema.Tools.Compare.Schema

  Supports the .NET Framework infrastructure and is not intended to be used directly from your code.

• Microsoft.Data.Schema.Tools.DataGenerator

  This namespace contains the classes used to generate sample data in tables for displaying the data plan in the user interface for the data generation plans.

• Microsoft.Data.Schema.Tools.Settings.Internal

  This namespace provides classes to manage properties and settings for objects hosted in the Tools Options and Project Properties pages of Visual Studio.

• Microsoft.Data.Schema.Tools.Sql.Compare.Schema

  This namespace contains classes used by the Schema Compare window of Visual Studio to compare and synchronize SQL Server databases.

• Microsoft.Data.Schema.Extensibility

  Provides extensibility classes, base types, and public attributes that you use when you define extensions.

• Microsoft.Data.Schema.SchemaModel

  Provides base and core types for the schema model, which models the objects, relationships, and properties of database objects. This namespace represents an important part of the implementation for database schema providers.

• Microsoft.Data.Schema.SchemaModel.Abstract

  Provides the base interfaces that all database schema providers use. This namespace defines basic ANSI SQL elements, such as tables and views.

• Microsoft.Data.Schema.SchemaModel.Translation

  Provides classes to translate an existing data schema model into a target schema model.

• Microsoft.Data.Schema.ScriptDom

  Provides classes and interfaces that can extend the parser and script generator components to enable database schema providers for databases from other companies.

• Microsoft.Data.Schema.ScriptDom.Sql

  Supports the parser and script generator that is specific to SQL Server.

• Microsoft.Data.Schema.Sql

  Supports the .NET Framework infrastructure and is not intended to be used directly from your code.

• Microsoft.Data.Schema.Sql.Build

  Provides classes that control data generation and deployment for SQL Server.

• Microsoft.Data.Schema.Sql.DataGenerator

  Supports the .NET Framework infrastructure and is not intended to be used directly from your code.

• Microsoft.Data.Schema.Sql.SchemaModel

  Provides types for Sql80, Sql90, and Sql100.

• Microsoft.Data.Schema.Tasks

  Supports the .NET Framework infrastructure and is not intended to be used directly from your code.

• Microsoft.Data.Schema.Tasks.Sql

  Supports the .NET Framework infrastructure and is not intended to be used directly from your code.

• Microsoft.Data.Schema.UnitTesting.Conditions

  Provides classes that you can use to create and manage test conditions. By defining a custom test condition, you can verify the behavior of a database object in ways that the built-in conditions do not support.

• Microsoft.Data.Schema.UnitTesting.Configuration

  Provides classes that you can use to read or write configuration information to the DatabaseUnitTesting section of the app.config file in your database unit test project.

The following types support the .NET Framework infrastructure and are not intended to be used directly from your code.

• Microsoft.VisualStudio.Data.Schema.Package.Internal

• Microsoft.VisualStudio.Data.Schema.Package.Project

• Microsoft.VisualStudio.Data.Schema.Package.Project.Internal

• Microsoft.VisualStudio.Data.Schema.Package.Project.SchemaModelViewer

• Microsoft.VisualStudio.Data.Schema.Package.Project.SchemaModelViewer.DependencyView

• Microsoft.VisualStudio.Data.Schema.Package.Project.SchemaModelViewer.SchemaView

• Microsoft.VisualStudio.Data.Schema.Package.Project.SchemaModelViewer.SchemaView.Internal

• Microsoft.VisualStudio.Data.Schema.Package.Refactoring

• Microsoft.VisualStudio.Data.Schema.Package.SchemaCompare

• Microsoft.VisualStudio.Data.Schema.Package.SchemaCompare.Internal

• Microsoft.VisualStudio.Data.Schema.Package.Sql.Internal

• Microsoft.VisualStudio.Data.Schema.Package.Sql.Project

• Microsoft.VisualStudio.Data.Schema.Package.Sql.Refactoring

• Microsoft.VisualStudio.Data.Schema.Package.Sql.UI

• Microsoft.VisualStudio.Data.Schema.Package.UI

• System.Reflection.Mock

Related Sections

• Extending the Database Features of Visual Studio
  Provides background information about how to create extensions for features of Visual Studio Premium.

• Generate Specialized Test Data with a Custom Data Generator
  Describes how you can create custom data generators to produce specialized test data for your database.

• Define Custom Conditions for Database Unit Tests
  Describes how you can create additional conditions to verify data states that you cannot verify with the conditions that are built in to Visual Studio Premium and Visual Studio Ultimate.

• Create Custom Database Refactoring Types or Targets
  Describes how you can create additional types of database refactoring or extend refactoring types to operate on additional targets within your database project.

• Create and Register Additional Rules for Analyzing Database Code
  Describes how you can create additional rules to identify design, naming, or performance issues in your database code.