public ProductsTable(IDataProvider provider):base("Products",provider){
ClassName = "Product";
SchemaName = "dbo";
Columns.Add(new DatabaseColumn("ProductID", this)
{
IsPrimaryKey = true,
DataType = DbType.Int32,
IsNullable = false,
AutoIncrement = true,
IsForeignKey = true,
MaxLength = 0
});
Columns.Add(new DatabaseColumn("ProductName", this)
{
IsPrimaryKey = false,
DataType = DbType.String,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 40
});
Columns.Add(new DatabaseColumn("SupplierID", this)
{
IsPrimaryKey = false,
DataType = DbType.Int32,
IsNullable = true,
AutoIncrement = false,
IsForeignKey = true,
MaxLength = 0
});
Columns.Add(new DatabaseColumn("CategoryID", this)
{
IsPrimaryKey = false,
DataType = DbType.Int32,
IsNullable = true,
AutoIncrement = false,
IsForeignKey = true,
MaxLength = 0
});
Columns.Add(new DatabaseColumn("QuantityPerUnit", this)
{
IsPrimaryKey = false,
DataType = DbType.String,
IsNullable = true,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 20
});
Columns.Add(new DatabaseColumn("UnitPrice", this)
{
IsPrimaryKey = false,
DataType = DbType.Currency,
IsNullable = true,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 0
});
Columns.Add(new DatabaseColumn("UnitsInStock", this)
{
IsPrimaryKey = false,
DataType = DbType.Int16,
IsNullable = true,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 0
});
Columns.Add(new DatabaseColumn("UnitsOnOrder", this)
{
IsPrimaryKey = false,
DataType = DbType.Int16,
IsNullable = true,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 0
});
Columns.Add(new DatabaseColumn("ReorderLevel", this)
{
IsPrimaryKey = false,
DataType = DbType.Int16,
IsNullable = true,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 0
});
Columns.Add(new DatabaseColumn("Discontinued", this)
{
IsPrimaryKey = false,
DataType = DbType.Boolean,
IsNullable = false,
AutoIncrement = false,
IsForeignKey = false,
MaxLength = 0
});
}
