Loading Domain Models with Data

[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.]

There are several stages in creating model-driven applications. In SQL Server Modeling CTP, you typically start by modeling one or more problem domains in Microsoft code name “M”. The tools in the SQL Server Modeling CTP load these models into SQL Server Modeling Services, a SQL Server 2008 database designed to store and manage these models. The next step is to write various types of applications that operate with the models in the database. These applications include loaders that import data into the new models, management tools that help manage model data, and model-driven applications that read the models to direct their operation. The topics in this section provide examples of various data access strategies for creating, reading, updating, and deleting model data in the Modeling Services.

There are special Modeling Services patterns that must be understood when writing applications that interact with models. These patterns support security features, performance, and other services. For example, one common pattern is the Modeling Services Folder pattern. A Folder is a logical container for Modeling Services rows, also referred to as items. For more information about Folders, see Using Folders and Ids. The topics in this section use the Folder pattern, but there are many other patterns. For more information, see , SQL Server Modeling Services Patterns. It helps to understand these Modeling Services patterns when writing data access code.

In This Section

The code examples in this section use a common model, HumanResources. If you want to run the code in the technology-specific topics, you must first install this sample model into the Modeling Services database. For more information about how to install the HumanResources model, see How to: Install the HumanResources Sample Model using Visual Studio. Note that these examples require the SQL Server Modeling CTP technologies, Modeling Services, and Visual Studio 2010.

The following topics provide examples of different data access strategies for interacting with models in the Modeling Services:

• How to: Create data using "M"

• How to: Create, Read, Update, and Delete Data using Transact-SQL

• How to: Create, Read, Update, and Delete Data using ADO.NET

• How to: Create, Read, Update, and Delete Data using LINQ

See Also

Concepts

SQL Server Modeling Services Patterns

Other Resources

"Oslo" Repository Overview