diff Demo/Silverlight/Client/DataModel.generated.cs @ 0:f990fcb411a9

Копия текущей версии из github
author cin
date Thu, 27 Mar 2014 21:46:09 +0400
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Demo/Silverlight/Client/DataModel.generated.cs	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,640 @@
+//---------------------------------------------------------------------------------------------------
+// <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")
+		{
+		}
+	}
+}