Category

Inheritance hierarchy

Hierarchy type None
Is abstract False

Relationships

The Category entity is part of the following relationships

Related Entity Full description
Product Product.Category - Category.Products (m:1)
Supplier Category.Suppliers - Supplier.Category (m:n) (via Product)

Fields

The following fields are defined in the Category entity

Name Type Is PK Is FK Optional Read-only Max. length Precision Scale
CategoryName string (System.String) Yes 15 0 0
Description string (System.String) Yes 1073741823 0 0
Id int (System.Int32) Yes Yes 0 0 0
Picture byte[] (System.Byte[]) Yes 2147483647 0 0

Unique Constraints

None.

None.

Mappings

Northwind.dbo.Categories (SQL Server (SqlClient))

Aspect Value
Type of target Table
Actions allowed Create / Retrieve / Update / Delete
Entity Field Target field Nullable Type Length Precision Scale Sequence Type converter
CategoryName CategoryName Yes nvarchar 15 0 0
Description Description Yes ntext 1073741823 0 0
Id CategoryID int 0 10 0 SCOPE_IDENTITY()
Picture Picture Yes image 2147483647 0 0

Code generation information

Setting values

Category (Entity)

Setting name Value
Entity base class name CommonEntityBase

CategoryName (NormalField)

Setting name Value
Generate as nullable type True
Field property is public True

Description (NormalField)

Setting name Value
Generate as nullable type True
Field property is public True

Id (NormalField)

Setting name Value
Generate as nullable type True
Field property is public True

Picture (NormalField)

Setting name Value
Generate as nullable type True
Field property is public True

Products (NavigatorCollection)

Setting name Value
Navigator property is public True

Suppliers (NavigatorCollection)

Setting name Value
Navigator property is public True

Attribute definitions per element

CategoryName (NormalField)

  • StringLength

Description (NormalField)

  • StringLength

Additional interface definitions per element

None.

Additional namespace definitions per element

None.