private void InitClass()
 {
     this.DataSetName             = "ResxData";
     this.Prefix                  = "";
     this.Namespace               = "http://tempuri.org/ResxData.xsd";
     this.EnforceConstraints      = true;
     this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     this.tableResx               = new ResxDataTable();
     base.Tables.Add(this.tableResx);
     this.tableResxLocalized = new ResxLocalizedDataTable();
     base.Tables.Add(this.tableResxLocalized);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("FK_Resx_ResxLocalized", new System.Data.DataColumn[] {
         this.tableResx.IdColumn
     }, new System.Data.DataColumn[] {
         this.tableResxLocalized.ParentIdColumn
     });
     this.tableResxLocalized.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule       = System.Data.Rule.Cascade;
     fkc.UpdateRule       = System.Data.Rule.Cascade;
     this.relationFK_Resx_ResxLocalized = new System.Data.DataRelation("FK_Resx_ResxLocalized", new System.Data.DataColumn[] {
         this.tableResx.IdColumn
     }, new System.Data.DataColumn[] {
         this.tableResxLocalized.ParentIdColumn
     }, false);
     this.Relations.Add(this.relationFK_Resx_ResxLocalized);
 }
 private void InitClass()
 {
     this.DataSetName             = "QuestionAnswerSet";
     this.Prefix                  = "";
     this.Namespace               = "http://tempuri.org/QuestionAnswerSet.xsd";
     this.EnforceConstraints      = true;
     this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     this.tableAnswers            = new AnswersDataTable();
     base.Tables.Add(this.tableAnswers);
     this.tableQuestions = new QuestionsDataTable();
     base.Tables.Add(this.tableQuestions);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("QuestionsAnswers", new System.Data.DataColumn[] {
         this.tableQuestions.IdColumn
     }, new System.Data.DataColumn[] {
         this.tableAnswers.QuestionIdColumn
     });
     this.tableAnswers.Constraints.Add(fkc);
     fkc.AcceptRejectRule          = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule                = System.Data.Rule.Cascade;
     fkc.UpdateRule                = System.Data.Rule.Cascade;
     this.relationQuestionsAnswers = new System.Data.DataRelation("QuestionsAnswers", new System.Data.DataColumn[] {
         this.tableQuestions.IdColumn
     }, new System.Data.DataColumn[] {
         this.tableAnswers.QuestionIdColumn
     }, false);
     this.Relations.Add(this.relationQuestionsAnswers);
 }
Beispiel #3
0
 private void InitClass()
 {
     this.DataSetName             = "Tasks";
     this.Prefix                  = "";
     this.EnforceConstraints      = true;
     this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     this.tableTask               = new TaskDataTable();
     base.Tables.Add(this.tableTask);
     this.tableSchedule = new ScheduleDataTable();
     base.Tables.Add(this.tableSchedule);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("Task_Schedule", new System.Data.DataColumn[] {
         this.tableTask.Task_IdColumn
     }, new System.Data.DataColumn[] {
         this.tableSchedule.Task_IdColumn
     });
     this.tableSchedule.Constraints.Add(fkc);
     fkc.AcceptRejectRule       = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule             = System.Data.Rule.Cascade;
     fkc.UpdateRule             = System.Data.Rule.Cascade;
     this.relationTask_Schedule = new System.Data.DataRelation("Task_Schedule", new System.Data.DataColumn[] {
         this.tableTask.Task_IdColumn
     }, new System.Data.DataColumn[] {
         this.tableSchedule.Task_IdColumn
     }, false);
     this.relationTask_Schedule.Nested = true;
     this.Relations.Add(this.relationTask_Schedule);
 }
Beispiel #4
0
 private void InitClass()
 {
     this.DataSetName                = "vistaForm";
     this.Prefix                     = "";
     this.Namespace                  = "http://tempuri.org/VistaDettSpeseIncassi.xsd";
     this.EnforceConstraints         = true;
     this.SchemaSerializationMode    = System.Data.SchemaSerializationMode.IncludeSchema;
     this.tableexpenselinkedproceeds = new expenselinkedproceedsDataTable();
     base.Tables.Add(this.tableexpenselinkedproceeds);
     this.tablelinkedexpense = new linkedexpenseDataTable();
     base.Tables.Add(this.tablelinkedexpense);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("vistaFormKey2", new System.Data.DataColumn[] {
         this.tablelinkedexpense.idlinkedexpenseColumn
     }, new System.Data.DataColumn[] {
         this.tableexpenselinkedproceeds.idlinkedexpenseColumn
     });
     this.tableexpenselinkedproceeds.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule       = System.Data.Rule.Cascade;
     fkc.UpdateRule       = System.Data.Rule.Cascade;
     this.relationlinkedexpenseexpenselinkedproceeds = new System.Data.DataRelation("linkedexpenseexpenselinkedproceeds", new System.Data.DataColumn[] {
         this.tablelinkedexpense.idlinkedexpenseColumn
     }, new System.Data.DataColumn[] {
         this.tableexpenselinkedproceeds.idlinkedexpenseColumn
     }, false);
     this.Relations.Add(this.relationlinkedexpenseexpenselinkedproceeds);
 }
 private void InitClass()
 {
     this.DataSetName        = "BookDataSet";
     this.Prefix             = "";
     this.Namespace          = "urn:apress-proadonet-chapter5-BookDataSet.xsd";
     this.EnforceConstraints = true;
     this.tableBooks         = new BooksDataTable();
     base.Tables.Add(this.tableBooks);
     this.tableBookReviews = new BookReviewsDataTable();
     base.Tables.Add(this.tableBookReviews);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("Reviews", new System.Data.DataColumn[] {
         this.tableBooks.BookIDColumn
     }, new System.Data.DataColumn[] {
         this.tableBookReviews.BookIDColumn
     });
     this.tableBookReviews.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule       = System.Data.Rule.Cascade;
     fkc.UpdateRule       = System.Data.Rule.Cascade;
     this.relationReviews = new System.Data.DataRelation("Reviews", new System.Data.DataColumn[] {
         this.tableBooks.BookIDColumn
     }, new System.Data.DataColumn[] {
         this.tableBookReviews.BookIDColumn
     }, false);
     this.relationReviews.ExtendedProperties.Add("typedChildren", "Reviews");
     this.relationReviews.ExtendedProperties.Add("typedParent", "Book");
     this.Relations.Add(this.relationReviews);
 }
Beispiel #6
0
 private void InitClass()
 {
     this.DataSetName        = "ParentChildDataSet";
     this.Prefix             = "";
     this.Namespace          = "http://tempuri.org/ParentChildDataSet.xsd";
     this.Locale             = new System.Globalization.CultureInfo("en-US");
     this.CaseSensitive      = false;
     this.EnforceConstraints = true;
     this.tableTreeNodes     = new TreeNodesDataTable();
     base.Tables.Add(this.tableTreeNodes);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("FK_TreeNodes_ParentTreeNodes", new System.Data.DataColumn[] {
         this.tableTreeNodes.TreeNodeIDColumn
     }, new System.Data.DataColumn[] {
         this.tableTreeNodes.ParentTreeNodeIDColumn
     });
     this.tableTreeNodes.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule       = System.Data.Rule.None;
     fkc.UpdateRule       = System.Data.Rule.None;
     this.relationFK_TreeNodes_ParentTreeNodes = new System.Data.DataRelation("FK_TreeNodes_ParentTreeNodes", new System.Data.DataColumn[] {
         this.tableTreeNodes.TreeNodeIDColumn
     }, new System.Data.DataColumn[] {
         this.tableTreeNodes.ParentTreeNodeIDColumn
     }, false);
     this.relationFK_TreeNodes_ParentTreeNodes.Nested = true;
     this.Relations.Add(this.relationFK_TreeNodes_ParentTreeNodes);
     this.ExtendedProperties.Add("DSGenerator_DataSetName", "ParentChildDataSet");
     this.ExtendedProperties.Add("User_DataSetName", "ParentChildDataSet");
 }
 private void InitClass() {
     this.DataSetName = "NorthwindCustomerOrders";
     this.Prefix = "";
     this.EnforceConstraints = true;
     this.tableCustomers = new CustomersDataTable();
     base.Tables.Add(this.tableCustomers);
     this.tableOrders = new OrdersDataTable();
     base.Tables.Add(this.tableOrders);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("CustOrders", new System.Data.DataColumn[] {
                 this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.CustomerIDColumn});
     this.tableOrders.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.relationCustOrders = new System.Data.DataRelation("CustOrders", new System.Data.DataColumn[] {
                 this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.CustomerIDColumn}, false);
     this.Relations.Add(this.relationCustOrders);
 }
Beispiel #8
0
 private void InitClass() {
     this.DataSetName = "MDataSet";
     this.Prefix = "";
     this.Namespace = "http://tempuri.org/MDataSet.xsd";
     this.EnforceConstraints = true;
     this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     this.tableCash = new CashDataTable();
     base.Tables.Add(this.tableCash);
     this.tableDocumentType = new DocumentTypeDataTable();
     base.Tables.Add(this.tableDocumentType);
     this.tableInvoiceMaster = new InvoiceMasterDataTable();
     base.Tables.Add(this.tableInvoiceMaster);
     this.tableInvoiceDetail = new InvoiceDetailDataTable(false);
     base.Tables.Add(this.tableInvoiceDetail);
     this.tablePeriods = new PeriodsDataTable();
     base.Tables.Add(this.tablePeriods);
     this.tableReceiptDetail = new ReceiptDetailDataTable(false);
     base.Tables.Add(this.tableReceiptDetail);
     this.tableReceiptMaster = new ReceiptMasterDataTable();
     base.Tables.Add(this.tableReceiptMaster);
     this.tableReceiptRemains = new ReceiptRemainsDataTable();
     base.Tables.Add(this.tableReceiptRemains);
     this.tableProduct = new ProductDataTable();
     base.Tables.Add(this.tableProduct);
     this.tableRemains = new RemainsDataTable(false);
     base.Tables.Add(this.tableRemains);
     this.tableStock = new StockDataTable();
     base.Tables.Add(this.tableStock);
     this.tableLocalSetting = new LocalSettingDataTable();
     base.Tables.Add(this.tableLocalSetting);
     this.tableOrders = new OrdersDataTable();
     base.Tables.Add(this.tableOrders);
     this.tableinventoryMaster = new inventoryMasterDataTable();
     base.Tables.Add(this.tableinventoryMaster);
     this.tableinventoryDetails = new inventoryDetailsDataTable(false);
     base.Tables.Add(this.tableinventoryDetails);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("FK_InvoiceDetail_InvoiceMaster", new System.Data.DataColumn[] {
                 this.tableInvoiceMaster.IDColumn}, new System.Data.DataColumn[] {
                 this.tableInvoiceDetail.InvoiceMasterRefColumn});
     this.tableInvoiceDetail.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.None;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("Remains_InvoiceDetail", new System.Data.DataColumn[] {
                 this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] {
                 this.tableInvoiceDetail.LocalReceiptDetailRefColumn});
     this.tableInvoiceDetail.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.None;
     fkc.UpdateRule = System.Data.Rule.None;
     fkc = new System.Data.ForeignKeyConstraint("FK_inventoryMaster_inventoryDetails", new System.Data.DataColumn[] {
                 this.tableinventoryMaster.IDColumn}, new System.Data.DataColumn[] {
                 this.tableinventoryDetails.inventoryMasterRefColumn});
     this.tableinventoryDetails.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.None;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.relationFK_InvoiceDetail_InvoiceMaster = new System.Data.DataRelation("FK_InvoiceDetail_InvoiceMaster", new System.Data.DataColumn[] {
                 this.tableInvoiceMaster.IDColumn}, new System.Data.DataColumn[] {
                 this.tableInvoiceDetail.InvoiceMasterRefColumn}, false);
     this.Relations.Add(this.relationFK_InvoiceDetail_InvoiceMaster);
     this.relationRemains_InvoiceDetail = new System.Data.DataRelation("Remains_InvoiceDetail", new System.Data.DataColumn[] {
                 this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] {
                 this.tableInvoiceDetail.LocalReceiptDetailRefColumn}, false);
     this.Relations.Add(this.relationRemains_InvoiceDetail);
     this.relationFK_inventoryMaster_inventoryDetails = new System.Data.DataRelation("FK_inventoryMaster_inventoryDetails", new System.Data.DataColumn[] {
                 this.tableinventoryMaster.IDColumn}, new System.Data.DataColumn[] {
                 this.tableinventoryDetails.inventoryMasterRefColumn}, false);
     this.Relations.Add(this.relationFK_inventoryMaster_inventoryDetails);
     this.relationFK_ReceiptDetail_ReceiptMaster = new System.Data.DataRelation("FK_ReceiptDetail_ReceiptMaster", new System.Data.DataColumn[] {
                 this.tableReceiptMaster.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptDetail.ReceiptMasterRefColumn}, false);
     this.Relations.Add(this.relationFK_ReceiptDetail_ReceiptMaster);
     this.relationFK_ReceiptMaster_DocumentType = new System.Data.DataRelation("FK_ReceiptMaster_DocumentType", new System.Data.DataColumn[] {
                 this.tableDocumentType.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptMaster.DocumentTypeRefColumn}, false);
     this.Relations.Add(this.relationFK_ReceiptMaster_DocumentType);
     this.relationFK_InvoiceDetail_ReceiptRemains = new System.Data.DataRelation("FK_InvoiceDetail_ReceiptRemains", new System.Data.DataColumn[] {
                 this.tableReceiptRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] {
                 this.tableInvoiceDetail.LocalReceiptDetailRefColumn}, false);
     this.Relations.Add(this.relationFK_InvoiceDetail_ReceiptRemains);
     this.relationFK_ReceiptMaster_Stock = new System.Data.DataRelation("FK_ReceiptMaster_Stock", new System.Data.DataColumn[] {
                 this.tableStock.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptMaster.MainStockRefColumn}, false);
     this.Relations.Add(this.relationFK_ReceiptMaster_Stock);
     this.relationFK_ReceiptMaster_Stock1 = new System.Data.DataRelation("FK_ReceiptMaster_Stock1", new System.Data.DataColumn[] {
                 this.tableStock.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptMaster.SenderStockRefColumn}, false);
     this.Relations.Add(this.relationFK_ReceiptMaster_Stock1);
     this.relationReceiptDetail_Remains = new System.Data.DataRelation("ReceiptDetail_Remains", new System.Data.DataColumn[] {
                 this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptDetail.IDColumn}, false);
     this.Relations.Add(this.relationReceiptDetail_Remains);
     this.relationProduct_ReceiptDetail = new System.Data.DataRelation("Product_ReceiptDetail", new System.Data.DataColumn[] {
                 this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptDetail.ProductRefColumn}, false);
     this.Relations.Add(this.relationProduct_ReceiptDetail);
     this.relationInvoiceDetail_Product = new System.Data.DataRelation("InvoiceDetail_Product", new System.Data.DataColumn[] {
                 this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
                 this.tableInvoiceDetail.ProductRefColumn}, false);
     this.Relations.Add(this.relationInvoiceDetail_Product);
     this.relationProduct_Orders = new System.Data.DataRelation("Product_Orders", new System.Data.DataColumn[] {
                 this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.ProductRefColumn}, false);
     this.Relations.Add(this.relationProduct_Orders);
     this.relationProduct_Remains = new System.Data.DataRelation("Product_Remains", new System.Data.DataColumn[] {
                 this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
                 this.tableRemains.ProductRefColumn}, false);
     this.Relations.Add(this.relationProduct_Remains);
 }
 private void InitClass() {
     this.DataSetName = "FbcFoodBankDataSet";
     this.Prefix = "";
     this.Namespace = "http://tempuri.org/FbcFoodBankDataSet.xsd";
     this.EnforceConstraints = true;
     this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     this.tableContacts = new ContactsDataTable();
     base.Tables.Add(this.tableContacts);
     this.tableVisits = new VisitsDataTable();
     base.Tables.Add(this.tableVisits);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("Reference", new System.Data.DataColumn[] {
                 this.tableContacts.NameColumn}, new System.Data.DataColumn[] {
                 this.tableVisits.NameColumn});
     this.tableVisits.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.Cascade;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.relationReference = new System.Data.DataRelation("Reference", new System.Data.DataColumn[] {
                 this.tableContacts.NameColumn}, new System.Data.DataColumn[] {
                 this.tableVisits.NameColumn}, false);
     this.Relations.Add(this.relationReference);
 }
 private void InitClass() {
     this.DataSetName = "NorthwindDataSet";
     this.Prefix = "";
     this.Namespace = "http://tempuri.org/NorthwindDataSet.xsd";
     this.Locale = new System.Globalization.CultureInfo("en");
     this.CaseSensitive = false;
     this.EnforceConstraints = true;
     this.tableProducts = new ProductsDataTable();
     base.Tables.Add(this.tableProducts);
     this.tableOrders = new OrdersDataTable();
     base.Tables.Add(this.tableOrders);
     this.tableSuppliers = new SuppliersDataTable();
     base.Tables.Add(this.tableSuppliers);
     this.tableShippers = new ShippersDataTable();
     base.Tables.Add(this.tableShippers);
     this.tableCustomers = new CustomersDataTable();
     base.Tables.Add(this.tableCustomers);
     this.tableCategories = new CategoriesDataTable();
     base.Tables.Add(this.tableCategories);
     this.tableOrder_Details = new Order_DetailsDataTable();
     base.Tables.Add(this.tableOrder_Details);
     this.tableEmployees = new EmployeesDataTable();
     base.Tables.Add(this.tableEmployees);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("SuppliersProducts", new System.Data.DataColumn[] {
                 this.tableSuppliers.SupplierIDColumn}, new System.Data.DataColumn[] {
                 this.tableProducts.SupplierIDColumn});
     this.tableProducts.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("CategoriesProducts", new System.Data.DataColumn[] {
                 this.tableCategories.CategoryIDColumn}, new System.Data.DataColumn[] {
                 this.tableProducts.CategoryIDColumn});
     this.tableProducts.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("ShippersOrders", new System.Data.DataColumn[] {
                 this.tableShippers.ShipperIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.ShipViaColumn});
     this.tableOrders.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("CustomersOrders", new System.Data.DataColumn[] {
                 this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.CustomerIDColumn});
     this.tableOrders.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("EmployeesOrders", new System.Data.DataColumn[] {
                 this.tableEmployees.EmployeeIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.EmployeeIDColumn});
     this.tableOrders.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("ProductsOrder Details", new System.Data.DataColumn[] {
                 this.tableProducts.ProductIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrder_Details.ProductIDColumn});
     this.tableOrder_Details.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("OrdersOrder Details", new System.Data.DataColumn[] {
                 this.tableOrders.OrderIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrder_Details.OrderIDColumn});
     this.tableOrder_Details.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.relationSuppliersProducts = new System.Data.DataRelation("SuppliersProducts", new System.Data.DataColumn[] {
                 this.tableSuppliers.SupplierIDColumn}, new System.Data.DataColumn[] {
                 this.tableProducts.SupplierIDColumn}, false);
     this.Relations.Add(this.relationSuppliersProducts);
     this.relationCategoriesProducts = new System.Data.DataRelation("CategoriesProducts", new System.Data.DataColumn[] {
                 this.tableCategories.CategoryIDColumn}, new System.Data.DataColumn[] {
                 this.tableProducts.CategoryIDColumn}, false);
     this.Relations.Add(this.relationCategoriesProducts);
     this.relationShippersOrders = new System.Data.DataRelation("ShippersOrders", new System.Data.DataColumn[] {
                 this.tableShippers.ShipperIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.ShipViaColumn}, false);
     this.Relations.Add(this.relationShippersOrders);
     this.relationCustomersOrders = new System.Data.DataRelation("CustomersOrders", new System.Data.DataColumn[] {
                 this.tableCustomers.CustomerIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.CustomerIDColumn}, false);
     this.Relations.Add(this.relationCustomersOrders);
     this.relationEmployeesOrders = new System.Data.DataRelation("EmployeesOrders", new System.Data.DataColumn[] {
                 this.tableEmployees.EmployeeIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.EmployeeIDColumn}, false);
     this.Relations.Add(this.relationEmployeesOrders);
     this.relationProductsOrder_Details = new System.Data.DataRelation("ProductsOrder Details", new System.Data.DataColumn[] {
                 this.tableProducts.ProductIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrder_Details.ProductIDColumn}, false);
     this.Relations.Add(this.relationProductsOrder_Details);
     this.relationOrdersOrder_Details = new System.Data.DataRelation("OrdersOrder Details", new System.Data.DataColumn[] {
                 this.tableOrders.OrderIDColumn}, new System.Data.DataColumn[] {
                 this.tableOrder_Details.OrderIDColumn}, false);
     this.Relations.Add(this.relationOrdersOrder_Details);
     this.ExtendedProperties.Add("DSGenerator_DataSetName", "NorthwindDataSet");
     this.ExtendedProperties.Add("User_DataSetName", "NorthwindDataSet");
 }
 private void InitClass() {
     this.DataSetName = "Facts";
     this.Prefix = "";
     this.Namespace = "urn:www.genetibase.com:Facts";
     this.EnforceConstraints = true;
     this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     this.tableFact = new FactDataTable();
     base.Tables.Add(this.tableFact);
     this.tableWhat = new WhatDataTable();
     base.Tables.Add(this.tableWhat);
     this.tableWhere = new WhereDataTable();
     base.Tables.Add(this.tableWhere);
     this.tableWhen = new WhenDataTable();
     base.Tables.Add(this.tableWhen);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("FK_What_Fact", new System.Data.DataColumn[] {
                 this.tableWhat.IDColumn}, new System.Data.DataColumn[] {
                 this.tableFact.WhatColumn});
     this.tableFact.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("FK_Where_Fact", new System.Data.DataColumn[] {
                 this.tableWhere.IDColumn}, new System.Data.DataColumn[] {
                 this.tableFact.WhereColumn});
     this.tableFact.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("FK_When_Fact", new System.Data.DataColumn[] {
                 this.tableWhen.IDColumn}, new System.Data.DataColumn[] {
                 this.tableFact.WhenColumn});
     this.tableFact.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.relationFK_What_Fact = new System.Data.DataRelation("FK_What_Fact", new System.Data.DataColumn[] {
                 this.tableWhat.IDColumn}, new System.Data.DataColumn[] {
                 this.tableFact.WhatColumn}, false);
     this.Relations.Add(this.relationFK_What_Fact);
     this.relationFK_Where_Fact = new System.Data.DataRelation("FK_Where_Fact", new System.Data.DataColumn[] {
                 this.tableWhere.IDColumn}, new System.Data.DataColumn[] {
                 this.tableFact.WhereColumn}, false);
     this.Relations.Add(this.relationFK_Where_Fact);
     this.relationFK_When_Fact = new System.Data.DataRelation("FK_When_Fact", new System.Data.DataColumn[] {
                 this.tableWhen.IDColumn}, new System.Data.DataColumn[] {
                 this.tableFact.WhenColumn}, false);
     this.Relations.Add(this.relationFK_When_Fact);
 }
Beispiel #12
0
 private void InitClass() {
     this.DataSetName = "MDataSet";
     this.Prefix = "";
     this.Namespace = "http://tempuri.org/MDataSet.xsd";
     this.EnforceConstraints = true;
     this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     this.tableCountry = new CountryDataTable();
     base.Tables.Add(this.tableCountry);
     this.tableDocumentType = new DocumentTypeDataTable();
     base.Tables.Add(this.tableDocumentType);
     this.tableInvoiceDetail = new InvoiceDetailDataTable(false);
     base.Tables.Add(this.tableInvoiceDetail);
     this.tableInvoiceMaster = new InvoiceMasterDataTable(false);
     base.Tables.Add(this.tableInvoiceMaster);
     this.tableOrganization = new OrganizationDataTable(false);
     base.Tables.Add(this.tableOrganization);
     this.tableReceiptRemains = new ReceiptRemainsDataTable();
     base.Tables.Add(this.tableReceiptRemains);
     this.tableStock = new StockDataTable(false);
     base.Tables.Add(this.tableStock);
     this.tableTradePutlet = new TradePutletDataTable();
     base.Tables.Add(this.tableTradePutlet);
     this.tableReceiptMaster = new ReceiptMasterDataTable(false);
     base.Tables.Add(this.tableReceiptMaster);
     this.tableReceiptDetail = new ReceiptDetailDataTable(false);
     base.Tables.Add(this.tableReceiptDetail);
     this.tableStorageCondition = new StorageConditionDataTable(false);
     base.Tables.Add(this.tableStorageCondition);
     this.tableProduct = new ProductDataTable(false);
     base.Tables.Add(this.tableProduct);
     this.tableFarmGroup = new FarmGroupDataTable();
     base.Tables.Add(this.tableFarmGroup);
     this.tablePacking = new PackingDataTable();
     base.Tables.Add(this.tablePacking);
     this.tableSubstance = new SubstanceDataTable();
     base.Tables.Add(this.tableSubstance);
     this.tableUnit = new UnitDataTable();
     base.Tables.Add(this.tableUnit);
     this.tableManufacturer = new ManufacturerDataTable(false);
     base.Tables.Add(this.tableManufacturer);
     this.tableFarmGroupLevel2 = new FarmGroupLevel2DataTable(false);
     base.Tables.Add(this.tableFarmGroupLevel2);
     this.tableOrders = new OrdersDataTable();
     base.Tables.Add(this.tableOrders);
     this.tableRemains = new RemainsDataTable(false);
     base.Tables.Add(this.tableRemains);
     this.tablePricesPurchase = new PricesPurchaseDataTable(false);
     base.Tables.Add(this.tablePricesPurchase);
     this.tablePeriods = new PeriodsDataTable(false);
     base.Tables.Add(this.tablePeriods);
     this.tableLinkedInvoiceDetail = new LinkedInvoiceDetailDataTable();
     base.Tables.Add(this.tableLinkedInvoiceDetail);
     this.tableLinkedInvoiceMaster = new LinkedInvoiceMasterDataTable();
     base.Tables.Add(this.tableLinkedInvoiceMaster);
     this.tableReceiptDetailAdding = new ReceiptDetailAddingDataTable();
     base.Tables.Add(this.tableReceiptDetailAdding);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("FK_InvoiceMaster_StockMain", new System.Data.DataColumn[] {
                 this.tableStock.IDColumn}, new System.Data.DataColumn[] {
                 this.tableInvoiceMaster.MainStockRefColumn});
     this.tableInvoiceMaster.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.None;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("FK_Stock_InvoiceMaster", new System.Data.DataColumn[] {
                 this.tableStock.IDColumn}, new System.Data.DataColumn[] {
                 this.tableInvoiceMaster.RemoteStockRefColumn});
     this.tableInvoiceMaster.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.None;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("FK_ReceiptRemains_ReceiptDetail", new System.Data.DataColumn[] {
                 this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptRemains.ReceiptDetailRefColumn});
     this.tableReceiptRemains.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.None;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("ReceiptMaster_ReceiptDetail", new System.Data.DataColumn[] {
                 this.tableReceiptMaster.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptDetail.ReceiptMasterRefColumn});
     this.tableReceiptDetail.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.None;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("FK_Substance_Product", new System.Data.DataColumn[] {
                 this.tableSubstance.IDColumn}, new System.Data.DataColumn[] {
                 this.tableProduct.SubstanceRefColumn});
     this.tableProduct.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.None;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("FK_Unit_Product", new System.Data.DataColumn[] {
                 this.tableUnit.IDColumn}, new System.Data.DataColumn[] {
                 this.tableProduct.UnitRefColumn});
     this.tableProduct.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.None;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("FK_FarmGroupLevel2_Product", new System.Data.DataColumn[] {
                 this.tableFarmGroupLevel2.IDColumn}, new System.Data.DataColumn[] {
                 this.tableProduct.FarmGrouplevel2RefColumn});
     this.tableProduct.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.None;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("FK_FarmGroup_FarmGroupLevel2", new System.Data.DataColumn[] {
                 this.tableFarmGroup.IDColumn}, new System.Data.DataColumn[] {
                 this.tableFarmGroupLevel2.FarmGroupRefColumn});
     this.tableFarmGroupLevel2.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.None;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("FK_ReceiptDetailAdding_ReceiptDetail", new System.Data.DataColumn[] {
                 this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptDetailAdding.ReceiptDetailRefColumn});
     this.tableReceiptDetailAdding.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.relationFK_InvoiceMaster_StockMain = new System.Data.DataRelation("FK_InvoiceMaster_StockMain", new System.Data.DataColumn[] {
                 this.tableStock.IDColumn}, new System.Data.DataColumn[] {
                 this.tableInvoiceMaster.MainStockRefColumn}, false);
     this.Relations.Add(this.relationFK_InvoiceMaster_StockMain);
     this.relationFK_Stock_InvoiceMaster = new System.Data.DataRelation("FK_Stock_InvoiceMaster", new System.Data.DataColumn[] {
                 this.tableStock.IDColumn}, new System.Data.DataColumn[] {
                 this.tableInvoiceMaster.RemoteStockRefColumn}, false);
     this.Relations.Add(this.relationFK_Stock_InvoiceMaster);
     this.relationFK_ReceiptRemains_ReceiptDetail = new System.Data.DataRelation("FK_ReceiptRemains_ReceiptDetail", new System.Data.DataColumn[] {
                 this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptRemains.ReceiptDetailRefColumn}, false);
     this.Relations.Add(this.relationFK_ReceiptRemains_ReceiptDetail);
     this.relationReceiptMaster_ReceiptDetail = new System.Data.DataRelation("ReceiptMaster_ReceiptDetail", new System.Data.DataColumn[] {
                 this.tableReceiptMaster.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptDetail.ReceiptMasterRefColumn}, false);
     this.Relations.Add(this.relationReceiptMaster_ReceiptDetail);
     this.relationFK_Substance_Product = new System.Data.DataRelation("FK_Substance_Product", new System.Data.DataColumn[] {
                 this.tableSubstance.IDColumn}, new System.Data.DataColumn[] {
                 this.tableProduct.SubstanceRefColumn}, false);
     this.Relations.Add(this.relationFK_Substance_Product);
     this.relationFK_Unit_Product = new System.Data.DataRelation("FK_Unit_Product", new System.Data.DataColumn[] {
                 this.tableUnit.IDColumn}, new System.Data.DataColumn[] {
                 this.tableProduct.UnitRefColumn}, false);
     this.Relations.Add(this.relationFK_Unit_Product);
     this.relationFK_FarmGroupLevel2_Product = new System.Data.DataRelation("FK_FarmGroupLevel2_Product", new System.Data.DataColumn[] {
                 this.tableFarmGroupLevel2.IDColumn}, new System.Data.DataColumn[] {
                 this.tableProduct.FarmGrouplevel2RefColumn}, false);
     this.Relations.Add(this.relationFK_FarmGroupLevel2_Product);
     this.relationFK_FarmGroup_FarmGroupLevel2 = new System.Data.DataRelation("FK_FarmGroup_FarmGroupLevel2", new System.Data.DataColumn[] {
                 this.tableFarmGroup.IDColumn}, new System.Data.DataColumn[] {
                 this.tableFarmGroupLevel2.FarmGroupRefColumn}, false);
     this.Relations.Add(this.relationFK_FarmGroup_FarmGroupLevel2);
     this.relationFK_ReceiptDetailAdding_ReceiptDetail = new System.Data.DataRelation("FK_ReceiptDetailAdding_ReceiptDetail", new System.Data.DataColumn[] {
                 this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptDetailAdding.ReceiptDetailRefColumn}, false);
     this.Relations.Add(this.relationFK_ReceiptDetailAdding_ReceiptDetail);
     this.relationFK_InvoiceDetail_InvoiceMaster = new System.Data.DataRelation("FK_InvoiceDetail_InvoiceMaster", new System.Data.DataColumn[] {
                 this.tableInvoiceMaster.IDColumn}, new System.Data.DataColumn[] {
                 this.tableInvoiceDetail.InvoiceMasterRefColumn}, false);
     this.Relations.Add(this.relationFK_InvoiceDetail_InvoiceMaster);
     this.relationFK_InvoiceMaster_Organization = new System.Data.DataRelation("FK_InvoiceMaster_Organization", new System.Data.DataColumn[] {
                 this.tableOrganization.IDColumn}, new System.Data.DataColumn[] {
                 this.tableInvoiceMaster.OrganisationRefColumn}, false);
     this.Relations.Add(this.relationFK_InvoiceMaster_Organization);
     this.relationFK_ReceiptMaster_DocumentType = new System.Data.DataRelation("FK_ReceiptMaster_DocumentType", new System.Data.DataColumn[] {
                 this.tableDocumentType.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptMaster.DocumentTypeRefColumn}, false);
     this.Relations.Add(this.relationFK_ReceiptMaster_DocumentType);
     this.relationFK_ReceiptMaster_Organization = new System.Data.DataRelation("FK_ReceiptMaster_Organization", new System.Data.DataColumn[] {
                 this.tableOrganization.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptMaster.OrganizationRefColumn}, false);
     this.Relations.Add(this.relationFK_ReceiptMaster_Organization);
     this.relationFK_ReceiptMaster_Stock = new System.Data.DataRelation("FK_ReceiptMaster_Stock", new System.Data.DataColumn[] {
                 this.tableStock.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptMaster.MainStockRefColumn}, false);
     this.Relations.Add(this.relationFK_ReceiptMaster_Stock);
     this.relationStorageCondition_Product = new System.Data.DataRelation("StorageCondition_Product", new System.Data.DataColumn[] {
                 this.tableStorageCondition.IDColumn}, new System.Data.DataColumn[] {
                 this.tableProduct.StorageConditionRefColumn}, false);
     this.Relations.Add(this.relationStorageCondition_Product);
     this.relationFK_Packing_Product = new System.Data.DataRelation("FK_Packing_Product", new System.Data.DataColumn[] {
                 this.tablePacking.IDColumn}, new System.Data.DataColumn[] {
                 this.tableProduct.PackingRefColumn}, false);
     this.Relations.Add(this.relationFK_Packing_Product);
     this.relationReceiptDetail_Orders = new System.Data.DataRelation("ReceiptDetail_Orders", new System.Data.DataColumn[] {
                 this.tableReceiptDetail.ProductRefColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.ProductRefColumn}, false);
     this.Relations.Add(this.relationReceiptDetail_Orders);
     this.relationProduct_Remains = new System.Data.DataRelation("Product_Remains", new System.Data.DataColumn[] {
                 this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
                 this.tableRemains.ProductRefColumn}, false);
     this.Relations.Add(this.relationProduct_Remains);
     this.relationProduct_Orders = new System.Data.DataRelation("Product_Orders", new System.Data.DataColumn[] {
                 this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.ProductRefColumn}, false);
     this.Relations.Add(this.relationProduct_Orders);
     this.relationTradePutlet_Orders = new System.Data.DataRelation("TradePutlet_Orders", new System.Data.DataColumn[] {
                 this.tableTradePutlet.IDColumn}, new System.Data.DataColumn[] {
                 this.tableOrders.TradePupletRefColumn}, false);
     this.Relations.Add(this.relationTradePutlet_Orders);
     this.relationOrganization_PricesPurchase = new System.Data.DataRelation("Organization_PricesPurchase", new System.Data.DataColumn[] {
                 this.tableOrganization.IDColumn}, new System.Data.DataColumn[] {
                 this.tablePricesPurchase.OrganizationRefColumn}, false);
     this.Relations.Add(this.relationOrganization_PricesPurchase);
     this.relationProduct_PricesPurchase = new System.Data.DataRelation("Product_PricesPurchase", new System.Data.DataColumn[] {
                 this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
                 this.tablePricesPurchase.ProductRefColumn}, false);
     this.Relations.Add(this.relationProduct_PricesPurchase);
     this.relationReceiptDetail_PricesPurchase = new System.Data.DataRelation("ReceiptDetail_PricesPurchase", new System.Data.DataColumn[] {
                 this.tableReceiptDetail.ProductRefColumn}, new System.Data.DataColumn[] {
                 this.tablePricesPurchase.ProductRefColumn}, false);
     this.Relations.Add(this.relationReceiptDetail_PricesPurchase);
     this.relationReceiptDetail_InvoiceDetail = new System.Data.DataRelation("ReceiptDetail_InvoiceDetail", new System.Data.DataColumn[] {
                 this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] {
                 this.tableInvoiceDetail.LocalReceiptDetailRefColumn}, false);
     this.Relations.Add(this.relationReceiptDetail_InvoiceDetail);
     this.relationReceiptDetail_Remains = new System.Data.DataRelation("ReceiptDetail_Remains", new System.Data.DataColumn[] {
                 this.tableReceiptDetail.IDColumn}, new System.Data.DataColumn[] {
                 this.tableRemains.ReceiptDetailRefColumn}, false);
     this.Relations.Add(this.relationReceiptDetail_Remains);
     this.relationTradePutlet_Stock = new System.Data.DataRelation("TradePutlet_Stock", new System.Data.DataColumn[] {
                 this.tableTradePutlet.IDColumn}, new System.Data.DataColumn[] {
                 this.tableStock.TradePutletRefColumn}, false);
     this.Relations.Add(this.relationTradePutlet_Stock);
     this.relationProduct_ReceiptDetail = new System.Data.DataRelation("Product_ReceiptDetail", new System.Data.DataColumn[] {
                 this.tableProduct.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptDetail.ProductRefColumn}, false);
     this.Relations.Add(this.relationProduct_ReceiptDetail);
     this.relationFK_Manufacturer_ReceiptDetail = new System.Data.DataRelation("FK_Manufacturer_ReceiptDetail", new System.Data.DataColumn[] {
                 this.tableManufacturer.IDColumn}, new System.Data.DataColumn[] {
                 this.tableReceiptDetail.ManufacturerRefColumn}, false);
     this.Relations.Add(this.relationFK_Manufacturer_ReceiptDetail);
     this.relationLinkedInvoiceMaster_LinkedInvoiceDetail = new System.Data.DataRelation("LinkedInvoiceMaster_LinkedInvoiceDetail", new System.Data.DataColumn[] {
                 this.tableLinkedInvoiceMaster.TradePutletRefColumn,
                 this.tableLinkedInvoiceMaster.IDColumn}, new System.Data.DataColumn[] {
                 this.tableLinkedInvoiceDetail.TradePutletRefColumn,
                 this.tableLinkedInvoiceDetail.InvoiceMasterRefColumn}, false);
     this.Relations.Add(this.relationLinkedInvoiceMaster_LinkedInvoiceDetail);
     this.relationFK_Country_Manufacturer = new System.Data.DataRelation("FK_Country_Manufacturer", new System.Data.DataColumn[] {
                 this.tableCountry.IDColumn}, new System.Data.DataColumn[] {
                 this.tableManufacturer.CounrtyRefColumn}, false);
     this.Relations.Add(this.relationFK_Country_Manufacturer);
     this.relationRemains_InvoiceDetail = new System.Data.DataRelation("Remains_InvoiceDetail", new System.Data.DataColumn[] {
                 this.tableRemains.ReceiptDetailRefColumn}, new System.Data.DataColumn[] {
                 this.tableInvoiceDetail.LocalReceiptDetailRefColumn}, false);
     this.Relations.Add(this.relationRemains_InvoiceDetail);
 }
 private void InitClass() {
     this.DataSetName = "NosSiteMapDataSet";
     this.Prefix = "";
     this.Namespace = "http://tempuri.org/NosSiteMapDataSet.xsd";
     this.EnforceConstraints = true;
     this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     this.tableRaiz = new RaizDataTable();
     base.Tables.Add(this.tableRaiz);
     this.tableNo = new NoDataTable();
     base.Tables.Add(this.tableNo);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("Raiz_No", new System.Data.DataColumn[] {
                 this.tableRaiz.CodigoColumn}, new System.Data.DataColumn[] {
                 this.tableNo.CodigoRaizColumn});
     this.tableNo.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.None;
     fkc.UpdateRule = System.Data.Rule.None;
     this.relationRaiz_No = new System.Data.DataRelation("Raiz_No", new System.Data.DataColumn[] {
                 this.tableRaiz.CodigoColumn}, new System.Data.DataColumn[] {
                 this.tableNo.CodigoRaizColumn}, false);
     this.Relations.Add(this.relationRaiz_No);
 }
 private void InitClass() {
     this.DataSetName = "EstruturaSaveRAD";
     this.Prefix = "";
     this.Namespace = "http://tempuri.org/EstruturaSaveRAD.xsd";
     this.EnforceConstraints = true;
     this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     this.tableListaCampos = new ListaCamposDataTable();
     base.Tables.Add(this.tableListaCampos);
     this.tableMetodoConsulta = new MetodoConsultaDataTable();
     base.Tables.Add(this.tableMetodoConsulta);
     this.tableClasseCRUD = new ClasseCRUDDataTable();
     base.Tables.Add(this.tableClasseCRUD);
     this.tableMetodo = new MetodoDataTable();
     base.Tables.Add(this.tableMetodo);
     this.tableVersao = new VersaoDataTable();
     base.Tables.Add(this.tableVersao);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("FK_Metodo_ListaCampos", new System.Data.DataColumn[] {
                 this.tableMetodo.IDColumn}, new System.Data.DataColumn[] {
                 this.tableListaCampos.IDMetodoColumn});
     this.tableListaCampos.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.Cascade;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("ClasseCRUD_Metodo", new System.Data.DataColumn[] {
                 this.tableClasseCRUD.IDColumn}, new System.Data.DataColumn[] {
                 this.tableMetodo.IDClasseColumn});
     this.tableMetodo.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.Cascade;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.relationFK_Metodo_ListaCampos = new System.Data.DataRelation("FK_Metodo_ListaCampos", new System.Data.DataColumn[] {
                 this.tableMetodo.IDColumn}, new System.Data.DataColumn[] {
                 this.tableListaCampos.IDMetodoColumn}, false);
     this.Relations.Add(this.relationFK_Metodo_ListaCampos);
     this.relationClasseCRUD_Metodo = new System.Data.DataRelation("ClasseCRUD_Metodo", new System.Data.DataColumn[] {
                 this.tableClasseCRUD.IDColumn}, new System.Data.DataColumn[] {
                 this.tableMetodo.IDClasseColumn}, false);
     this.relationClasseCRUD_Metodo.Nested = true;
     this.Relations.Add(this.relationClasseCRUD_Metodo);
 }
 private void InitClass() {
     this.DataSetName = "NullableAndNonNullableRelationDataSet";
     this.Prefix = "";
     this.Namespace = "http://tempuri.org/NullableAndNonNullableRelationDataSet.xsd";
     this.Locale = new System.Globalization.CultureInfo("en-US");
     this.CaseSensitive = false;
     this.EnforceConstraints = true;
     this.tableA = new ADataTable();
     base.Tables.Add(this.tableA);
     this.tableB = new BDataTable();
     base.Tables.Add(this.tableB);
     this.tableC = new CDataTable();
     base.Tables.Add(this.tableC);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("FK_B_A", new System.Data.DataColumn[] {
                 this.tableB.BIDColumn}, new System.Data.DataColumn[] {
                 this.tableA.NullableBIDColumn});
     this.tableA.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("FK_B_C", new System.Data.DataColumn[] {
                 this.tableB.BIDColumn}, new System.Data.DataColumn[] {
                 this.tableC.NonNullableBIDColumn});
     this.tableC.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.relationFK_B_A = new System.Data.DataRelation("FK_B_A", new System.Data.DataColumn[] {
                 this.tableB.BIDColumn}, new System.Data.DataColumn[] {
                 this.tableA.NullableBIDColumn}, false);
     this.Relations.Add(this.relationFK_B_A);
     this.relationFK_B_C = new System.Data.DataRelation("FK_B_C", new System.Data.DataColumn[] {
                 this.tableB.BIDColumn}, new System.Data.DataColumn[] {
                 this.tableC.NonNullableBIDColumn}, false);
     this.Relations.Add(this.relationFK_B_C);
     this.ExtendedProperties.Add("DSGenerator_DataSetName", "NullableAndNonNullableRelationDataSet");
     this.ExtendedProperties.Add("User_DataSetName", "NullableAndNonNullableRelationDataSet");
 }
 private void InitClass() {
     this.DataSetName = "OysterUpdateData";
     this.Prefix = "";
     this.Namespace = "http://tempuri.org/OysterUpdateData.xsd";
     this.EnforceConstraints = true;
     this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     this.tableJobResults = new JobResultsDataTable();
     base.Tables.Add(this.tableJobResults);
     this.tableJob = new JobDataTable();
     base.Tables.Add(this.tableJob);
     this.tableFiles = new FilesDataTable();
     base.Tables.Add(this.tableFiles);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("Job_Files", new System.Data.DataColumn[] {
                 this.tableJob.Job_IdColumn}, new System.Data.DataColumn[] {
                 this.tableFiles.Job_IdColumn});
     this.tableFiles.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.relationJob_Files = new System.Data.DataRelation("Job_Files", new System.Data.DataColumn[] {
                 this.tableJob.Job_IdColumn}, new System.Data.DataColumn[] {
                 this.tableFiles.Job_IdColumn}, false);
     this.relationJob_Files.Nested = true;
     this.Relations.Add(this.relationJob_Files);
 }
 private void InitClass() {
     this.DataSetName = "ParentChildDataSet";
     this.Prefix = "";
     this.Namespace = "http://tempuri.org/ParentChildDataSet.xsd";
     this.Locale = new System.Globalization.CultureInfo("en-US");
     this.CaseSensitive = false;
     this.EnforceConstraints = true;
     this.tableTreeNodes = new TreeNodesDataTable();
     base.Tables.Add(this.tableTreeNodes);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("FK_TreeNodes_ParentTreeNodes", new System.Data.DataColumn[] {
                 this.tableTreeNodes.TreeNodeIDColumn}, new System.Data.DataColumn[] {
                 this.tableTreeNodes.ParentTreeNodeIDColumn});
     this.tableTreeNodes.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.None;
     fkc.UpdateRule = System.Data.Rule.None;
     this.relationFK_TreeNodes_ParentTreeNodes = new System.Data.DataRelation("FK_TreeNodes_ParentTreeNodes", new System.Data.DataColumn[] {
                 this.tableTreeNodes.TreeNodeIDColumn}, new System.Data.DataColumn[] {
                 this.tableTreeNodes.ParentTreeNodeIDColumn}, false);
     this.relationFK_TreeNodes_ParentTreeNodes.Nested = true;
     this.Relations.Add(this.relationFK_TreeNodes_ParentTreeNodes);
     this.ExtendedProperties.Add("DSGenerator_DataSetName", "ParentChildDataSet");
     this.ExtendedProperties.Add("User_DataSetName", "ParentChildDataSet");
 }
 private void InitClass() {
     this.DataSetName = "NewDataSet";
     this.Prefix = "";
     this.Locale = new System.Globalization.CultureInfo("");
     this.EnforceConstraints = true;
     this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     this.tablePACK_ID = new PACK_IDDataTable();
     base.Tables.Add(this.tablePACK_ID);
     this.tableEXPORT_NOTES_HEAD = new EXPORT_NOTES_HEADDataTable();
     base.Tables.Add(this.tableEXPORT_NOTES_HEAD);
     this.tableSHIPPING_INSTR_HEAD = new SHIPPING_INSTR_HEADDataTable();
     base.Tables.Add(this.tableSHIPPING_INSTR_HEAD);
     this.tablePICKING_INSTR_HEAD = new PICKING_INSTR_HEADDataTable();
     base.Tables.Add(this.tablePICKING_INSTR_HEAD);
     this.tableDELIVERY_INSTR_HEAD = new DELIVERY_INSTR_HEADDataTable();
     base.Tables.Add(this.tableDELIVERY_INSTR_HEAD);
     this.tableSPECIAL_INSTR_HEAD = new SPECIAL_INSTR_HEADDataTable();
     base.Tables.Add(this.tableSPECIAL_INSTR_HEAD);
     this.tableCUSTOMER_INSTR_HEAD = new CUSTOMER_INSTR_HEADDataTable();
     base.Tables.Add(this.tableCUSTOMER_INSTR_HEAD);
     this.tableLABEL_INSTR_HEAD = new LABEL_INSTR_HEADDataTable();
     base.Tables.Add(this.tableLABEL_INSTR_HEAD);
     this.tableCARRIER_INST_HEAD = new CARRIER_INST_HEADDataTable();
     base.Tables.Add(this.tableCARRIER_INST_HEAD);
     this.tableINVOICE_UDF_HEAD = new INVOICE_UDF_HEADDataTable();
     base.Tables.Add(this.tableINVOICE_UDF_HEAD);
     this.tableUDF_HEAD = new UDF_HEADDataTable();
     base.Tables.Add(this.tableUDF_HEAD);
     this.tableUDF_HEADER = new UDF_HEADERDataTable();
     base.Tables.Add(this.tableUDF_HEADER);
     this.tableHANDLING_INSTR_HEAD = new HANDLING_INSTR_HEADDataTable();
     base.Tables.Add(this.tableHANDLING_INSTR_HEAD);
     this.tablePACK_ID_LINE_ITEM = new PACK_ID_LINE_ITEMDataTable();
     base.Tables.Add(this.tablePACK_ID_LINE_ITEM);
     this.tableEXPORT_NOTES_DETAIL = new EXPORT_NOTES_DETAILDataTable();
     base.Tables.Add(this.tableEXPORT_NOTES_DETAIL);
     this.tableSHIPPING_INSTR_DETAIL = new SHIPPING_INSTR_DETAILDataTable();
     base.Tables.Add(this.tableSHIPPING_INSTR_DETAIL);
     this.tablePICKING_INSTR_DETAIL = new PICKING_INSTR_DETAILDataTable();
     base.Tables.Add(this.tablePICKING_INSTR_DETAIL);
     this.tableDELIVERY_INSTR_DETAIL = new DELIVERY_INSTR_DETAILDataTable();
     base.Tables.Add(this.tableDELIVERY_INSTR_DETAIL);
     this.tableSPECIAL_INSTR_DETAIL = new SPECIAL_INSTR_DETAILDataTable();
     base.Tables.Add(this.tableSPECIAL_INSTR_DETAIL);
     this.tableCUSTOMER_INSTR_DETAIL = new CUSTOMER_INSTR_DETAILDataTable();
     base.Tables.Add(this.tableCUSTOMER_INSTR_DETAIL);
     this.tableHANDLING_INSTR_DETAIL = new HANDLING_INSTR_DETAILDataTable();
     base.Tables.Add(this.tableHANDLING_INSTR_DETAIL);
     this.tableUID_INSTR_DETAIL = new UID_INSTR_DETAILDataTable();
     base.Tables.Add(this.tableUID_INSTR_DETAIL);
     this.tableCONFIG_INSTR_DETAIL = new CONFIG_INSTR_DETAILDataTable();
     base.Tables.Add(this.tableCONFIG_INSTR_DETAIL);
     this.tableMAXKIT_DETAIL = new MAXKIT_DETAILDataTable();
     base.Tables.Add(this.tableMAXKIT_DETAIL);
     this.tableUDF_DET = new UDF_DETDataTable();
     base.Tables.Add(this.tableUDF_DET);
     this.tableUDF_DETAIL = new UDF_DETAILDataTable();
     base.Tables.Add(this.tableUDF_DETAIL);
     this.tableHP_PN_COMPONENTS = new HP_PN_COMPONENTSDataTable();
     base.Tables.Add(this.tableHP_PN_COMPONENTS);
     this.tableBOX = new BOXDataTable();
     base.Tables.Add(this.tableBOX);
     this.tableSERIAL_NUM = new SERIAL_NUMDataTable();
     base.Tables.Add(this.tableSERIAL_NUM);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_EXPORT_NOTES_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableEXPORT_NOTES_HEAD.PACK_ID_IdColumn});
     this.tableEXPORT_NOTES_HEAD.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_SHIPPING_INSTR_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableSHIPPING_INSTR_HEAD.PACK_ID_IdColumn});
     this.tableSHIPPING_INSTR_HEAD.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_PICKING_INSTR_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tablePICKING_INSTR_HEAD.PACK_ID_IdColumn});
     this.tablePICKING_INSTR_HEAD.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_DELIVERY_INSTR_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableDELIVERY_INSTR_HEAD.PACK_ID_IdColumn});
     this.tableDELIVERY_INSTR_HEAD.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_SPECIAL_INSTR_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableSPECIAL_INSTR_HEAD.PACK_ID_IdColumn});
     this.tableSPECIAL_INSTR_HEAD.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_CUSTOMER_INSTR_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableCUSTOMER_INSTR_HEAD.PACK_ID_IdColumn});
     this.tableCUSTOMER_INSTR_HEAD.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LABEL_INSTR_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableLABEL_INSTR_HEAD.PACK_ID_IdColumn});
     this.tableLABEL_INSTR_HEAD.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_CARRIER_INST_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableCARRIER_INST_HEAD.PACK_ID_IdColumn});
     this.tableCARRIER_INST_HEAD.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_INVOICE_UDF_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableINVOICE_UDF_HEAD.PACK_ID_IdColumn});
     this.tableINVOICE_UDF_HEAD.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_UDF_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableUDF_HEAD.PACK_ID_IdColumn});
     this.tableUDF_HEAD.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_UDF_HEADER", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableUDF_HEADER.PACK_ID_IdColumn});
     this.tableUDF_HEADER.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_HANDLING_INSTR_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableHANDLING_INSTR_HEAD.PACK_ID_IdColumn});
     this.tableHANDLING_INSTR_HEAD.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_PACK_ID_LINE_ITEM", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_IdColumn});
     this.tablePACK_ID_LINE_ITEM.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LINE_ITEM_EXPORT_NOTES_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableEXPORT_NOTES_DETAIL.PACK_ID_LINE_ITEM_IdColumn});
     this.tableEXPORT_NOTES_DETAIL.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LINE_ITEM_SHIPPING_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableSHIPPING_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn});
     this.tableSHIPPING_INSTR_DETAIL.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LINE_ITEM_PICKING_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tablePICKING_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn});
     this.tablePICKING_INSTR_DETAIL.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LINE_ITEM_DELIVERY_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableDELIVERY_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn});
     this.tableDELIVERY_INSTR_DETAIL.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LINE_ITEM_SPECIAL_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableSPECIAL_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn});
     this.tableSPECIAL_INSTR_DETAIL.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LINE_ITEM_CUSTOMER_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableCUSTOMER_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn});
     this.tableCUSTOMER_INSTR_DETAIL.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LINE_ITEM_HANDLING_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableHANDLING_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn});
     this.tableHANDLING_INSTR_DETAIL.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LINE_ITEM_UID_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableUID_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn});
     this.tableUID_INSTR_DETAIL.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LINE_ITEM_CONFIG_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableCONFIG_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn});
     this.tableCONFIG_INSTR_DETAIL.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LINE_ITEM_MAXKIT_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableMAXKIT_DETAIL.PACK_ID_LINE_ITEM_IdColumn});
     this.tableMAXKIT_DETAIL.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LINE_ITEM_UDF_DET", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableUDF_DET.PACK_ID_LINE_ITEM_IdColumn});
     this.tableUDF_DET.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LINE_ITEM_UDF_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableUDF_DETAIL.PACK_ID_LINE_ITEM_IdColumn});
     this.tableUDF_DETAIL.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LINE_ITEM_HP_PN_COMPONENTS", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableHP_PN_COMPONENTS.PACK_ID_LINE_ITEM_IdColumn});
     this.tableHP_PN_COMPONENTS.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("PACK_ID_LINE_ITEM_BOX", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableBOX.PACK_ID_LINE_ITEM_IdColumn});
     this.tableBOX.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("BOX_SERIAL_NUM", new System.Data.DataColumn[] {
                 this.tableBOX.BOX_Id_0Column}, new System.Data.DataColumn[] {
                 this.tableSERIAL_NUM.BOX_Id_0Column});
     this.tableSERIAL_NUM.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.relationPACK_ID_EXPORT_NOTES_HEAD = new System.Data.DataRelation("PACK_ID_EXPORT_NOTES_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableEXPORT_NOTES_HEAD.PACK_ID_IdColumn}, false);
     this.relationPACK_ID_EXPORT_NOTES_HEAD.Nested = true;
     this.Relations.Add(this.relationPACK_ID_EXPORT_NOTES_HEAD);
     this.relationPACK_ID_SHIPPING_INSTR_HEAD = new System.Data.DataRelation("PACK_ID_SHIPPING_INSTR_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableSHIPPING_INSTR_HEAD.PACK_ID_IdColumn}, false);
     this.relationPACK_ID_SHIPPING_INSTR_HEAD.Nested = true;
     this.Relations.Add(this.relationPACK_ID_SHIPPING_INSTR_HEAD);
     this.relationPACK_ID_PICKING_INSTR_HEAD = new System.Data.DataRelation("PACK_ID_PICKING_INSTR_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tablePICKING_INSTR_HEAD.PACK_ID_IdColumn}, false);
     this.relationPACK_ID_PICKING_INSTR_HEAD.Nested = true;
     this.Relations.Add(this.relationPACK_ID_PICKING_INSTR_HEAD);
     this.relationPACK_ID_DELIVERY_INSTR_HEAD = new System.Data.DataRelation("PACK_ID_DELIVERY_INSTR_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableDELIVERY_INSTR_HEAD.PACK_ID_IdColumn}, false);
     this.relationPACK_ID_DELIVERY_INSTR_HEAD.Nested = true;
     this.Relations.Add(this.relationPACK_ID_DELIVERY_INSTR_HEAD);
     this.relationPACK_ID_SPECIAL_INSTR_HEAD = new System.Data.DataRelation("PACK_ID_SPECIAL_INSTR_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableSPECIAL_INSTR_HEAD.PACK_ID_IdColumn}, false);
     this.relationPACK_ID_SPECIAL_INSTR_HEAD.Nested = true;
     this.Relations.Add(this.relationPACK_ID_SPECIAL_INSTR_HEAD);
     this.relationPACK_ID_CUSTOMER_INSTR_HEAD = new System.Data.DataRelation("PACK_ID_CUSTOMER_INSTR_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableCUSTOMER_INSTR_HEAD.PACK_ID_IdColumn}, false);
     this.relationPACK_ID_CUSTOMER_INSTR_HEAD.Nested = true;
     this.Relations.Add(this.relationPACK_ID_CUSTOMER_INSTR_HEAD);
     this.relationPACK_ID_LABEL_INSTR_HEAD = new System.Data.DataRelation("PACK_ID_LABEL_INSTR_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableLABEL_INSTR_HEAD.PACK_ID_IdColumn}, false);
     this.relationPACK_ID_LABEL_INSTR_HEAD.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LABEL_INSTR_HEAD);
     this.relationPACK_ID_CARRIER_INST_HEAD = new System.Data.DataRelation("PACK_ID_CARRIER_INST_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableCARRIER_INST_HEAD.PACK_ID_IdColumn}, false);
     this.relationPACK_ID_CARRIER_INST_HEAD.Nested = true;
     this.Relations.Add(this.relationPACK_ID_CARRIER_INST_HEAD);
     this.relationPACK_ID_INVOICE_UDF_HEAD = new System.Data.DataRelation("PACK_ID_INVOICE_UDF_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableINVOICE_UDF_HEAD.PACK_ID_IdColumn}, false);
     this.relationPACK_ID_INVOICE_UDF_HEAD.Nested = true;
     this.Relations.Add(this.relationPACK_ID_INVOICE_UDF_HEAD);
     this.relationPACK_ID_UDF_HEAD = new System.Data.DataRelation("PACK_ID_UDF_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableUDF_HEAD.PACK_ID_IdColumn}, false);
     this.relationPACK_ID_UDF_HEAD.Nested = true;
     this.Relations.Add(this.relationPACK_ID_UDF_HEAD);
     this.relationPACK_ID_UDF_HEADER = new System.Data.DataRelation("PACK_ID_UDF_HEADER", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableUDF_HEADER.PACK_ID_IdColumn}, false);
     this.relationPACK_ID_UDF_HEADER.Nested = true;
     this.Relations.Add(this.relationPACK_ID_UDF_HEADER);
     this.relationPACK_ID_HANDLING_INSTR_HEAD = new System.Data.DataRelation("PACK_ID_HANDLING_INSTR_HEAD", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tableHANDLING_INSTR_HEAD.PACK_ID_IdColumn}, false);
     this.relationPACK_ID_HANDLING_INSTR_HEAD.Nested = true;
     this.Relations.Add(this.relationPACK_ID_HANDLING_INSTR_HEAD);
     this.relationPACK_ID_PACK_ID_LINE_ITEM = new System.Data.DataRelation("PACK_ID_PACK_ID_LINE_ITEM", new System.Data.DataColumn[] {
                 this.tablePACK_ID.PACK_ID_IdColumn}, new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_IdColumn}, false);
     this.relationPACK_ID_PACK_ID_LINE_ITEM.Nested = true;
     this.Relations.Add(this.relationPACK_ID_PACK_ID_LINE_ITEM);
     this.relationPACK_ID_LINE_ITEM_EXPORT_NOTES_DETAIL = new System.Data.DataRelation("PACK_ID_LINE_ITEM_EXPORT_NOTES_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableEXPORT_NOTES_DETAIL.PACK_ID_LINE_ITEM_IdColumn}, false);
     this.relationPACK_ID_LINE_ITEM_EXPORT_NOTES_DETAIL.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LINE_ITEM_EXPORT_NOTES_DETAIL);
     this.relationPACK_ID_LINE_ITEM_SHIPPING_INSTR_DETAIL = new System.Data.DataRelation("PACK_ID_LINE_ITEM_SHIPPING_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableSHIPPING_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn}, false);
     this.relationPACK_ID_LINE_ITEM_SHIPPING_INSTR_DETAIL.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LINE_ITEM_SHIPPING_INSTR_DETAIL);
     this.relationPACK_ID_LINE_ITEM_PICKING_INSTR_DETAIL = new System.Data.DataRelation("PACK_ID_LINE_ITEM_PICKING_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tablePICKING_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn}, false);
     this.relationPACK_ID_LINE_ITEM_PICKING_INSTR_DETAIL.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LINE_ITEM_PICKING_INSTR_DETAIL);
     this.relationPACK_ID_LINE_ITEM_DELIVERY_INSTR_DETAIL = new System.Data.DataRelation("PACK_ID_LINE_ITEM_DELIVERY_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableDELIVERY_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn}, false);
     this.relationPACK_ID_LINE_ITEM_DELIVERY_INSTR_DETAIL.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LINE_ITEM_DELIVERY_INSTR_DETAIL);
     this.relationPACK_ID_LINE_ITEM_SPECIAL_INSTR_DETAIL = new System.Data.DataRelation("PACK_ID_LINE_ITEM_SPECIAL_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableSPECIAL_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn}, false);
     this.relationPACK_ID_LINE_ITEM_SPECIAL_INSTR_DETAIL.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LINE_ITEM_SPECIAL_INSTR_DETAIL);
     this.relationPACK_ID_LINE_ITEM_CUSTOMER_INSTR_DETAIL = new System.Data.DataRelation("PACK_ID_LINE_ITEM_CUSTOMER_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableCUSTOMER_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn}, false);
     this.relationPACK_ID_LINE_ITEM_CUSTOMER_INSTR_DETAIL.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LINE_ITEM_CUSTOMER_INSTR_DETAIL);
     this.relationPACK_ID_LINE_ITEM_HANDLING_INSTR_DETAIL = new System.Data.DataRelation("PACK_ID_LINE_ITEM_HANDLING_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableHANDLING_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn}, false);
     this.relationPACK_ID_LINE_ITEM_HANDLING_INSTR_DETAIL.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LINE_ITEM_HANDLING_INSTR_DETAIL);
     this.relationPACK_ID_LINE_ITEM_UID_INSTR_DETAIL = new System.Data.DataRelation("PACK_ID_LINE_ITEM_UID_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableUID_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn}, false);
     this.relationPACK_ID_LINE_ITEM_UID_INSTR_DETAIL.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LINE_ITEM_UID_INSTR_DETAIL);
     this.relationPACK_ID_LINE_ITEM_CONFIG_INSTR_DETAIL = new System.Data.DataRelation("PACK_ID_LINE_ITEM_CONFIG_INSTR_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableCONFIG_INSTR_DETAIL.PACK_ID_LINE_ITEM_IdColumn}, false);
     this.relationPACK_ID_LINE_ITEM_CONFIG_INSTR_DETAIL.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LINE_ITEM_CONFIG_INSTR_DETAIL);
     this.relationPACK_ID_LINE_ITEM_MAXKIT_DETAIL = new System.Data.DataRelation("PACK_ID_LINE_ITEM_MAXKIT_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableMAXKIT_DETAIL.PACK_ID_LINE_ITEM_IdColumn}, false);
     this.relationPACK_ID_LINE_ITEM_MAXKIT_DETAIL.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LINE_ITEM_MAXKIT_DETAIL);
     this.relationPACK_ID_LINE_ITEM_UDF_DET = new System.Data.DataRelation("PACK_ID_LINE_ITEM_UDF_DET", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableUDF_DET.PACK_ID_LINE_ITEM_IdColumn}, false);
     this.relationPACK_ID_LINE_ITEM_UDF_DET.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LINE_ITEM_UDF_DET);
     this.relationPACK_ID_LINE_ITEM_UDF_DETAIL = new System.Data.DataRelation("PACK_ID_LINE_ITEM_UDF_DETAIL", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableUDF_DETAIL.PACK_ID_LINE_ITEM_IdColumn}, false);
     this.relationPACK_ID_LINE_ITEM_UDF_DETAIL.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LINE_ITEM_UDF_DETAIL);
     this.relationPACK_ID_LINE_ITEM_HP_PN_COMPONENTS = new System.Data.DataRelation("PACK_ID_LINE_ITEM_HP_PN_COMPONENTS", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableHP_PN_COMPONENTS.PACK_ID_LINE_ITEM_IdColumn}, false);
     this.relationPACK_ID_LINE_ITEM_HP_PN_COMPONENTS.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LINE_ITEM_HP_PN_COMPONENTS);
     this.relationPACK_ID_LINE_ITEM_BOX = new System.Data.DataRelation("PACK_ID_LINE_ITEM_BOX", new System.Data.DataColumn[] {
                 this.tablePACK_ID_LINE_ITEM.PACK_ID_LINE_ITEM_IdColumn}, new System.Data.DataColumn[] {
                 this.tableBOX.PACK_ID_LINE_ITEM_IdColumn}, false);
     this.relationPACK_ID_LINE_ITEM_BOX.Nested = true;
     this.Relations.Add(this.relationPACK_ID_LINE_ITEM_BOX);
     this.relationBOX_SERIAL_NUM = new System.Data.DataRelation("BOX_SERIAL_NUM", new System.Data.DataColumn[] {
                 this.tableBOX.BOX_Id_0Column}, new System.Data.DataColumn[] {
                 this.tableSERIAL_NUM.BOX_Id_0Column}, false);
     this.relationBOX_SERIAL_NUM.Nested = true;
     this.Relations.Add(this.relationBOX_SERIAL_NUM);
 }
Beispiel #19
0
 private void InitClass() {
     this.DataSetName = "dsWT";
     this.Prefix = "";
     this.Namespace = "http://tempuri.org/dsWT.xsd";
     this.EnforceConstraints = true;
     this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     this.tableCountry = new CountryDataTable();
     base.Tables.Add(this.tableCountry);
     this.tableState = new StateDataTable();
     base.Tables.Add(this.tableState);
     this.tableContinent = new ContinentDataTable();
     base.Tables.Add(this.tableContinent);
     this.tableTimezone = new TimezoneDataTable();
     base.Tables.Add(this.tableTimezone);
     this.tableCity = new CityDataTable();
     base.Tables.Add(this.tableCity);
     System.Data.ForeignKeyConstraint fkc;
     fkc = new System.Data.ForeignKeyConstraint("FK_Continent_Country_Continent_ID", new System.Data.DataColumn[] {
                 this.tableContinent.Continent_IDColumn}, new System.Data.DataColumn[] {
                 this.tableCountry.Continent_IDColumn});
     this.tableCountry.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("FK_Country_State_Country_ID", new System.Data.DataColumn[] {
                 this.tableCountry.Country_IDColumn}, new System.Data.DataColumn[] {
                 this.tableState.Country_IDColumn});
     this.tableState.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("FK_Timezone_City_Timezone_ID", new System.Data.DataColumn[] {
                 this.tableTimezone.Timezone_IDColumn}, new System.Data.DataColumn[] {
                 this.tableCity.Timezone_IDColumn});
     this.tableCity.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     fkc = new System.Data.ForeignKeyConstraint("FK_State_City_State_ID", new System.Data.DataColumn[] {
                 this.tableState.State_IDColumn}, new System.Data.DataColumn[] {
                 this.tableCity.State_IDColumn});
     this.tableCity.Constraints.Add(fkc);
     fkc.AcceptRejectRule = System.Data.AcceptRejectRule.None;
     fkc.DeleteRule = System.Data.Rule.Cascade;
     fkc.UpdateRule = System.Data.Rule.Cascade;
     this.relationFK_Continent_Country_Continent_ID = new System.Data.DataRelation("FK_Continent_Country_Continent_ID", new System.Data.DataColumn[] {
                 this.tableContinent.Continent_IDColumn}, new System.Data.DataColumn[] {
                 this.tableCountry.Continent_IDColumn}, false);
     this.Relations.Add(this.relationFK_Continent_Country_Continent_ID);
     this.relationFK_Country_State_Country_ID = new System.Data.DataRelation("FK_Country_State_Country_ID", new System.Data.DataColumn[] {
                 this.tableCountry.Country_IDColumn}, new System.Data.DataColumn[] {
                 this.tableState.Country_IDColumn}, false);
     this.Relations.Add(this.relationFK_Country_State_Country_ID);
     this.relationFK_Timezone_City_Timezone_ID = new System.Data.DataRelation("FK_Timezone_City_Timezone_ID", new System.Data.DataColumn[] {
                 this.tableTimezone.Timezone_IDColumn}, new System.Data.DataColumn[] {
                 this.tableCity.Timezone_IDColumn}, false);
     this.Relations.Add(this.relationFK_Timezone_City_Timezone_ID);
     this.relationFK_State_City_State_ID = new System.Data.DataRelation("FK_State_City_State_ID", new System.Data.DataColumn[] {
                 this.tableState.State_IDColumn}, new System.Data.DataColumn[] {
                 this.tableCity.State_IDColumn}, false);
     this.Relations.Add(this.relationFK_State_City_State_ID);
 }