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); }
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); }
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); }
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); }
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); }
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); }
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); }