Skip Navigation Links.
 

Sample Project

Tables in the example:

 
 


 
   
 
Supplier Table/Record
 
 

Supplier Description

 
   
 

Supplier Fields

 
 
Name Type Length Nullable Auto Increment Codes Table Description
Id int 10  
 
CompanyName string 40      
ContactName string 50
   
ContactTitle string 40
   
City string 40
   
Country string 40
   
Phone string 30
   
Fax string 30
   
 
 

Supplier Keys

 
 
Name Unique Fields
PK_SUPPLIER Id
IndexSupplierCountry   Country
IndexSupplierName   CompanyName
 
 

Supplier Access Methods

 
 
Name Description
Supplier

SQL Command:

SELECT Id,CompanyName,ContactName,ContactTitle,City,Country,Phone,Fax FROM Supplier WHERE (Id=? )

 
   
 
Name Description
SuppliersByCountry

SQL Command:

SELECT Id,CompanyName,ContactName,ContactTitle,City,Country,Phone,Fax FROM Supplier WHERE (Country=? )

 
   
 
Name Description
SuppliersBySupplierName

SQL Command:

SELECT Id,CompanyName,ContactName,ContactTitle,City,Country,Phone,Fax FROM Supplier WHERE (CompanyName=? )

 
   
 
Name Description
AllSuppliers

SQL Command:

SELECT Id,CompanyName,ContactName,ContactTitle,City,Country,Phone,Fax FROM Supplier ORDER BY CompanyName ASC

 
   
  Top  
   
 
Customer Table/Record
 
 

Customer Description

 
   
 

Customer Fields

 
 
Name Type Length Nullable Auto Increment Codes Table Description
Id int 10  
 
FirstName string 40      
LastName string 40      
City string 40
   
Country string 40
   
Phone string 20
   
 
 

Customer Keys

 
 
Name Unique Fields
PK_CUSTOMER Id
IndexCustomerName   LastName, FirstName
 
 

Customer Access Methods

 
 
Name Description
Customer

SQL Command:

SELECT Id,FirstName,LastName,City,Country,Phone FROM Customer WHERE (Id=? )

 
   
 
Name Description
CustomersByFirstNameAndLastName

SQL Command:

SELECT Id,FirstName,LastName,City,Country,Phone FROM Customer WHERE (LastName=? AND FirstName=? )

 
   
 
Name Description
CustomersByLastName

SQL Command:

SELECT Id,FirstName,LastName,City,Country,Phone FROM Customer WHERE (LastName=? ) ORDER BY FirstName ASC

 
   
 
Name Description
AllCustomers

SQL Command:

SELECT Id,FirstName,LastName,City,Country,Phone FROM Customer ORDER BY LastName ASC , FirstName ASC

 
   
  Top  
   
 
Product Table/Record
 
 

Product Description

 
   
 

Product Fields

 
 
Name Type Length Nullable Auto Increment Codes Table Description
Id int 10  
 
ProductName string 50      
SupplierId int 10      
UnitPrice float 12
   
Package string 30
   
IsDiscontinued short 1      
 
 

Product Keys

 
 
Name Unique Fields
PK_PRODUCT Id
IndexProductName   ProductName
IndexProductSupplierId   SupplierId
 
 

Product Access Methods

 
 
Name Description
Product

SQL Command:

SELECT Id,ProductName,SupplierId,UnitPrice,Package,IsDiscontinued FROM Product WHERE (Id=? )

 
   
 
Name Description
ProductsByProductName

SQL Command:

SELECT Id,ProductName,SupplierId,UnitPrice,Package,IsDiscontinued FROM Product WHERE (ProductName=? )

 
   
 
Name Description
ProductsBySupplierId

SQL Command:

SELECT Id,ProductName,SupplierId,UnitPrice,Package,IsDiscontinued FROM Product WHERE (SupplierId=? )

 
   
 
Name Description
AllProductsByIndexProductName

SQL Command:

SELECT Id,ProductName,SupplierId,UnitPrice,Package,IsDiscontinued FROM Product ORDER BY ProductName ASC

 
   
  Top  
   
 
Order Table/Record
 
 

Order Description

 
   
 

Order Fields

 
 
Name Type Length Nullable Auto Increment Codes Table Description
Id int 10      
OrderDate DateTime 23      
OrderNumber string 10
   
CustomerId int 10      
TotalAmount float 12
   
 
 

Order Keys

 
 
Name Unique Fields
PK_ORDER Id
IndexOrderCustomerId   CustomerId
IndexOrderOrderDate   OrderDate
 
 

Order Access Methods

 
 
Name Description
Order

SQL Command:

SELECT Id,OrderDate,OrderNumber,CustomerId,TotalAmount FROM Order WHERE (Id=? )

 
   
 
Name Description
OrdersForCustomerId

SQL Command:

SELECT Id,OrderDate,OrderNumber,CustomerId,TotalAmount FROM Order WHERE (CustomerId=? )

 
   
 
Name Description
AllOrders

SQL Command:

SELECT Id,OrderDate,OrderNumber,CustomerId,TotalAmount FROM Order ORDER BY Id ASC

 
   
  Top  
   
 
OrderItem Table/Record
 
 

OrderItem Description

 
   
 

OrderItem Fields

 
 
Name Type Length Nullable Auto Increment Codes Table Description
Id int 10  
 
OrderId int 10      
ProductId int 10      
UnitPrice float 12      
Quantity int 10      
 
 

OrderItem Keys

 
 
Name Unique Fields
PK_ORDERITEM Id
IndexOrderItemOrderId   OrderId
IndexOrderItemProductId   ProductId
 
 

OrderItem Access Methods

 
 
Name Description
OrderItem

SQL Command:

SELECT Id,OrderId,ProductId,UnitPrice,Quantity FROM OrderItem WHERE (Id=? )

 
   
 
Name Description
OrderItems

SQL Command:

SELECT Id,OrderId,ProductId,UnitPrice,Quantity FROM OrderItem WHERE (OrderId=? )

 
   
 
Name Description
OrderItemsByProductId

SQL Command:

SELECT Id,OrderId,ProductId,UnitPrice,Quantity FROM OrderItem WHERE (ProductId=? )

 
   
 
Name Description
AllOrderItems

SQL Command:

SELECT Id,OrderId,ProductId,UnitPrice,Quantity FROM OrderItem ORDER BY Id ASC

 
   
  Top