SQL Server Modeling Services Patterns

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

SQL Server Modeling Services efficiently stores, manages, and secures model data. This section discusses modeling patterns for models that target a Modeling Services database. You must design your Microsoft code name “M” models in a way that is compatible with the Modeling Services pattern that you require.

Referencing the Base Domain Library

The services and schema of the Modeling Services database are defined in the Base Domain Library (BDL). The Repository.mx file is an “M” image file that contains the BDL domain. In order to create and compile “M” models that use Modeling Services patterns, you must reference the Repository.dll assembly. This provides access to the BDL required BDL types.

The Repository.dll is located in the bin directory of the SQL Server Modeling CTP. You can create a reference to it in a Visual Studio 2010 project, or you use the reference parameter of the “M” command-line compiler.

The topics in this section import various modules from the BDL, such as System, Repository.Item, and System.Globalization. Each of these modules contain types that are required to implement certain Modeling Services patterns.

For more information about the BDL, see Base Domain Library (BDL). For more information about the Modeling Services architecture that supports these patterns, see SQL Server Modeling Services Architecture.

In This Section

Choosing an Identity Pattern (Modeling Services)

Documents the available Modeling Services types that add an identity field to an “M” model. This also covers the sequence object identity pattern in the Modeling Services database.

Adding Folders (Modeling Services)

Discusses the Modeling Services Folder pattern and the available types that add a Folder field to an “M” model.

Creating Security Views (Modeling Services)

Describes how to use computed values to create updatable security views in the Modeling Services database.

Adding Localized Strings and Resources (Modeling Services)

Shows how to use the Modeling Services localization pattern to add localized strings and resources to an “M” model.

Using the PatternApplication Sample

Explains how to use the PatternApplication sample to more easily apply Modeling Services patterns to an “M” model.

See Also

Concepts

Applying Common Modeling Patterns

Other Resources

Base Domain Library (BDL)
SQL Server Modeling Services Architecture
SQL Server Modeling Services Design Patterns