Exemplo n.º 1
0
 internal void InitializeClass() {
     this.DataSetName = "SuposDataSet";
     this.Prefix = "";
     this.Namespace = "http://tempuri.org/TestDataSet.xsd";
     this.Locale = new System.Globalization.CultureInfo("fr-BE");
     this.CaseSensitive = false;
     this.EnforceConstraints = true;
     this.__tableCategories = new CategoriesDataTable();
     this.Tables.Add(this.__tableCategories);
     this.__tableProducts = new ProductsDataTable();
     this.Tables.Add(this.__tableProducts);
     this.__tableTaxes = new TaxesDataTable();
     this.Tables.Add(this.__tableTaxes);
     this.__tableCustomers = new CustomersDataTable();
     this.Tables.Add(this.__tableCustomers);
     this.__tableOrders = new OrdersDataTable();
     this.Tables.Add(this.__tableOrders);
     this.__tableOrderDetails = new OrderDetailsDataTable();
     this.Tables.Add(this.__tableOrderDetails);
     this.__tablePayments = new PaymentsDataTable();
     this.Tables.Add(this.__tablePayments);
     this.__tableMeta = new MetaDataTable();
     this.Tables.Add(this.__tableMeta);
     System.Data.UniqueConstraint uc;
     uc = new System.Data.UniqueConstraint("PK_Categories", new System.Data.DataColumn[] {
                 this.__tableCategories.Columns["Id"]}, true);
     this.__tableCategories.Constraints.Add(uc);
     uc = new System.Data.UniqueConstraint("PK_Products", new System.Data.DataColumn[] {
                 this.__tableProducts.Columns["Id"]}, true);
     this.__tableProducts.Constraints.Add(uc);
     uc = new System.Data.UniqueConstraint("PK_Taxes", new System.Data.DataColumn[] {
                 this.__tableTaxes.Columns["Id"]}, true);
     this.__tableTaxes.Constraints.Add(uc);
     uc = new System.Data.UniqueConstraint("PK_Clients", new System.Data.DataColumn[] {
                 this.__tableCustomers.Columns["Id"]}, true);
     this.__tableCustomers.Constraints.Add(uc);
     uc = new System.Data.UniqueConstraint("PK_Orders", new System.Data.DataColumn[] {
                 this.__tableOrders.Columns["Id"]}, true);
     this.__tableOrders.Constraints.Add(uc);
     uc = new System.Data.UniqueConstraint("PK_OrderDetails", new System.Data.DataColumn[] {
                 this.__tableOrderDetails.Columns["Id"]}, true);
     this.__tableOrderDetails.Constraints.Add(uc);
     uc = new System.Data.UniqueConstraint("PK_Payment", new System.Data.DataColumn[] {
                 this.__tablePayments.Columns["Id"]}, true);
     this.__tablePayments.Constraints.Add(uc);
     uc = new System.Data.UniqueConstraint("PK_Meta", new System.Data.DataColumn[] {
                 this.__tableMeta.Columns["Id"]}, true);
     this.__tableMeta.Constraints.Add(uc);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("FK_Categories_Products", new System.Data.DataColumn[] {
                 this.__tableCategories.Columns["Id"]}, new System.Data.DataColumn[] {
                 this.__tableProducts.Columns["CategoryId"]});
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.__tableProducts.Constraints.Add(fkc);
     fkc = new System.Data.ForeignKeyConstraint("FK_Taxes_Products", new System.Data.DataColumn[] {
                 this.__tableTaxes.Columns["Id"]}, new System.Data.DataColumn[] {
                 this.__tableProducts.Columns["DefaultTaxId"]});
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.__tableProducts.Constraints.Add(fkc);
     fkc = new System.Data.ForeignKeyConstraint("FK_Customers_Orders", new System.Data.DataColumn[] {
                 this.__tableCustomers.Columns["Id"]}, new System.Data.DataColumn[] {
                 this.__tableOrders.Columns["CustomerId"]});
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.__tableOrders.Constraints.Add(fkc);
     fkc = new System.Data.ForeignKeyConstraint("FK_Orders_OrderDetails", new System.Data.DataColumn[] {
                 this.__tableOrders.Columns["Id"]}, new System.Data.DataColumn[] {
                 this.__tableOrderDetails.Columns["OrderId"]});
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.__tableOrderDetails.Constraints.Add(fkc);
     fkc = new System.Data.ForeignKeyConstraint("PK_Products_OrderDetails", new System.Data.DataColumn[] {
                 this.__tableProducts.Columns["Id"]}, new System.Data.DataColumn[] {
                 this.__tableOrderDetails.Columns["ProductId"]});
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.__tableOrderDetails.Constraints.Add(fkc);
     fkc = new System.Data.ForeignKeyConstraint("PK_Taxes_OrderDetails", new System.Data.DataColumn[] {
                 this.__tableTaxes.Columns["Id"]}, new System.Data.DataColumn[] {
                 this.__tableOrderDetails.Columns["TaxId"]});
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.__tableOrderDetails.Constraints.Add(fkc);
     this.__relationFK_Orders_OrderDetailsRelation = new System.Data.DataRelation("FK_Orders_OrderDetails", new System.Data.DataColumn[] {
                 this.__tableOrders.Columns["Id"]}, new System.Data.DataColumn[] {
                 this.__tableOrderDetails.Columns["OrderId"]}, false);
     this.__relationFK_Orders_OrderDetailsRelation.Nested = false;
     this.Relations.Add(this.__relationFK_Orders_OrderDetailsRelation);
     this.__relationPK_Products_OrderDetailsRelation = new System.Data.DataRelation("PK_Products_OrderDetails", new System.Data.DataColumn[] {
                 this.__tableProducts.Columns["Id"]}, new System.Data.DataColumn[] {
                 this.__tableOrderDetails.Columns["ProductId"]}, false);
     this.__relationPK_Products_OrderDetailsRelation.Nested = false;
     this.Relations.Add(this.__relationPK_Products_OrderDetailsRelation);
     this.__relationPK_Taxes_OrderDetailsRelation = new System.Data.DataRelation("PK_Taxes_OrderDetails", new System.Data.DataColumn[] {
                 this.__tableTaxes.Columns["Id"]}, new System.Data.DataColumn[] {
                 this.__tableOrderDetails.Columns["TaxId"]}, false);
     this.__relationPK_Taxes_OrderDetailsRelation.Nested = false;
     this.Relations.Add(this.__relationPK_Taxes_OrderDetailsRelation);
     this.__relationFK_Customers_OrdersRelation = new System.Data.DataRelation("FK_Customers_Orders", new System.Data.DataColumn[] {
                 this.__tableCustomers.Columns["Id"]}, new System.Data.DataColumn[] {
                 this.__tableOrders.Columns["CustomerId"]}, false);
     this.__relationFK_Customers_OrdersRelation.Nested = false;
     this.Relations.Add(this.__relationFK_Customers_OrdersRelation);
     this.__relationFK_Categories_ProductsRelation = new System.Data.DataRelation("FK_Categories_Products", new System.Data.DataColumn[] {
                 this.__tableCategories.Columns["Id"]}, new System.Data.DataColumn[] {
                 this.__tableProducts.Columns["CategoryId"]}, false);
     this.__relationFK_Categories_ProductsRelation.Nested = false;
     this.Relations.Add(this.__relationFK_Categories_ProductsRelation);
     this.__relationFK_Taxes_ProductsRelation = new System.Data.DataRelation("FK_Taxes_Products", new System.Data.DataColumn[] {
                 this.__tableTaxes.Columns["Id"]}, new System.Data.DataColumn[] {
                 this.__tableProducts.Columns["DefaultTaxId"]}, false);
     this.__relationFK_Taxes_ProductsRelation.Nested = false;
     this.Relations.Add(this.__relationFK_Taxes_ProductsRelation);
     this.__relationR_Taxes_OrdersRelation = new System.Data.DataRelation("R_Taxes_Orders", new System.Data.DataColumn[] {
                 this.__tableTaxes.Columns["Id"]}, new System.Data.DataColumn[] {
                 this.__tableOrders.Columns["TaxId"]}, false);
     this.__relationR_Taxes_OrdersRelation.Nested = false;
     this.Relations.Add(this.__relationR_Taxes_OrdersRelation);
     this.__relationR_Payments_OrdersRelation = new System.Data.DataRelation("R_Payments_Orders", new System.Data.DataColumn[] {
                 this.__tablePayments.Columns["Id"]}, new System.Data.DataColumn[] {
                 this.__tableOrders.Columns["PaymentId"]}, false);
     this.__relationR_Payments_OrdersRelation.Nested = false;
     this.Relations.Add(this.__relationR_Payments_OrdersRelation);
 }
Exemplo n.º 2
0
 internal TaxesRow(System.Data.DataRowBuilder builder) : 
         base(builder) {
     this.tableTaxes = ((TaxesDataTable)(this.Table));
 }