Databases Reference
In-Depth Information
<EntityType Name=”Products”>
<Key>
<PropertyRef Name=”ProductID” />
</Key>
<Property Name=”ProductID” Type=”int” Nullable=”false”
StoreGeneratedPattern=”Identity” />
<Property Name=”ProductName” Type=”nvarchar” Nullable=”false”
MaxLength=”40” />
<Property Name=”SupplierID” Type=”int” />
<Property Name=”CategoryID” Type=”int” />
<Property Name=”QuantityPerUnit” Type=”nvarchar” MaxLength=”20” />
<Property Name=”UnitPrice” Type=”money” />
<Property Name=”UnitsInStock” Type=”smallint” />
<Property Name=”UnitsOnOrder” Type=”smallint” />
<Property Name=”ReorderLevel” Type=”smallint” />
<Property Name=”Discontinued” Type=”bit” Nullable=”false” />
</EntityType>
The conceptual model describes the entities from the application standpoint. You can also
examine the conceptual model using the Model Browser. It displays the conceptual model
at the top of the tree view (Figure 2.10 shows an example of the conceptual model gener-
ated from the Northwind sample database). However, the Entity Designer, which presents
the conceptual model in a UML-like diagram, might be a better option for working with
the conceptual model, especially when the number of entities is not large.
FIGURE 2.10 Conceptual model.
 
Search WWH ::




Custom Search