Tables Element (OrderObjectMappings.Xml File)

The Tables element in the OrderObjectMappings.xml file identifies the database tables and columns that PurchaseOrder instances are mapped to.

The Tables element is a child of the StorageMap element, and is required. It is a container for Table elements.

Table Element

The Table element identifies a table in the transactions resource database. The Table element contains the following elements: the Columns element, the Constraints element, and the Ordering element.

The following table lists the attributes of the Table element.

Columns Element

The Columns element is a container for Column elements.

Column Element

The Column element identifies a column in a table.

The following table lists the attributes of the Column element.

Attribute	Data Type	Description
Name	String	The name of a column in the table. This attribute is required.
DataType	String	The SQL Server type of the column. This attribute is required. Note: Do not use the text, vchar, or char SQL Server types. Use the ntext, nvchar, and nchar types instead.
Precision	Integer	The width of the column. This attribute is used only if the value of the DataType attribute is "nvchar" or "decimal". This attribute is optional. The default value is 0 (zero).
Scale	Integer	The number of digits after the decimal point. This attribute is used only if the value of the DataType attribute is "decimal". This attribute is optional. The default value is 0 (zero).
IsNullable	Boolean	Whether the column may have a null value. Use the value false if the column is defined with the not null constraint in the database. This attribute is optional. The default value is false.
GUID	Boolean	Whether the column has the rowguid SQL Server property set to true. This attribute is optional. The default value is false. Note: Only one column in a table can have a GUID attribute with a value of true.

Constraints Element

The Constraints element describes the constraints on the table. This element is required. The Constraints element contains the following elements: the PrimaryKey element, the ForeignKey element, and the Unique element.

PrimaryKey Element

The PrimaryKey element identifies the primary key of a table. This element is required. The set of PrimaryKey elements in a Table element must reflect the primary key of the table as defined in the database schema.

The PrimaryKey element contains one or more ColumnRef elements.

The following table lists the attributes of the PrimaryKey element.

ColumnRef Element

The ColumnRef element identifies the database column that is involved in a constraint.

The following table lists the attributes of the ColumnRef element.

ForeignKey Element

The ForeignKey element identifies a foreign key constraint on a table. This element is optional. The set of ForeignKey elements in a Table element must reflect the foreign-key constraints of the table as defined in the database schema.

The ForeignKey element contains one or more ColumnMatch elements.

The following table lists the attributes of the ForeignKey element.

ColumnMatch Element

The ColumnMatch element identifies a mapping between a foreign-key column of this table and the column of the foreign-key table from which the key value is copied. The following table lists the attributes of the ColumnMatch element.

Unique Element

The Column element identifies a unique constraint on a table. This element is optional.

The Unique element contains one or more ColumnRef elements.

The following table lists the attributes of the Unique element.

Ordering Element

The Ordering element is a container for OrderBy elements. This element is optional.

OrderBy Element

The OrderBy element specifies how to order the members of a collection when the collection is retrieved.

The following table lists the attributes of the OrderBy element.

Example

<StorageMap>
  <Tables>
    <Table Name="PurchaseOrders">
      <Columns>
        <Column Name="OrderGroupId" DataType="uniqueidentifier" 
          GUID="true" />
        <Column Name="Name" DataType="nvarchar" Precision="64" 
          IsNullable="true" />
        <Column Name="SoldToId" DataType="uniqueidentifier" />
        <Column Name="SoldToAddressId" DataType="nvarchar" 
          Precision="50" IsNullable="true" />
        <Column Name="LineItemCount" DataType="int" />
        <Column Name="ShippingTotal" DataType="money" />
        <Column Name="LastModified" DataType="datetime" />
        <Column Name=" MessageToRecipient " DataType="nvarchar" 
          Precision="64" IsNullable="true" />
        <Column Name="MarshalledData" DataType="image" 
          IsNullable="true" />
      </Columns>
      <Constraints>
        <PrimaryKey Name="PK_PurchaseOrders">
          <ColumnRef Name="OrderGroupId" />
        </PrimaryKey>
      </Constraints>
    </Table>
    <Table Name="LineItems">
      <Columns>
        <Column Name="LineItemId" DataType="uniqueidentifier" 
          GUID="true" />
        <Column Name="OrderFormId" DataType="uniqueidentifier" />
        <Column Name="LineItemOrdering" DataType="timestamp" 
          IsNullable="true" />
        <Column Name="MarshalledData" DataType="image" 
          IsNullable="true" />
      </Columns>
      <Constraints>
        <PrimaryKey Name="PK_LineItems">
          <ColumnRef Name="LineItemId" />
        </PrimaryKey>
        <ForeignKey Name="FK_LineItems_OrderForms" 
          ForeignTable="OrderForms" CascadeDelete="false">
          <ColumnMatch Name="OrderFormId" ForeignName="OrderFormId" />
        </ForeignKey>
      </Constraints>
      <Ordering>
        <OrderBy Column="OrderFormId" Ascending="true" />
        <OrderBy Column="LineItemOrdering" Ascending="true" />
      </Ordering>
    </Table>
  </Tables>
...
</StorageMap>

See Also

Other Resources

Mapping Purchase Orders to the Database

StorageMap Element (OrderObjectMappings.Xml File)