Mercurial > pub > bltoolkit
diff Tools/Templates/MSSqlDataModel.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/Tools/Templates/MSSqlDataModel.generated.cs Thu Mar 27 21:46:09 2014 +0400 @@ -0,0 +1,648 @@ +//--------------------------------------------------------------------------------------------------- +// <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.Runtime.Serialization; +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.Validation; + +namespace MSSqlDataModel +{ + public partial class MSSqlDataContext : DataContext + { + public Table<AlphabeticalListOfProduct> AlphabeticalListOfProducts { get { return this.GetTable<AlphabeticalListOfProduct>(); } } + /// <summary> + /// Description for Categories table. + /// </summary> + public Table<Category> Categories { get { return this.GetTable<Category>(); } } + public Table<CategorySalesFor1997> CategorySalesFor1997 { get { return this.GetTable<CategorySalesFor1997>(); } } + public Table<CurrentProductList> CurrentProductLists { get { return this.GetTable<CurrentProductList>(); } } + public Table<CustomerAndSuppliersByCity> CustomerAndSuppliersByCities { get { return this.GetTable<CustomerAndSuppliersByCity>(); } } + public Table<CustomerCustomerDemo> CustomerCustomerDemos { get { return this.GetTable<CustomerCustomerDemo>(); } } + public Table<CustomerDemographic> CustomerDemographics { get { return this.GetTable<CustomerDemographic>(); } } + /// <summary> + /// Description of Customers table. + /// </summary> + public Table<Customer> Customers { get { return this.GetTable<Customer>(); } } + public Table<Employee> Employees { get { return this.GetTable<Employee>(); } } + public Table<EmployeeTerritory> EmployeeTerritories { get { return this.GetTable<EmployeeTerritory>(); } } + public Table<Invoice> Invoices { get { return this.GetTable<Invoice>(); } } + public Table<OrderDetail> OrderDetails { get { return this.GetTable<OrderDetail>(); } } + public Table<OrderDetailsExtended> OrderDetailsExtendeds { get { return this.GetTable<OrderDetailsExtended>(); } } + public Table<OrderSubtotal> OrderSubtotals { get { return this.GetTable<OrderSubtotal>(); } } + public Table<Order> Orders { get { return this.GetTable<Order>(); } } + public Table<OrdersQry> OrdersQries { get { return this.GetTable<OrdersQry>(); } } + public Table<ProductSalesFor1997> ProductSalesFor1997 { get { return this.GetTable<ProductSalesFor1997>(); } } + public Table<Product> Products { get { return this.GetTable<Product>(); } } + public Table<ProductsAboveAveragePrice> ProductsAboveAveragePrices { get { return this.GetTable<ProductsAboveAveragePrice>(); } } + public Table<ProductsByCategory> ProductsByCategories { get { return this.GetTable<ProductsByCategory>(); } } + public Table<QuarterlyOrder> QuarterlyOrders { get { return this.GetTable<QuarterlyOrder>(); } } + public Table<Region> Regions { get { return this.GetTable<Region>(); } } + public Table<SalesByCategory> SalesByCategories { get { return this.GetTable<SalesByCategory>(); } } + public Table<SalesTotalsByAmount> SalesTotalsByAmounts { get { return this.GetTable<SalesTotalsByAmount>(); } } + public Table<Shipper> Shippers { get { return this.GetTable<Shipper>(); } } + public Table<SummaryOfSalesByQuarter> SummaryOfSalesByQuarters { get { return this.GetTable<SummaryOfSalesByQuarter>(); } } + public Table<SummaryOfSalesByYear> SummaryOfSalesByYears { get { return this.GetTable<SummaryOfSalesByYear>(); } } + public Table<Supplier> Suppliers { get { return this.GetTable<Supplier>(); } } + public Table<Territory> Territories { get { return this.GetTable<Territory>(); } } + + #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 + [Serializable, DataContract] + [TableName(Name="Alphabetical list of products")] + public partial class AlphabeticalListOfProduct + { + [ DataMember, Required ] public int ProductID { get; set; } // int(10) + [ DataMember, MaxLength(40), Required] public string ProductName { get; set; } // nvarchar(40) + [Nullable, DataMember ] public int? SupplierID { get; set; } // int(10) + [Nullable, DataMember ] public int? CategoryID { get; set; } // int(10) + [Nullable, DataMember, MaxLength(20) ] public string QuantityPerUnit { get; set; } // nvarchar(20) + [Nullable, DataMember ] public decimal? UnitPrice { get; set; } // money(19,4) + [Nullable, DataMember ] public short? UnitsInStock { get; set; } // smallint(5) + [Nullable, DataMember ] public short? UnitsOnOrder { get; set; } // smallint(5) + [Nullable, DataMember ] public short? ReorderLevel { get; set; } // smallint(5) + [ DataMember, Required ] public bool Discontinued { get; set; } // bit + [ DataMember, MaxLength(15), Required] public string CategoryName { get; set; } // nvarchar(15) + } + + /// <summary> + /// Description for Categories table. + /// </summary> + [Serializable, DataContract] + [TableName(Name="Categories")] + public partial class Category + { + /// <summary> + /// Description of Categories.CategoryID field. + /// </summary> + [Identity, PrimaryKey(1), DataMember, Required ] public int CategoryID { get; set; } // int(10) + [ DataMember, MaxLength( 15), Required] public string CategoryName { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(1073741823) ] public string Description { get; set; } // ntext(1073741823) + [Nullable, DataMember ] public byte[] Picture { get; set; } // image(2147483647) + + // FK_Products_Categories_BackReference + [Association(ThisKey="CategoryID", OtherKey="CategoryID", CanBeNull=true)] + public IEnumerable<Product> Products { get; set; } + } + + // View + [Serializable, DataContract] + [TableName(Name="Category Sales for 1997")] + public partial class CategorySalesFor1997 + { + [ DataMember, MaxLength(15), Required] public string CategoryName { get; set; } // nvarchar(15) + [Nullable, DataMember ] public decimal? CategorySales { get; set; } // money(19,4) + } + + // View + [Serializable, DataContract] + [TableName(Name="Current Product List")] + public partial class CurrentProductList + { + [Identity, DataMember, Required ] public int ProductID { get; set; } // int(10) + [ DataMember, MaxLength(40), Required] public string ProductName { get; set; } // nvarchar(40) + } + + // View + [Serializable, DataContract] + [TableName(Name="Customer and Suppliers by City")] + public partial class CustomerAndSuppliersByCity + { + [Nullable, DataMember, MaxLength(15) ] public string City { get; set; } // nvarchar(15) + [ DataMember, MaxLength(40), Required] public string CompanyName { get; set; } // nvarchar(40) + [Nullable, DataMember, MaxLength(30) ] public string ContactName { get; set; } // nvarchar(30) + [ DataMember, MaxLength( 9), Required] public string Relationship { get; set; } // varchar(9) + } + + [Serializable, DataContract] + [TableName(Name="CustomerCustomerDemo")] + public partial class CustomerCustomerDemo + { + [PrimaryKey(1), DataMember, MaxLength( 5), Required] public string CustomerID { get; set; } // nchar(5) + [PrimaryKey(2), DataMember, MaxLength(10), Required] public string CustomerTypeID { get; set; } // nchar(10) + + // FK_CustomerCustomerDemo + [Association(ThisKey="CustomerTypeID", OtherKey="CustomerTypeID", CanBeNull=false)] + public CustomerDemographic FK_CustomerCustomerDemo { get; set; } + + // FK_CustomerCustomerDemo_Customers + [Association(ThisKey="CustomerID", OtherKey="CustomerID", CanBeNull=false)] + public Customer Customer { get; set; } + } + + [Serializable, DataContract] + [TableName(Name="CustomerDemographics")] + public partial class CustomerDemographic + { + [ PrimaryKey(1), DataMember, MaxLength( 10), Required] public string CustomerTypeID { get; set; } // nchar(10) + [Nullable, DataMember, MaxLength(1073741823) ] 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> + [Serializable, DataContract] + [TableName(Name="Customers")] + public partial class Customer + { + /// <summary> + /// Just ID. + /// </summary> + [ PrimaryKey(1), DataMember, MaxLength( 5), Required] public string CustomerID { get; set; } // nchar(5) + /// <summary> + /// Name of the Company. + /// </summary> + [ DataMember, MaxLength(40), Required] public string CompanyName { get; set; } // nvarchar(40) + [Nullable, DataMember, MaxLength(30) ] public string ContactName { get; set; } // nvarchar(30) + [Nullable, DataMember, MaxLength(30) ] public string ContactTitle { get; set; } // nvarchar(30) + [Nullable, DataMember, MaxLength(60) ] public string Address { get; set; } // nvarchar(60) + [Nullable, DataMember, MaxLength(15) ] public string City { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(15) ] public string Region { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(10) ] public string PostalCode { get; set; } // nvarchar(10) + [Nullable, DataMember, MaxLength(15) ] public string Country { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(24) ] public string Phone { get; set; } // nvarchar(24) + [Nullable, DataMember, MaxLength(24) ] public string Fax { get; set; } // nvarchar(24) + + // FK_Orders_Customers_BackReference + [Association(ThisKey="CustomerID", OtherKey="CustomerID", CanBeNull=true)] + public IEnumerable<Order> Orders { get; set; } + + // FK_CustomerCustomerDemo_Customers_BackReference + [Association(ThisKey="CustomerID", OtherKey="CustomerID", CanBeNull=true)] + public IEnumerable<CustomerCustomerDemo> CustomerCustomerDemos { get; set; } + } + + [Serializable, DataContract] + [TableName(Name="Employees")] + public partial class Employee + { + [Identity, PrimaryKey(1), DataMember, Required ] public int EmployeeID { get; set; } // int(10) + [ DataMember, MaxLength( 20), Required] public string LastName { get; set; } // nvarchar(20) + [ DataMember, MaxLength( 10), Required] public string FirstName { get; set; } // nvarchar(10) + [Nullable, DataMember, MaxLength( 30) ] public string Title { get; set; } // nvarchar(30) + [Nullable, DataMember, MaxLength( 25) ] public string TitleOfCourtesy { get; set; } // nvarchar(25) + [Nullable, DataMember ] public DateTime? BirthDate { get; set; } // datetime(3) + [Nullable, DataMember ] public DateTime? HireDate { get; set; } // datetime(3) + [Nullable, DataMember, MaxLength( 60) ] public string Address { get; set; } // nvarchar(60) + [Nullable, DataMember, MaxLength( 15) ] public string City { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength( 15) ] public string Region { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength( 10) ] public string PostalCode { get; set; } // nvarchar(10) + [Nullable, DataMember, MaxLength( 15) ] public string Country { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength( 24) ] public string HomePhone { get; set; } // nvarchar(24) + [Nullable, DataMember, MaxLength( 4) ] public string Extension { get; set; } // nvarchar(4) + [Nullable, DataMember ] public byte[] Photo { get; set; } // image(2147483647) + [Nullable, DataMember, MaxLength(1073741823) ] public string Notes { get; set; } // ntext(1073741823) + [Nullable, DataMember ] public int? ReportsTo { get; set; } // int(10) + [Nullable, DataMember, MaxLength( 255) ] public string PhotoPath { get; set; } // nvarchar(255) + + // FK_Employees_Employees + [Association(ThisKey="ReportsTo", OtherKey="EmployeeID", CanBeNull=true)] + public Employee FK_Employees_Employees { get; set; } + + // FK_Orders_Employees_BackReference + [Association(ThisKey="EmployeeID", OtherKey="EmployeeID", CanBeNull=true)] + public IEnumerable<Order> Orders { get; set; } + + // FK_EmployeeTerritories_Employees_BackReference + [Association(ThisKey="EmployeeID", OtherKey="EmployeeID", CanBeNull=true)] + public IEnumerable<EmployeeTerritory> EmployeeTerritories { get; set; } + + // FK_Employees_Employees_BackReference + [Association(ThisKey="EmployeeID", OtherKey="ReportsTo", CanBeNull=true)] + public IEnumerable<Employee> FK_Employees_Employees_BackReference { get; set; } + } + + [Serializable, DataContract] + [TableName(Name="EmployeeTerritories")] + public partial class EmployeeTerritory + { + [PrimaryKey(1), DataMember, Required ] public int EmployeeID { get; set; } // int(10) + [PrimaryKey(2), DataMember, MaxLength(20), Required] public string TerritoryID { get; set; } // nvarchar(20) + + // FK_EmployeeTerritories_Employees + [Association(ThisKey="EmployeeID", OtherKey="EmployeeID", CanBeNull=false)] + public Employee Employee { get; set; } + + // FK_EmployeeTerritories_Territories + [Association(ThisKey="TerritoryID", OtherKey="TerritoryID", CanBeNull=false)] + public Territory Territory { get; set; } + } + + // View + [Serializable, DataContract] + [TableName(Name="Invoices")] + public partial class Invoice + { + [Nullable, DataMember, MaxLength(40) ] public string ShipName { get; set; } // nvarchar(40) + [Nullable, DataMember, MaxLength(60) ] public string ShipAddress { get; set; } // nvarchar(60) + [Nullable, DataMember, MaxLength(15) ] public string ShipCity { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(15) ] public string ShipRegion { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(10) ] public string ShipPostalCode { get; set; } // nvarchar(10) + [Nullable, DataMember, MaxLength(15) ] public string ShipCountry { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength( 5) ] public string CustomerID { get; set; } // nchar(5) + [ DataMember, MaxLength(40), Required] public string CustomerName { get; set; } // nvarchar(40) + [Nullable, DataMember, MaxLength(60) ] public string Address { get; set; } // nvarchar(60) + [Nullable, DataMember, MaxLength(15) ] public string City { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(15) ] public string Region { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(10) ] public string PostalCode { get; set; } // nvarchar(10) + [Nullable, DataMember, MaxLength(15) ] public string Country { get; set; } // nvarchar(15) + [ DataMember, MaxLength(31), Required] public string Salesperson { get; set; } // nvarchar(31) + [ DataMember, Required ] public int OrderID { get; set; } // int(10) + [Nullable, DataMember ] public DateTime? OrderDate { get; set; } // datetime(3) + [Nullable, DataMember ] public DateTime? RequiredDate { get; set; } // datetime(3) + [Nullable, DataMember ] public DateTime? ShippedDate { get; set; } // datetime(3) + [ DataMember, MaxLength(40), Required] public string ShipperName { get; set; } // nvarchar(40) + [ DataMember, Required ] public int ProductID { get; set; } // int(10) + [ DataMember, MaxLength(40), Required] public string ProductName { get; set; } // nvarchar(40) + [ DataMember, Required ] public decimal UnitPrice { get; set; } // money(19,4) + [ DataMember, Required ] public short Quantity { get; set; } // smallint(5) + [ DataMember, Required ] public float Discount { get; set; } // real(24) + [Nullable, DataMember ] public decimal? ExtendedPrice { get; set; } // money(19,4) + [Nullable, DataMember ] public decimal? Freight { get; set; } // money(19,4) + } + + [Serializable, DataContract] + [TableName(Name="Order Details")] + public partial class OrderDetail + { + [PrimaryKey(1), DataMember, Required] public int OrderID { get; set; } // int(10) + [PrimaryKey(2), DataMember, Required] public int ProductID { get; set; } // int(10) + [ DataMember, Required] public decimal UnitPrice { get; set; } // money(19,4) + [ DataMember, Required] public short Quantity { get; set; } // smallint(5) + [ DataMember, Required] public float Discount { get; set; } // real(24) + + // FK_Order_Details_Orders + [Association(ThisKey="OrderID", OtherKey="OrderID", CanBeNull=false)] + public Order OrderDetailsOrder { get; set; } + + // FK_Order_Details_Products + [Association(ThisKey="ProductID", OtherKey="ProductID", CanBeNull=false)] + public Product OrderDetailsProduct { get; set; } + } + + // View + [Serializable, DataContract] + [TableName(Name="Order Details Extended")] + public partial class OrderDetailsExtended + { + [ DataMember, Required ] public int OrderID { get; set; } // int(10) + [ DataMember, Required ] public int ProductID { get; set; } // int(10) + [ DataMember, MaxLength(40), Required] public string ProductName { get; set; } // nvarchar(40) + [ DataMember, Required ] public decimal UnitPrice { get; set; } // money(19,4) + [ DataMember, Required ] public short Quantity { get; set; } // smallint(5) + [ DataMember, Required ] public float Discount { get; set; } // real(24) + [Nullable, DataMember ] public decimal? ExtendedPrice { get; set; } // money(19,4) + } + + // View + [Serializable, DataContract] + [TableName(Name="Order Subtotals")] + public partial class OrderSubtotal + { + [ DataMember, Required] public int OrderID { get; set; } // int(10) + [Nullable, DataMember ] public decimal? Subtotal { get; set; } // money(19,4) + } + + [Serializable, DataContract] + [TableName(Name="Orders")] + public partial class Order + { + [Identity, PrimaryKey(1), DataMember, Required ] public int OrderID { get; set; } // int(10) + [Nullable, DataMember, MaxLength( 5)] public string CustomerID { get; set; } // nchar(5) + [Nullable, DataMember ] public int? EmployeeID { get; set; } // int(10) + [Nullable, DataMember ] public DateTime? OrderDate { get; set; } // datetime(3) + [Nullable, DataMember ] public DateTime? RequiredDate { get; set; } // datetime(3) + [Nullable, DataMember ] public DateTime? ShippedDate { get; set; } // datetime(3) + [Nullable, DataMember ] public int? ShipVia { get; set; } // int(10) + [Nullable, DataMember ] public decimal? Freight { get; set; } // money(19,4) + [Nullable, DataMember, MaxLength(40)] public string ShipName { get; set; } // nvarchar(40) + [Nullable, DataMember, MaxLength(60)] public string ShipAddress { get; set; } // nvarchar(60) + [Nullable, DataMember, MaxLength(15)] public string ShipCity { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(15)] public string ShipRegion { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(10)] public string ShipPostalCode { get; set; } // nvarchar(10) + [Nullable, DataMember, MaxLength(15)] public string ShipCountry { get; set; } // nvarchar(15) + + // FK_Orders_Shippers + [Association(ThisKey="ShipVia", OtherKey="ShipperID", CanBeNull=true)] + public Shipper Shipper { get; set; } + + // FK_Orders_Employees + [Association(ThisKey="EmployeeID", OtherKey="EmployeeID", CanBeNull=true)] + public Employee Employee { get; set; } + + // FK_Orders_Customers + [Association(ThisKey="CustomerID", OtherKey="CustomerID", CanBeNull=true)] + public Customer Customer { get; set; } + + // FK_Order_Details_Orders_BackReference + [Association(ThisKey="OrderID", OtherKey="OrderID", CanBeNull=true)] + public IEnumerable<OrderDetail> OrderDetails { get; set; } + } + + // View + [Serializable, DataContract] + [TableName(Name="Orders Qry")] + public partial class OrdersQry + { + [ DataMember, Required ] public int OrderID { get; set; } // int(10) + [Nullable, DataMember, MaxLength( 5) ] public string CustomerID { get; set; } // nchar(5) + [Nullable, DataMember ] public int? EmployeeID { get; set; } // int(10) + [Nullable, DataMember ] public DateTime? OrderDate { get; set; } // datetime(3) + [Nullable, DataMember ] public DateTime? RequiredDate { get; set; } // datetime(3) + [Nullable, DataMember ] public DateTime? ShippedDate { get; set; } // datetime(3) + [Nullable, DataMember ] public int? ShipVia { get; set; } // int(10) + [Nullable, DataMember ] public decimal? Freight { get; set; } // money(19,4) + [Nullable, DataMember, MaxLength(40) ] public string ShipName { get; set; } // nvarchar(40) + [Nullable, DataMember, MaxLength(60) ] public string ShipAddress { get; set; } // nvarchar(60) + [Nullable, DataMember, MaxLength(15) ] public string ShipCity { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(15) ] public string ShipRegion { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(10) ] public string ShipPostalCode { get; set; } // nvarchar(10) + [Nullable, DataMember, MaxLength(15) ] public string ShipCountry { get; set; } // nvarchar(15) + [ DataMember, MaxLength(40), Required] public string CompanyName { get; set; } // nvarchar(40) + [Nullable, DataMember, MaxLength(60) ] public string Address { get; set; } // nvarchar(60) + [Nullable, DataMember, MaxLength(15) ] public string City { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(15) ] public string Region { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(10) ] public string PostalCode { get; set; } // nvarchar(10) + [Nullable, DataMember, MaxLength(15) ] public string Country { get; set; } // nvarchar(15) + } + + // View + [Serializable, DataContract] + [TableName(Name="Product Sales for 1997")] + public partial class ProductSalesFor1997 + { + [ DataMember, MaxLength(15), Required] public string CategoryName { get; set; } // nvarchar(15) + [ DataMember, MaxLength(40), Required] public string ProductName { get; set; } // nvarchar(40) + [Nullable, DataMember ] public decimal? ProductSales { get; set; } // money(19,4) + } + + [Serializable, DataContract] + [TableName(Name="Products")] + public partial class Product + { + [Identity, PrimaryKey(1), DataMember, Required ] public int ProductID { get; set; } // int(10) + [ DataMember, MaxLength(40), Required] public string ProductName { get; set; } // nvarchar(40) + [Nullable, DataMember ] public int? SupplierID { get; set; } // int(10) + [Nullable, DataMember ] public int? CategoryID { get; set; } // int(10) + [Nullable, DataMember, MaxLength(20) ] public string QuantityPerUnit { get; set; } // nvarchar(20) + [Nullable, DataMember ] public decimal? UnitPrice { get; set; } // money(19,4) + [Nullable, DataMember ] public short? UnitsInStock { get; set; } // smallint(5) + [Nullable, DataMember ] public short? UnitsOnOrder { get; set; } // smallint(5) + [Nullable, DataMember ] public short? ReorderLevel { get; set; } // smallint(5) + [ DataMember, Required ] public bool Discontinued { get; set; } // bit + + // FK_Products_Suppliers + [Association(ThisKey="SupplierID", OtherKey="SupplierID", CanBeNull=true)] + public Supplier Supplier { get; set; } + + // FK_Products_Categories + [Association(ThisKey="CategoryID", OtherKey="CategoryID", CanBeNull=true)] + public Category Category { get; set; } + + // FK_Order_Details_Products_BackReference + [Association(ThisKey="ProductID", OtherKey="ProductID", CanBeNull=true)] + public IEnumerable<OrderDetail> OrderDetails { get; set; } + } + + // View + [Serializable, DataContract] + [TableName(Name="Products Above Average Price")] + public partial class ProductsAboveAveragePrice + { + [ DataMember, MaxLength(40), Required] public string ProductName { get; set; } // nvarchar(40) + [Nullable, DataMember ] public decimal? UnitPrice { get; set; } // money(19,4) + } + + // View + [Serializable, DataContract] + [TableName(Name="Products by Category")] + public partial class ProductsByCategory + { + [ DataMember, MaxLength(15), Required] public string CategoryName { get; set; } // nvarchar(15) + [ DataMember, MaxLength(40), Required] public string ProductName { get; set; } // nvarchar(40) + [Nullable, DataMember, MaxLength(20) ] public string QuantityPerUnit { get; set; } // nvarchar(20) + [Nullable, DataMember ] public short? UnitsInStock { get; set; } // smallint(5) + [ DataMember, Required ] public bool Discontinued { get; set; } // bit + } + + // View + [Serializable, DataContract] + [TableName(Name="Quarterly Orders")] + public partial class QuarterlyOrder + { + [Nullable, DataMember, MaxLength( 5)] public string CustomerID { get; set; } // nchar(5) + [Nullable, DataMember, MaxLength(40)] public string CompanyName { get; set; } // nvarchar(40) + [Nullable, DataMember, MaxLength(15)] public string City { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength(15)] public string Country { get; set; } // nvarchar(15) + } + + [Serializable, DataContract] + [TableName(Name="Region")] + public partial class Region + { + [PrimaryKey(1), DataMember, Required ] public int RegionID { get; set; } // int(10) + [ DataMember, MaxLength(50), Required] public string RegionDescription { get; set; } // nchar(50) + + // FK_Territories_Region_BackReference + [Association(ThisKey="RegionID", OtherKey="RegionID", CanBeNull=true)] + public IEnumerable<Territory> Territories { get; set; } + } + + // View + [Serializable, DataContract] + [TableName(Name="Sales by Category")] + public partial class SalesByCategory + { + [ DataMember, Required ] public int CategoryID { get; set; } // int(10) + [ DataMember, MaxLength(15), Required] public string CategoryName { get; set; } // nvarchar(15) + [ DataMember, MaxLength(40), Required] public string ProductName { get; set; } // nvarchar(40) + [Nullable, DataMember ] public decimal? ProductSales { get; set; } // money(19,4) + } + + // View + [Serializable, DataContract] + [TableName(Name="Sales Totals by Amount")] + public partial class SalesTotalsByAmount + { + [Nullable, DataMember ] public decimal? SaleAmount { get; set; } // money(19,4) + [ DataMember, Required ] public int OrderID { get; set; } // int(10) + [ DataMember, MaxLength(40), Required] public string CompanyName { get; set; } // nvarchar(40) + [Nullable, DataMember ] public DateTime? ShippedDate { get; set; } // datetime(3) + } + + [Serializable, DataContract] + [TableName(Name="Shippers")] + public partial class Shipper + { + [Identity, PrimaryKey(1), DataMember, Required ] public int ShipperID { get; set; } // int(10) + [ DataMember, MaxLength(40), Required] public string CompanyName { get; set; } // nvarchar(40) + [Nullable, DataMember, MaxLength(24) ] public string Phone { get; set; } // nvarchar(24) + + // FK_Orders_Shippers_BackReference + [Association(ThisKey="ShipperID", OtherKey="ShipVia", CanBeNull=true)] + public IEnumerable<Order> Orders { get; set; } + } + + // View + [Serializable, DataContract] + [TableName(Name="Summary of Sales by Quarter")] + public partial class SummaryOfSalesByQuarter + { + [Nullable, DataMember ] public DateTime? ShippedDate { get; set; } // datetime(3) + [ DataMember, Required] public int OrderID { get; set; } // int(10) + [Nullable, DataMember ] public decimal? Subtotal { get; set; } // money(19,4) + } + + // View + [Serializable, DataContract] + [TableName(Name="Summary of Sales by Year")] + public partial class SummaryOfSalesByYear + { + [Nullable, DataMember ] public DateTime? ShippedDate { get; set; } // datetime(3) + [ DataMember, Required] public int OrderID { get; set; } // int(10) + [Nullable, DataMember ] public decimal? Subtotal { get; set; } // money(19,4) + } + + [Serializable, DataContract] + [TableName(Name="Suppliers")] + public partial class Supplier + { + [Identity, PrimaryKey(1), DataMember, Required ] public int SupplierID { get; set; } // int(10) + [ DataMember, MaxLength( 40), Required] public string CompanyName { get; set; } // nvarchar(40) + [Nullable, DataMember, MaxLength( 30) ] public string ContactName { get; set; } // nvarchar(30) + [Nullable, DataMember, MaxLength( 30) ] public string ContactTitle { get; set; } // nvarchar(30) + [Nullable, DataMember, MaxLength( 60) ] public string Address { get; set; } // nvarchar(60) + [Nullable, DataMember, MaxLength( 15) ] public string City { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength( 15) ] public string Region { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength( 10) ] public string PostalCode { get; set; } // nvarchar(10) + [Nullable, DataMember, MaxLength( 15) ] public string Country { get; set; } // nvarchar(15) + [Nullable, DataMember, MaxLength( 24) ] public string Phone { get; set; } // nvarchar(24) + [Nullable, DataMember, MaxLength( 24) ] public string Fax { get; set; } // nvarchar(24) + [Nullable, DataMember, MaxLength(1073741823) ] public string HomePage { get; set; } // ntext(1073741823) + + // FK_Products_Suppliers_BackReference + [Association(ThisKey="SupplierID", OtherKey="SupplierID", CanBeNull=true)] + public IEnumerable<Product> Products { get; set; } + } + + [Serializable, DataContract] + [TableName(Name="Territories")] + public partial class Territory + { + [PrimaryKey(1), DataMember, MaxLength(20), Required] public string TerritoryID { get; set; } // nvarchar(20) + [ DataMember, MaxLength(50), Required] public string TerritoryDescription { get; set; } // nchar(50) + [ DataMember, Required ] 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<EmployeeTerritory> EmployeeTerritories { get; set; } + } +}