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.Sales
{
public class vSalesPerson : SqlView
{
static int InstanceCount = 0;
SqlColumn<int?> _BusinessEntityID;
SqlColumn<string> _Title;
SqlColumn<string> _FirstName;
SqlColumn<string> _MiddleName;
SqlColumn<string> _LastName;
SqlColumn<string> _Suffix;
SqlColumn<string> _JobTitle;
SqlColumn<string> _PhoneNumber;
SqlColumn<string> _PhoneNumberType;
SqlColumn<string> _EmailAddress;
SqlColumn<int?> _EmailPromotion;
SqlColumn<string> _AddressLine1;
SqlColumn<string> _AddressLine2;
SqlColumn<string> _City;
SqlColumn<string> _StateProvinceName;
SqlColumn<string> _PostalCode;
SqlColumn<string> _CountryRegionName;
SqlColumn<string> _TerritoryName;
SqlColumn<string> _TerritoryGroup;
SqlColumn<decimal?> _SalesQuota;
SqlColumn<decimal?> _SalesYTD;
SqlColumn<decimal?> _SalesLastYear;
public SqlColumn<int?> BusinessEntityID
{
get
{
return this._BusinessEntityID;
}
}
public SqlColumn<string> Title
{
get
{
return this._Title;
}
}
public SqlColumn<string> FirstName
{
get
{
return this._FirstName;
}
}
public SqlColumn<string> MiddleName
{
get
{
return this._MiddleName;
}
}
public SqlColumn<string> LastName
{
get
{
return this._LastName;
}
}
public SqlColumn<string> Suffix
{
get
{
return this._Suffix;
}
}
public SqlColumn<string> JobTitle
{
get
{
return this._JobTitle;
}
}
public SqlColumn<string> PhoneNumber
{
get
{
return this._PhoneNumber;
}
}
public SqlColumn<string> PhoneNumberType
{
get
{
return this._PhoneNumberType;
}
}
public SqlColumn<string> EmailAddress
{
get
{
return this._EmailAddress;
}
}
public SqlColumn<int?> EmailPromotion
{
get
{
return this._EmailPromotion;
}
}
public SqlColumn<string> AddressLine1
{
get
{
return this._AddressLine1;
}
}
public SqlColumn<string> AddressLine2
{
get
{
return this._AddressLine2;
}
}
public SqlColumn<string> City
{
get
{
return this._City;
}
}
public SqlColumn<string> StateProvinceName
{
get
{
return this._StateProvinceName;
}
}
public SqlColumn<string> PostalCode
{
get
{
return this._PostalCode;
}
}
public SqlColumn<string> CountryRegionName
{
get
{
return this._CountryRegionName;
}
}
public SqlColumn<string> TerritoryName
{
get
{
return this._TerritoryName;
}
}
public SqlColumn<string> TerritoryGroup
{
get
{
return this._TerritoryGroup;
}
}
public SqlColumn<decimal?> SalesQuota
{
get
{
return this._SalesQuota;
}
}
public SqlColumn<decimal?> SalesYTD
{
get
{
return this._SalesYTD;
}
}
public SqlColumn<decimal?> SalesLastYear
{
get
{
return this._SalesLastYear;
}
}
public override string ConnectionString
{
get
{
return FATIHVAIOServer.ConnectionString;
}
}
public vSalesPerson() : base("vSalesPerson", "vSalesPerson", "9", "Sales")
{
vSalesPerson.InstanceCount++;
this.instanceName = this.schema_name + "_" + this.name + "_" + vSalesPerson.InstanceCount.ToString();
_BusinessEntityID = new SqlColumn<int?>(this, null, "BusinessEntityID", 4, 10, "", false, false, false, false);
_Title = new SqlColumn<string>(this, null, "Title", 16, 0, "Latin1_General_100_CS_AS", false, true, false, false);
_FirstName = new SqlColumn<string>(this, null, "FirstName", 100, 0, "Latin1_General_100_CS_AS", false, false, false, false);
_MiddleName = new SqlColumn<string>(this, null, "MiddleName", 100, 0, "Latin1_General_100_CS_AS", false, true, false, false);
_LastName = new SqlColumn<string>(this, null, "LastName", 100, 0, "Latin1_General_100_CS_AS", false, false, false, false);
_Suffix = new SqlColumn<string>(this, null, "Suffix", 20, 0, "Latin1_General_100_CS_AS", false, true, false, false);
_JobTitle = new SqlColumn<string>(this, null, "JobTitle", 100, 0, "Latin1_General_100_CS_AS", false, false, false, false);
_PhoneNumber = new SqlColumn<string>(this, null, "PhoneNumber", 50, 0, "Latin1_General_100_CS_AS", false, true, false, false);
_PhoneNumberType = new SqlColumn<string>(this, null, "PhoneNumberType", 100, 0, "Latin1_General_100_CS_AS", false, true, false, false);
_EmailAddress = new SqlColumn<string>(this, null, "EmailAddress", 100, 0, "Latin1_General_100_CS_AS", false, true, false, false);
_EmailPromotion = new SqlColumn<int?>(this, null, "EmailPromotion", 4, 10, "", false, false, false, false);
_AddressLine1 = new SqlColumn<string>(this, null, "AddressLine1", 120, 0, "Latin1_General_100_CS_AS", false, false, false, false);
_AddressLine2 = new SqlColumn<string>(this, null, "AddressLine2", 120, 0, "Latin1_General_100_CS_AS", false, true, false, false);
_City = new SqlColumn<string>(this, null, "City", 60, 0, "Latin1_General_100_CS_AS", false, false, false, false);
_StateProvinceName = new SqlColumn<string>(this, null, "StateProvinceName", 100, 0, "Latin1_General_100_CS_AS", false, false, false, false);
_PostalCode = new SqlColumn<string>(this, null, "PostalCode", 30, 0, "Latin1_General_100_CS_AS", false, false, false, false);
_CountryRegionName = new SqlColumn<string>(this, null, "CountryRegionName", 100, 0, "Latin1_General_100_CS_AS", false, false, false, false);
_TerritoryName = new SqlColumn<string>(this, null, "TerritoryName", 100, 0, "Latin1_General_100_CS_AS", false, true, false, false);
_TerritoryGroup = new SqlColumn<string>(this, null, "TerritoryGroup", 100, 0, "Latin1_General_100_CS_AS", false, true, false, false);
_SalesQuota = new SqlColumn<decimal?>(this, null, "SalesQuota", 8, 19, "", false, true, false, false);
_SalesYTD = new SqlColumn<decimal?>(this, null, "SalesYTD", 8, 19, "", false, false, false, false);
_SalesLastYear = new SqlColumn<decimal?>(this, null, "SalesLastYear", 8, 19, "", false, false, false, false);
}
~vSalesPerson()
{
vSalesPerson.InstanceCount--;
}
}
}