How to: View and Edit Models Using "Quadrant"

  • Article

[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"

  1. On the Start menu, click All Programs, Microsoft SQL Server Modeling CTP, and open Quadrant.

  2. If there are workpads open, on the File menu, click Close All Workpads.

  3. On the File menu, select New, and then click Session.

  4. In the New Database Session dialog, specify the database server that has the SetupApplicationDB database.

  5. In the Database list, select SetupApplicationDB.

  6. Click Create to create a new session.

  7. In the SetupApplicationDB Explorer, expand the Database folder.

  8. Expand the SetupApplication model.

  9. Drag the Products extent to the “Quadrant” workspace. A workpad appears with information about the MyNotepad model instance that you added in previous tasks.

  10. 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.

  11. Expand the MyNotepad folder in the tree. Note that four Directories instances refer to the MyNotepad product.

  12. 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"

  1. In the Products workpad, select the MyNotepad product in the tree of the Tree Master/Detail view.

  2. In the details pane of the workpad, click the Version value 1.0.0.0. A cursor appears, indicating that the value is editable.

  3. Change the Version value to 1.0.0.1.

To add a new Products record in "Quadrant"

  1. At the top-right corner of the Products workpad, click the down-arrow, and then click Table.

  2. On the Data menu, click Insert Item.

  3. Fill in the following values for a new products row. Do not assign a value for the Id field because that gets assigned automatically.

    Name

    MyNotepad2

    ProductId

    d65d2125-560b-4ba9-bdca-3b3bcd3f7b71

    UpgradeCode

    ac5c9dac-b3f0-469a-8f1a-02c2566eee34

    Language

    1033

    Codepage

    1252

    Version

    2.0.0.0

    Manufacturer

    MyNotepad Corp.

  4. On the File menu, click Save Changes. A new row should appear in the Products table.

See Also

Concepts

SQL Server Modeling CTP and Model-Driven Applications

Other Resources

Getting Started with the SQL Server Modeling CTP (SetupApplication Tutorial)