Datastore

Topic updated 15-5-2007

The Datastore contains metadata about database objects of one database. Database Providers are used to make connections to specific databases. A Datastore has one connection to a single database. This is managed from the Provider Tab.

The Datastore is the only top level item in the Database Repository hierarchy as displayed in the Project Explorer. The Datastore Designer is opened by double clicking the Datastore node in the Project Explorer.

A Datastore can contain three types of Datastore Entities:

Database Tables
Database Views, which are treated as read-only tables.
Custom Views, these provide an application-side equivalent of a database view

 

General tab

When the Datastore Designer is opened from the Project Explorer, its General tab is activated. This tab gives an overview of the content of the Datastore.

The Tables list displays all Datastore Entities
When an entity in the Tables list is selected, all its Columns, Calculated Columns, Keys and Relations are listed.
All items in the lists can be double clicked to open their designers.
All items in the lists can be right-clicked to access their context menus.

 

DataStore_Designer_tabGeneral