How to: View and Edit Models Using "Quadrant"
[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.]
This is the first of two tasks that use Microsoft code name “Quadrant” with the SetupApplication model. For an overview of this tutorial, see Using Quadrant with the SetupApplication Model.
In this task, you explore and edit the SetupApplication model in the SetupApplicationDB database by using “Quadrant”. For more information about how to create this model and load it into the database, see Creating and Using the SetupApplication Model.
To explore the SetupApplication model in "Quadrant"
On the Start menu, click All Programs, Microsoft SQL Server Modeling CTP, and open Quadrant.
If there are workpads open, on the File menu, click Close All Workpads.
On the File menu, select New, and then click Session.
In the New Database Session dialog, specify the database server that has the SetupApplicationDB database.
In the Database list, select SetupApplicationDB.
Click Create to create a new session.
In the SetupApplicationDB Explorer, expand the Database folder.
Expand the SetupApplication model.
Drag the Products extent to the “Quadrant” workspace. A workpad appears with information about the MyNotepad model instance that you added in previous tasks.
On the top-right corner of the Products workpad title bar, click the drop-down arrow, and then select Tree Master/Detail. Note that the view of the data changes to a tree. Also note that by selecting items in the tree, details about the item are displayed in the right pane.
Expand the MyNotepad folder in the tree. Note that four Directories instances refer to the MyNotepad product.
Drag the Directories folder from the tree to the “Quadrant” workspace. Note that a new workpad opens with details about the directories.
To edit a Products record in "Quadrant"
In the Products workpad, select the MyNotepad product in the tree of the Tree Master/Detail view.
In the details pane of the workpad, click the Version value 126.96.36.199. A cursor appears, indicating that the value is editable.
Change the Version value to 188.8.131.52.
To add a new Products record in "Quadrant"
At the top-right corner of the Products workpad, click the down-arrow, and then click Table.
On the Data menu, click Insert Item.
Fill in the following values for a new products row. Do not assign a value for the Id field because that gets assigned automatically.
On the File menu, click Save Changes. A new row should appear in the Products table.