using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using DBOMSqlSharp;
namespace FATIHVAIO.AdventureWorks2008R2.Production
{
public class ProductListPriceHistory : SqlTable
{
static int InstanceCount = 0;
SqlForeignKeyColumn<AdventureWorks2008R2.Production.Product> _ProductID;
SqlColumn<DateTime?> _StartDate;
SqlColumn<DateTime?> _EndDate;
SqlColumn<decimal?> _ListPrice;
SqlColumn<DateTime?> _ModifiedDate;
public SqlForeignKeyColumn<AdventureWorks2008R2.Production.Product> ProductID
{
get
{
return this._ProductID;
}
}
public SqlColumn<DateTime?> StartDate
{
get
{
return this._StartDate;
}
}
public SqlColumn<DateTime?> EndDate
{
get
{
return this._EndDate;
}
}
public SqlColumn<decimal?> ListPrice
{
get
{
return this._ListPrice;
}
}
public SqlColumn<DateTime?> ModifiedDate
{
get
{
return this._ModifiedDate;
}
}
public override string ConnectionString
{
get
{
return FATIHVAIOServer.ConnectionString;
}
}
public ProductListPriceHistory() : base("ProductListPriceHistory", "ProductListPriceHistory", "7", "Production")
{
ProductListPriceHistory.InstanceCount++;
this.instanceName = this.schema_name + "_" + this.name + "_" + ProductListPriceHistory.InstanceCount.ToString();
_ProductID = new SqlForeignKeyColumn<AdventureWorks2008R2.Production.Product>(this, null, "ProductID", 4, 10, "", false);
_StartDate = new SqlColumn<DateTime?>(this, null, "StartDate", 8, 23, "", false, false, false, false);
_EndDate = new SqlColumn<DateTime?>(this, null, "EndDate", 8, 23, "", false, true, false, false);
_ListPrice = new SqlColumn<decimal?>(this, null, "ListPrice", 8, 19, "", false, false, false, false);
_ModifiedDate = new SqlColumn<DateTime?>(this, null, "ModifiedDate", 8, 23, "", false, false, false, false);
}
public ProductListPriceHistory(int? id) : this()
{
}
~ProductListPriceHistory()
{
ProductListPriceHistory.InstanceCount--;
}
}
}