//---------------------------------------------------------------------------------------------------
// <auto-generated>
//    This code was generated by BLToolkit template for T4.
//    Changes to this file may cause incorrect behavior and will be lost if the code is regenerated.
// </auto-generated>
//---------------------------------------------------------------------------------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;
using System.ServiceModel;
using System.Text;

using BLToolkit.Data;
using BLToolkit.Data.DataProvider;
using BLToolkit.Data.Linq;
using BLToolkit.Data.Sql;
using BLToolkit.Data.Sql.SqlProvider;
using BLToolkit.DataAccess;
using BLToolkit.Mapping;
using BLToolkit.ServiceModel;

namespace Client
{
	public partial class DataModel : SoapDataContext
	{
		public Table<AlphabeticalListOfProducts> AlphabeticalListOfProducts { get { return this.GetTable<AlphabeticalListOfProducts>(); } }
		/// <summary>
		/// Description for Categories table.
		/// </summary>
		public Table<Categories>                 Categories                 { get { return this.GetTable<Categories>();                 } }
		public Table<CategorySalesFor1997>       CategorySalesFor1997       { get { return this.GetTable<CategorySalesFor1997>();       } }
		public Table<CurrentProductList>         CurrentProductList         { get { return this.GetTable<CurrentProductList>();         } }
		public Table<CustomerAndSuppliersByCity> CustomerAndSuppliersByCity { get { return this.GetTable<CustomerAndSuppliersByCity>(); } }
		public Table<CustomerCustomerDemo>       CustomerCustomerDemo       { get { return this.GetTable<CustomerCustomerDemo>();       } }
		public Table<CustomerDemographics>       CustomerDemographics       { get { return this.GetTable<CustomerDemographics>();       } }
		/// <summary>
		/// Description of Customers table.
		/// </summary>
		public Table<Customers>                  Customers                  { get { return this.GetTable<Customers>();                  } }
		public Table<Employees>                  Employees                  { get { return this.GetTable<Employees>();                  } }
		public Table<EmployeeTerritories>        EmployeeTerritories        { get { return this.GetTable<EmployeeTerritories>();        } }
		public Table<Invoices>                   Invoices                   { get { return this.GetTable<Invoices>();                   } }
		public Table<OrderDetails>               OrderDetails               { get { return this.GetTable<OrderDetails>();               } }
		public Table<OrderDetailsExtended>       OrderDetailsExtended       { get { return this.GetTable<OrderDetailsExtended>();       } }
		public Table<OrderSubtotals>             OrderSubtotals             { get { return this.GetTable<OrderSubtotals>();             } }
		public Table<Orders>                     Orders                     { get { return this.GetTable<Orders>();                     } }
		public Table<OrdersQry>                  OrdersQry                  { get { return this.GetTable<OrdersQry>();                  } }
		public Table<ProductSalesFor1997>        ProductSalesFor1997        { get { return this.GetTable<ProductSalesFor1997>();        } }
		public Table<Products>                   Products                   { get { return this.GetTable<Products>();                   } }
		public Table<ProductsAboveAveragePrice>  ProductsAboveAveragePrice  { get { return this.GetTable<ProductsAboveAveragePrice>();  } }
		public Table<ProductsByCategory>         ProductsByCategory         { get { return this.GetTable<ProductsByCategory>();         } }
		public Table<QuarterlyOrders>            QuarterlyOrders            { get { return this.GetTable<QuarterlyOrders>();            } }
		public Table<Region>                     Region                     { get { return this.GetTable<Region>();                     } }
		public Table<SalesByCategory>            SalesByCategory            { get { return this.GetTable<SalesByCategory>();            } }
		public Table<SalesTotalsByAmount>        SalesTotalsByAmount        { get { return this.GetTable<SalesTotalsByAmount>();        } }
		public Table<Shippers>                   Shippers                   { get { return this.GetTable<Shippers>();                   } }
		public Table<SummaryOfSalesByQuarter>    SummaryOfSalesByQuarter    { get { return this.GetTable<SummaryOfSalesByQuarter>();    } }
		public Table<SummaryOfSalesByYear>       SummaryOfSalesByYear       { get { return this.GetTable<SummaryOfSalesByYear>();       } }
		public Table<Suppliers>                  Suppliers                  { get { return this.GetTable<Suppliers>();                  } }
		public Table<Territories>                Territories                { get { return this.GetTable<Territories>();                } }
		
		#region FreeTextTable
		
		public class FreeTextKey<T>
		{
			public T   Key;
			public int Rank;
		}
		
		class FreeTextTableExpressionAttribute : TableExpressionAttribute
		{
			public FreeTextTableExpressionAttribute()
				: base("")
			{
			}
		
			public override void SetTable(SqlTable table, MemberInfo member, IEnumerable<Expression> expArgs, IEnumerable<ISqlExpression> sqlArgs)
			{
				var aargs  = sqlArgs.ToArray();
				var arr    = ConvertArgs(member, aargs).ToList();
				var method = (MethodInfo)member;
				var sp     = new MsSql2008SqlProvider();
		
				{
					var ttype  = method.GetGenericArguments()[0];
					var tbl    = new SqlTable(ttype);
		
					var database     = tbl.Database     == null ? null : sp.Convert(tbl.Database,     ConvertType.NameToDatabase).  ToString();
					var owner        = tbl.Owner        == null ? null : sp.Convert(tbl.Owner,        ConvertType.NameToOwner).     ToString();
					var physicalName = tbl.PhysicalName == null ? null : sp.Convert(tbl.PhysicalName, ConvertType.NameToQueryTable).ToString();
		
					var name   = sp.BuildTableName(new StringBuilder(), database, owner, physicalName);
		
					arr.Add(new SqlExpression(name.ToString(), Precedence.Primary));
				}
		
				{
					var field = ((ConstantExpression)expArgs.First()).Value;
		
					if (field is string)
					{
						arr[0] = new SqlExpression(field.ToString(), Precedence.Primary);
					}
					else if (field is LambdaExpression)
					{
						var body = ((LambdaExpression)field).Body;
		
						if (body is MemberExpression)
						{
							var name = ((MemberExpression)body).Member.Name;
		
							name = sp.Convert(name, ConvertType.NameToQueryField).ToString();
		
							arr[0] = new SqlExpression(name, Precedence.Primary);
						}
					}
				}
		
				table.SqlTableType   = SqlTableType.Expression;
				table.Name           = "FREETEXTTABLE({6}, {2}, {3}) {1}";
				table.TableArguments = arr.ToArray();
			}
		}
		
		[FreeTextTableExpressionAttribute]
		public Table<FreeTextKey<TKey>> FreeTextTable<TTable,TKey>(string field, string text)
		{
			return this.GetTable<FreeTextKey<TKey>>(
				this,
				((MethodInfo)(MethodBase.GetCurrentMethod())).MakeGenericMethod(typeof(TTable), typeof(TKey)),
				field,
				text);
		}
		
		[FreeTextTableExpressionAttribute]
		public Table<FreeTextKey<TKey>> FreeTextTable<TTable,TKey>(Expression<Func<TTable,string>> fieldSelector, string text)
		{
			return this.GetTable<FreeTextKey<TKey>>(
				this,
				((MethodInfo)(MethodBase.GetCurrentMethod())).MakeGenericMethod(typeof(TTable), typeof(TKey)),
				fieldSelector,
				text);
		}
		
		#endregion
	}

	// View
	[TableName(Name="Alphabetical list of products")]
	public partial class AlphabeticalListOfProducts
	{
		           public int      ProductID       { get; set; } // int(10)
		           public string   ProductName     { get; set; } // nvarchar(40)
		[Nullable] public int?     SupplierID      { get; set; } // int(10)
		[Nullable] public int?     CategoryID      { get; set; } // int(10)
		[Nullable] public string   QuantityPerUnit { get; set; } // nvarchar(20)
		[Nullable] public decimal? UnitPrice       { get; set; } // money(19,4)
		[Nullable] public short?   UnitsInStock    { get; set; } // smallint(5)
		[Nullable] public short?   UnitsOnOrder    { get; set; } // smallint(5)
		[Nullable] public short?   ReorderLevel    { get; set; } // smallint(5)
		           public bool     Discontinued    { get; set; } // bit
		           public string   CategoryName    { get; set; } // nvarchar(15)
	}

	/// <summary>
	/// Description for Categories table.
	/// </summary>
	[TableName(Name="Categories")]
	public partial class Categories
	{
		/// <summary>
		/// Description of Categories.CategoryID field.
		/// </summary>
		[Identity, PrimaryKey(1)] public int    CategoryID   { get; set; } // int(10)
		                          public string CategoryName { get; set; } // nvarchar(15)
		[Nullable               ] public string Description  { get; set; } // ntext(1073741823)
		[Nullable               ] public byte[] Picture      { get; set; } // image(2147483647)

		// FK_Products_Categories_BackReference
		[Association(ThisKey="CategoryID", OtherKey="CategoryID", CanBeNull=true)]
		public IEnumerable<Products> Productss { get; set; }
	}

	// View
	[TableName(Name="Category Sales for 1997")]
	public partial class CategorySalesFor1997
	{
		           public string   CategoryName  { get; set; } // nvarchar(15)
		[Nullable] public decimal? CategorySales { get; set; } // money(19,4)
	}

	// View
	[TableName(Name="Current Product List")]
	public partial class CurrentProductList
	{
		[Identity] public int    ProductID   { get; set; } // int(10)
		           public string ProductName { get; set; } // nvarchar(40)
	}

	// View
	[TableName(Name="Customer and Suppliers by City")]
	public partial class CustomerAndSuppliersByCity
	{
		[Nullable] public string City         { get; set; } // nvarchar(15)
		           public string CompanyName  { get; set; } // nvarchar(40)
		[Nullable] public string ContactName  { get; set; } // nvarchar(30)
		           public string Relationship { get; set; } // varchar(9)
	}

	[TableName(Name="CustomerCustomerDemo")]
	public partial class CustomerCustomerDemo
	{
		[PrimaryKey(1)] public string CustomerID     { get; set; } // nchar(5)
		[PrimaryKey(2)] public string CustomerTypeID { get; set; } // nchar(10)

		// FK_CustomerCustomerDemo
		[Association(ThisKey="CustomerTypeID", OtherKey="CustomerTypeID", CanBeNull=false)]
		public CustomerDemographics FK_CustomerCustomerDemo { get; set; }

		// FK_CustomerCustomerDemo_Customers
		[Association(ThisKey="CustomerID", OtherKey="CustomerID", CanBeNull=false)]
		public Customers Customers { get; set; }
	}

	[TableName(Name="CustomerDemographics")]
	public partial class CustomerDemographics
	{
		[          PrimaryKey(1)] public string CustomerTypeID { get; set; } // nchar(10)
		[Nullable               ] public string CustomerDesc   { get; set; } // ntext(1073741823)

		// FK_CustomerCustomerDemo_BackReference
		[Association(ThisKey="CustomerTypeID", OtherKey="CustomerTypeID", CanBeNull=true)]
		public IEnumerable<CustomerCustomerDemo> CustomerCustomerDemos { get; set; }
	}

	/// <summary>
	/// Description of Customers table.
	/// </summary>
	[TableName(Name="Customers")]
	public partial class Customers
	{
		/// <summary>
		/// Just ID.
		/// </summary>
		[          PrimaryKey(1)] public string CustomerID   { get; set; } // nchar(5)
		/// <summary>
		/// Name of the Company.
		/// </summary>
		                          public string CompanyName  { get; set; } // nvarchar(40)
		[Nullable               ] public string ContactName  { get; set; } // nvarchar(30)
		[Nullable               ] public string ContactTitle { get; set; } // nvarchar(30)
		[Nullable               ] public string Address      { get; set; } // nvarchar(60)
		[Nullable               ] public string City         { get; set; } // nvarchar(15)
		[Nullable               ] public string Region       { get; set; } // nvarchar(15)
		[Nullable               ] public string PostalCode   { get; set; } // nvarchar(10)
		[Nullable               ] public string Country      { get; set; } // nvarchar(15)
		[Nullable               ] public string Phone        { get; set; } // nvarchar(24)
		[Nullable               ] public string Fax          { get; set; } // nvarchar(24)

		// FK_Orders_Customers_BackReference
		[Association(ThisKey="CustomerID", OtherKey="CustomerID", CanBeNull=true)]
		public IEnumerable<Orders> Orderss { get; set; }

		// FK_CustomerCustomerDemo_Customers_BackReference
		[Association(ThisKey="CustomerID", OtherKey="CustomerID", CanBeNull=true)]
		public IEnumerable<CustomerCustomerDemo> CustomerCustomerDemos { get; set; }
	}

	[TableName(Name="Employees")]
	public partial class Employees
	{
		[Identity, PrimaryKey(1)] public int       EmployeeID      { get; set; } // int(10)
		                          public string    LastName        { get; set; } // nvarchar(20)
		                          public string    FirstName       { get; set; } // nvarchar(10)
		[Nullable               ] public string    Title           { get; set; } // nvarchar(30)
		[Nullable               ] public string    TitleOfCourtesy { get; set; } // nvarchar(25)
		[Nullable               ] public DateTime? BirthDate       { get; set; } // datetime(3)
		[Nullable               ] public DateTime? HireDate        { get; set; } // datetime(3)
		[Nullable               ] public string    Address         { get; set; } // nvarchar(60)
		[Nullable               ] public string    City            { get; set; } // nvarchar(15)
		[Nullable               ] public string    Region          { get; set; } // nvarchar(15)
		[Nullable               ] public string    PostalCode      { get; set; } // nvarchar(10)
		[Nullable               ] public string    Country         { get; set; } // nvarchar(15)
		[Nullable               ] public string    HomePhone       { get; set; } // nvarchar(24)
		[Nullable               ] public string    Extension       { get; set; } // nvarchar(4)
		[Nullable               ] public byte[]    Photo           { get; set; } // image(2147483647)
		[Nullable               ] public string    Notes           { get; set; } // ntext(1073741823)
		[Nullable               ] public int?      ReportsTo       { get; set; } // int(10)
		[Nullable               ] public string    PhotoPath       { get; set; } // nvarchar(255)

		// FK_Employees_Employees
		[Association(ThisKey="ReportsTo", OtherKey="EmployeeID", CanBeNull=true)]
		public Employees FK_Employees_Employees { get; set; }

		// FK_Orders_Employees_BackReference
		[Association(ThisKey="EmployeeID", OtherKey="EmployeeID", CanBeNull=true)]
		public IEnumerable<Orders> Orderss { get; set; }

		// FK_EmployeeTerritories_Employees_BackReference
		[Association(ThisKey="EmployeeID", OtherKey="EmployeeID", CanBeNull=true)]
		public IEnumerable<EmployeeTerritories> EmployeeTerritoriess { get; set; }

		// FK_Employees_Employees_BackReference
		[Association(ThisKey="EmployeeID", OtherKey="ReportsTo", CanBeNull=true)]
		public IEnumerable<Employees> FK_Employees_Employees_BackReference { get; set; }
	}

	[TableName(Name="EmployeeTerritories")]
	public partial class EmployeeTerritories
	{
		[PrimaryKey(1)] public int    EmployeeID  { get; set; } // int(10)
		[PrimaryKey(2)] public string TerritoryID { get; set; } // nvarchar(20)

		// FK_EmployeeTerritories_Employees
		[Association(ThisKey="EmployeeID", OtherKey="EmployeeID", CanBeNull=false)]
		public Employees Employees { get; set; }

		// FK_EmployeeTerritories_Territories
		[Association(ThisKey="TerritoryID", OtherKey="TerritoryID", CanBeNull=false)]
		public Territories Territories { get; set; }
	}

	// View
	[TableName(Name="Invoices")]
	public partial class Invoices
	{
		[Nullable] public string    ShipName       { get; set; } // nvarchar(40)
		[Nullable] public string    ShipAddress    { get; set; } // nvarchar(60)
		[Nullable] public string    ShipCity       { get; set; } // nvarchar(15)
		[Nullable] public string    ShipRegion     { get; set; } // nvarchar(15)
		[Nullable] public string    ShipPostalCode { get; set; } // nvarchar(10)
		[Nullable] public string    ShipCountry    { get; set; } // nvarchar(15)
		[Nullable] public string    CustomerID     { get; set; } // nchar(5)
		           public string    CustomerName   { get; set; } // nvarchar(40)
		[Nullable] public string    Address        { get; set; } // nvarchar(60)
		[Nullable] public string    City           { get; set; } // nvarchar(15)
		[Nullable] public string    Region         { get; set; } // nvarchar(15)
		[Nullable] public string    PostalCode     { get; set; } // nvarchar(10)
		[Nullable] public string    Country        { get; set; } // nvarchar(15)
		           public string    Salesperson    { get; set; } // nvarchar(31)
		           public int       OrderID        { get; set; } // int(10)
		[Nullable] public DateTime? OrderDate      { get; set; } // datetime(3)
		[Nullable] public DateTime? RequiredDate   { get; set; } // datetime(3)
		[Nullable] public DateTime? ShippedDate    { get; set; } // datetime(3)
		           public string    ShipperName    { get; set; } // nvarchar(40)
		           public int       ProductID      { get; set; } // int(10)
		           public string    ProductName    { get; set; } // nvarchar(40)
		           public decimal   UnitPrice      { get; set; } // money(19,4)
		           public short     Quantity       { get; set; } // smallint(5)
		           public float     Discount       { get; set; } // real(24)
		[Nullable] public decimal?  ExtendedPrice  { get; set; } // money(19,4)
		[Nullable] public decimal?  Freight        { get; set; } // money(19,4)
	}

	[TableName(Name="Order Details")]
	public partial class OrderDetails
	{
		[PrimaryKey(1)] public int     OrderID   { get; set; } // int(10)
		[PrimaryKey(2)] public int     ProductID { get; set; } // int(10)
		                public decimal UnitPrice { get; set; } // money(19,4)
		                public short   Quantity  { get; set; } // smallint(5)
		                public float   Discount  { get; set; } // real(24)

		// FK_Order_Details_Orders
		[Association(ThisKey="OrderID", OtherKey="OrderID", CanBeNull=false)]
		public Orders OrderDetailsOrders { get; set; }

		// FK_Order_Details_Products
		[Association(ThisKey="ProductID", OtherKey="ProductID", CanBeNull=false)]
		public Products OrderDetailsProducts { get; set; }
	}

	// View
	[TableName(Name="Order Details Extended")]
	public partial class OrderDetailsExtended
	{
		           public int      OrderID       { get; set; } // int(10)
		           public int      ProductID     { get; set; } // int(10)
		           public string   ProductName   { get; set; } // nvarchar(40)
		           public decimal  UnitPrice     { get; set; } // money(19,4)
		           public short    Quantity      { get; set; } // smallint(5)
		           public float    Discount      { get; set; } // real(24)
		[Nullable] public decimal? ExtendedPrice { get; set; } // money(19,4)
	}

	// View
	[TableName(Name="Order Subtotals")]
	public partial class OrderSubtotals
	{
		           public int      OrderID  { get; set; } // int(10)
		[Nullable] public decimal? Subtotal { get; set; } // money(19,4)
	}

	[TableName(Name="Orders")]
	public partial class Orders
	{
		[Identity, PrimaryKey(1)] public int       OrderID        { get; set; } // int(10)
		[Nullable               ] public string    CustomerID     { get; set; } // nchar(5)
		[Nullable               ] public int?      EmployeeID     { get; set; } // int(10)
		[Nullable               ] public DateTime? OrderDate      { get; set; } // datetime(3)
		[Nullable               ] public DateTime? RequiredDate   { get; set; } // datetime(3)
		[Nullable               ] public DateTime? ShippedDate    { get; set; } // datetime(3)
		[Nullable               ] public int?      ShipVia        { get; set; } // int(10)
		[Nullable               ] public decimal?  Freight        { get; set; } // money(19,4)
		[Nullable               ] public string    ShipName       { get; set; } // nvarchar(40)
		[Nullable               ] public string    ShipAddress    { get; set; } // nvarchar(60)
		[Nullable               ] public string    ShipCity       { get; set; } // nvarchar(15)
		[Nullable               ] public string    ShipRegion     { get; set; } // nvarchar(15)
		[Nullable               ] public string    ShipPostalCode { get; set; } // nvarchar(10)
		[Nullable               ] public string    ShipCountry    { get; set; } // nvarchar(15)

		// FK_Orders_Shippers
		[Association(ThisKey="ShipVia", OtherKey="ShipperID", CanBeNull=true)]
		public Shippers Shippers { get; set; }

		// FK_Orders_Employees
		[Association(ThisKey="EmployeeID", OtherKey="EmployeeID", CanBeNull=true)]
		public Employees Employees { get; set; }

		// FK_Orders_Customers
		[Association(ThisKey="CustomerID", OtherKey="CustomerID", CanBeNull=true)]
		public Customers Customers { get; set; }

		// FK_Order_Details_Orders_BackReference
		[Association(ThisKey="OrderID", OtherKey="OrderID", CanBeNull=true)]
		public IEnumerable<OrderDetails> OrderDetailss { get; set; }
	}

	// View
	[TableName(Name="Orders Qry")]
	public partial class OrdersQry
	{
		           public int       OrderID        { get; set; } // int(10)
		[Nullable] public string    CustomerID     { get; set; } // nchar(5)
		[Nullable] public int?      EmployeeID     { get; set; } // int(10)
		[Nullable] public DateTime? OrderDate      { get; set; } // datetime(3)
		[Nullable] public DateTime? RequiredDate   { get; set; } // datetime(3)
		[Nullable] public DateTime? ShippedDate    { get; set; } // datetime(3)
		[Nullable] public int?      ShipVia        { get; set; } // int(10)
		[Nullable] public decimal?  Freight        { get; set; } // money(19,4)
		[Nullable] public string    ShipName       { get; set; } // nvarchar(40)
		[Nullable] public string    ShipAddress    { get; set; } // nvarchar(60)
		[Nullable] public string    ShipCity       { get; set; } // nvarchar(15)
		[Nullable] public string    ShipRegion     { get; set; } // nvarchar(15)
		[Nullable] public string    ShipPostalCode { get; set; } // nvarchar(10)
		[Nullable] public string    ShipCountry    { get; set; } // nvarchar(15)
		           public string    CompanyName    { get; set; } // nvarchar(40)
		[Nullable] public string    Address        { get; set; } // nvarchar(60)
		[Nullable] public string    City           { get; set; } // nvarchar(15)
		[Nullable] public string    Region         { get; set; } // nvarchar(15)
		[Nullable] public string    PostalCode     { get; set; } // nvarchar(10)
		[Nullable] public string    Country        { get; set; } // nvarchar(15)
	}

	// View
	[TableName(Name="Product Sales for 1997")]
	public partial class ProductSalesFor1997
	{
		           public string   CategoryName { get; set; } // nvarchar(15)
		           public string   ProductName  { get; set; } // nvarchar(40)
		[Nullable] public decimal? ProductSales { get; set; } // money(19,4)
	}

	[TableName(Name="Products")]
	public partial class Products
	{
		[Identity, PrimaryKey(1)] public int      ProductID       { get; set; } // int(10)
		                          public string   ProductName     { get; set; } // nvarchar(40)
		[Nullable               ] public int?     SupplierID      { get; set; } // int(10)
		[Nullable               ] public int?     CategoryID      { get; set; } // int(10)
		[Nullable               ] public string   QuantityPerUnit { get; set; } // nvarchar(20)
		[Nullable               ] public decimal? UnitPrice       { get; set; } // money(19,4)
		[Nullable               ] public short?   UnitsInStock    { get; set; } // smallint(5)
		[Nullable               ] public short?   UnitsOnOrder    { get; set; } // smallint(5)
		[Nullable               ] public short?   ReorderLevel    { get; set; } // smallint(5)
		                          public bool     Discontinued    { get; set; } // bit

		// FK_Products_Suppliers
		[Association(ThisKey="SupplierID", OtherKey="SupplierID", CanBeNull=true)]
		public Suppliers Suppliers { get; set; }

		// FK_Products_Categories
		[Association(ThisKey="CategoryID", OtherKey="CategoryID", CanBeNull=true)]
		public Categories Categories { get; set; }

		// FK_Order_Details_Products_BackReference
		[Association(ThisKey="ProductID", OtherKey="ProductID", CanBeNull=true)]
		public IEnumerable<OrderDetails> OrderDetailss { get; set; }
	}

	// View
	[TableName(Name="Products Above Average Price")]
	public partial class ProductsAboveAveragePrice
	{
		           public string   ProductName { get; set; } // nvarchar(40)
		[Nullable] public decimal? UnitPrice   { get; set; } // money(19,4)
	}

	// View
	[TableName(Name="Products by Category")]
	public partial class ProductsByCategory
	{
		           public string CategoryName    { get; set; } // nvarchar(15)
		           public string ProductName     { get; set; } // nvarchar(40)
		[Nullable] public string QuantityPerUnit { get; set; } // nvarchar(20)
		[Nullable] public short? UnitsInStock    { get; set; } // smallint(5)
		           public bool   Discontinued    { get; set; } // bit
	}

	// View
	[TableName(Name="Quarterly Orders")]
	public partial class QuarterlyOrders
	{
		[Nullable] public string CustomerID  { get; set; } // nchar(5)
		[Nullable] public string CompanyName { get; set; } // nvarchar(40)
		[Nullable] public string City        { get; set; } // nvarchar(15)
		[Nullable] public string Country     { get; set; } // nvarchar(15)
	}

	[TableName(Name="Region")]
	public partial class Region
	{
		[PrimaryKey(1)] public int    RegionID          { get; set; } // int(10)
		                public string RegionDescription { get; set; } // nchar(50)

		// FK_Territories_Region_BackReference
		[Association(ThisKey="RegionID", OtherKey="RegionID", CanBeNull=true)]
		public IEnumerable<Territories> Territoriess { get; set; }
	}

	// View
	[TableName(Name="Sales by Category")]
	public partial class SalesByCategory
	{
		           public int      CategoryID   { get; set; } // int(10)
		           public string   CategoryName { get; set; } // nvarchar(15)
		           public string   ProductName  { get; set; } // nvarchar(40)
		[Nullable] public decimal? ProductSales { get; set; } // money(19,4)
	}

	// View
	[TableName(Name="Sales Totals by Amount")]
	public partial class SalesTotalsByAmount
	{
		[Nullable] public decimal?  SaleAmount  { get; set; } // money(19,4)
		           public int       OrderID     { get; set; } // int(10)
		           public string    CompanyName { get; set; } // nvarchar(40)
		[Nullable] public DateTime? ShippedDate { get; set; } // datetime(3)
	}

	[TableName(Name="Shippers")]
	public partial class Shippers
	{
		[Identity, PrimaryKey(1)] public int    ShipperID   { get; set; } // int(10)
		                          public string CompanyName { get; set; } // nvarchar(40)
		[Nullable               ] public string Phone       { get; set; } // nvarchar(24)

		// FK_Orders_Shippers_BackReference
		[Association(ThisKey="ShipperID", OtherKey="ShipVia", CanBeNull=true)]
		public IEnumerable<Orders> Orderss { get; set; }
	}

	// View
	[TableName(Name="Summary of Sales by Quarter")]
	public partial class SummaryOfSalesByQuarter
	{
		[Nullable] public DateTime? ShippedDate { get; set; } // datetime(3)
		           public int       OrderID     { get; set; } // int(10)
		[Nullable] public decimal?  Subtotal    { get; set; } // money(19,4)
	}

	// View
	[TableName(Name="Summary of Sales by Year")]
	public partial class SummaryOfSalesByYear
	{
		[Nullable] public DateTime? ShippedDate { get; set; } // datetime(3)
		           public int       OrderID     { get; set; } // int(10)
		[Nullable] public decimal?  Subtotal    { get; set; } // money(19,4)
	}

	[TableName(Name="Suppliers")]
	public partial class Suppliers
	{
		[Identity, PrimaryKey(1)] public int    SupplierID   { get; set; } // int(10)
		                          public string CompanyName  { get; set; } // nvarchar(40)
		[Nullable               ] public string ContactName  { get; set; } // nvarchar(30)
		[Nullable               ] public string ContactTitle { get; set; } // nvarchar(30)
		[Nullable               ] public string Address      { get; set; } // nvarchar(60)
		[Nullable               ] public string City         { get; set; } // nvarchar(15)
		[Nullable               ] public string Region       { get; set; } // nvarchar(15)
		[Nullable               ] public string PostalCode   { get; set; } // nvarchar(10)
		[Nullable               ] public string Country      { get; set; } // nvarchar(15)
		[Nullable               ] public string Phone        { get; set; } // nvarchar(24)
		[Nullable               ] public string Fax          { get; set; } // nvarchar(24)
		[Nullable               ] public string HomePage     { get; set; } // ntext(1073741823)

		// FK_Products_Suppliers_BackReference
		[Association(ThisKey="SupplierID", OtherKey="SupplierID", CanBeNull=true)]
		public IEnumerable<Products> Productss { get; set; }
	}

	[TableName(Name="Territories")]
	public partial class Territories
	{
		[PrimaryKey(1)] public string TerritoryID          { get; set; } // nvarchar(20)
		                public string TerritoryDescription { get; set; } // nchar(50)
		                public int    RegionID             { get; set; } // int(10)

		// FK_Territories_Region
		[Association(ThisKey="RegionID", OtherKey="RegionID", CanBeNull=false)]
		public Region Region { get; set; }

		// FK_EmployeeTerritories_Territories_BackReference
		[Association(ThisKey="TerritoryID", OtherKey="TerritoryID", CanBeNull=true)]
		public IEnumerable<EmployeeTerritories> EmployeeTerritoriess { get; set; }
	}
}

namespace Client
{
	public partial class DataModel
	{
		public DataModel() : base(
			new BasicHttpBinding(BasicHttpSecurityMode.None)
			{
				MaxReceivedMessageSize = 10000000,
				MaxBufferSize          = 10000000,
				CloseTimeout           = new TimeSpan(00, 01, 00),
				OpenTimeout            = new TimeSpan(00, 01, 00),
				ReceiveTimeout         = new TimeSpan(00, 10, 00),
				SendTimeout            = new TimeSpan(00, 10, 00),
			},
			new EndpointAddress("http://localhost:31020/LinqWebService.asmx"))
			// base("TestLinqWebServiceSoap")
		{
		}
	}
}