Difference between revisions of "AdventureWorks Table Mappings EF1"
(New page: edmx upload (20100609 200009 AdventureWorks2005ef1.edmx) === Namespace === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | [[dbo...) |
|||
Line 1: | Line 1: | ||
+ | edmx upload (20100609 200009 AdventureWorks2005ef1.edmx) | ||
+ | |||
+ | === Namespace === | ||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[dbo.AWBuildVersion_(table)|dbo.AWBuildVersion]] | ||
+ | | [[AWBuildVersion_(class)|AWBuildVersion]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[dbo.DatabaseLog_(table)|dbo.DatabaseLog]] | ||
+ | | [[DatabaseLog_(class)|DatabaseLog]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[dbo.ErrorLog_(table)|dbo.ErrorLog]] | ||
+ | | [[ErrorLog_(class)|ErrorLog]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[HumanResources.Department_(table)|HumanResources.Department]] | ||
+ | | [[Department_(class)|Department]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[HumanResources.Employee_(table)|HumanResources.Employee]] | ||
+ | | [[Employee_(class)|Employee]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[HumanResources.EmployeeAddress_(table)|HumanResources.EmployeeAddress]] | ||
+ | | [[EmployeeAddress_(class)|EmployeeAddress]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]] | ||
+ | | [[EmployeeDepartmentHistory_(class)|EmployeeDepartmentHistory]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]] | ||
+ | | [[EmployeePayHistory_(class)|EmployeePayHistory]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]] | ||
+ | | [[JobCandidate_(class)|JobCandidate]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[HumanResources.Shift_(table)|HumanResources.Shift]] | ||
+ | | [[Shift_(class)|Shift]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Person.Address_(table)|Person.Address]] | ||
+ | | [[Address_(class)|Address]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Person.AddressType_(table)|Person.AddressType]] | ||
+ | | [[AddressType_(class)|AddressType]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Person.Contact_(table)|Person.Contact]] | ||
+ | | [[Contact_(class)|Contact]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Person.ContactType_(table)|Person.ContactType]] | ||
+ | | [[ContactType_(class)|ContactType]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Person.CountryRegion_(table)|Person.CountryRegion]] | ||
+ | | [[CountryRegion_(class)|CountryRegion]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Person.StateProvince_(table)|Person.StateProvince]] | ||
+ | | [[StateProvince_(class)|StateProvince]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.BillOfMaterials_(table)|Production.BillOfMaterials]] | ||
+ | | [[BillOfMaterials_(class)|BillOfMaterials]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.Culture_(table)|Production.Culture]] | ||
+ | | [[Culture_(class)|Culture]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.Document_(table)|Production.Document]] | ||
+ | | [[Document_(class)|Document]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.Illustration_(table)|Production.Illustration]] | ||
+ | | [[Illustration_(class)|Illustration]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.Location_(table)|Production.Location]] | ||
+ | | [[Location_(class)|Location]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.Product_(table)|Production.Product]] | ||
+ | | [[Product_(class)|Product]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.ProductCategory_(table)|Production.ProductCategory]] | ||
+ | | [[ProductCategory_(class)|ProductCategory]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.ProductCostHistory_(table)|Production.ProductCostHistory]] | ||
+ | | [[ProductCostHistory_(class)|ProductCostHistory]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.ProductDescription_(table)|Production.ProductDescription]] | ||
+ | | [[ProductDescription_(class)|ProductDescription]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.ProductDocument_(table)|Production.ProductDocument]] | ||
+ | | [[ProductDocument_(class)|ProductDocument]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.ProductInventory_(table)|Production.ProductInventory]] | ||
+ | | [[ProductInventory_(class)|ProductInventory]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.ProductListPriceHistory_(table)|Production.ProductListPriceHistory]] | ||
+ | | [[ProductListPriceHistory_(class)|ProductListPriceHistory]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.ProductModel_(table)|Production.ProductModel]] | ||
+ | | [[ProductModel_(class)|ProductModel]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.ProductModelIllustration_(table)|Production.ProductModelIllustration]] | ||
+ | | [[ProductModelIllustration_(class)|ProductModelIllustration]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]] | ||
+ | | [[ProductModelProductDescriptionCulture_(class)|ProductModelProductDescriptionCulture]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.ProductPhoto_(table)|Production.ProductPhoto]] | ||
+ | | [[ProductPhoto_(class)|ProductPhoto]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.ProductProductPhoto_(table)|Production.ProductProductPhoto]] | ||
+ | | [[ProductProductPhoto_(class)|ProductProductPhoto]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.ProductReview_(table)|Production.ProductReview]] | ||
+ | | [[ProductReview_(class)|ProductReview]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]] | ||
+ | | [[ProductSubcategory_(class)|ProductSubcategory]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.ScrapReason_(table)|Production.ScrapReason]] | ||
+ | | [[ScrapReason_(class)|ScrapReason]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.TransactionHistory_(table)|Production.TransactionHistory]] | ||
+ | | [[TransactionHistory_(class)|TransactionHistory]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.TransactionHistoryArchive_(table)|Production.TransactionHistoryArchive]] | ||
+ | | [[TransactionHistoryArchive_(class)|TransactionHistoryArchive]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | ||
+ | | [[UnitMeasure_(class)|UnitMeasure]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.WorkOrder_(table)|Production.WorkOrder]] | ||
+ | | [[WorkOrder_(class)|WorkOrder]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.WorkOrderRouting_(table)|Production.WorkOrderRouting]] | ||
+ | | [[WorkOrderRouting_(class)|WorkOrderRouting]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]] | ||
+ | | [[ProductVendor_(class)|ProductVendor]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]] | ||
+ | | [[PurchaseOrderDetail_(class)|PurchaseOrderDetail]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]] | ||
+ | | [[PurchaseOrderHeader_(class)|PurchaseOrderHeader]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]] | ||
+ | | [[ShipMethod_(class)|ShipMethod]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Purchasing.Vendor_(table)|Purchasing.Vendor]] | ||
+ | | [[Vendor_(class)|Vendor]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Purchasing.VendorAddress_(table)|Purchasing.VendorAddress]] | ||
+ | | [[VendorAddress_(class)|VendorAddress]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]] | ||
+ | | [[VendorContact_(class)|VendorContact]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]] | ||
+ | | [[ContactCreditCard_(class)|ContactCreditCard]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.CountryRegionCurrency_(table)|Sales.CountryRegionCurrency]] | ||
+ | | [[CountryRegionCurrency_(class)|CountryRegionCurrency]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.CreditCard_(table)|Sales.CreditCard]] | ||
+ | | [[CreditCard_(class)|CreditCard]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.Currency_(table)|Sales.Currency]] | ||
+ | | [[Currency_(class)|Currency]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.CurrencyRate_(table)|Sales.CurrencyRate]] | ||
+ | | [[CurrencyRate_(class)|CurrencyRate]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.Customer_(table)|Sales.Customer]] | ||
+ | | [[Customer_(class)|Customer]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.CustomerAddress_(table)|Sales.CustomerAddress]] | ||
+ | | [[CustomerAddress_(class)|CustomerAddress]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.Individual_(table)|Sales.Individual]] | ||
+ | | [[Individual_(class)|Individual]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]] | ||
+ | | [[SalesOrderDetail_(class)|SalesOrderDetail]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | ||
+ | | [[SalesOrderHeader_(class)|SalesOrderHeader]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.SalesOrderHeaderSalesReason_(table)|Sales.SalesOrderHeaderSalesReason]] | ||
+ | | [[SalesOrderHeaderSalesReason_(class)|SalesOrderHeaderSalesReason]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.SalesPerson_(table)|Sales.SalesPerson]] | ||
+ | | [[SalesPerson_(class)|SalesPerson]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.SalesPersonQuotaHistory_(table)|Sales.SalesPersonQuotaHistory]] | ||
+ | | [[SalesPersonQuotaHistory_(class)|SalesPersonQuotaHistory]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.SalesReason_(table)|Sales.SalesReason]] | ||
+ | | [[SalesReason_(class)|SalesReason]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]] | ||
+ | | [[SalesTaxRate_(class)|SalesTaxRate]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]] | ||
+ | | [[SalesTerritory_(class)|SalesTerritory]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.SalesTerritoryHistory_(table)|Sales.SalesTerritoryHistory]] | ||
+ | | [[SalesTerritoryHistory_(class)|SalesTerritoryHistory]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.ShoppingCartItem_(table)|Sales.ShoppingCartItem]] | ||
+ | | [[ShoppingCartItem_(class)|ShoppingCartItem]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.SpecialOffer_(table)|Sales.SpecialOffer]] | ||
+ | | [[SpecialOffer_(class)|SpecialOffer]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.SpecialOfferProduct_(table)|Sales.SpecialOfferProduct]] | ||
+ | | [[SpecialOfferProduct_(class)|SpecialOfferProduct]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.Store_(table)|Sales.Store]] | ||
+ | | [[Store_(class)|Store]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.StoreContact_(table)|Sales.StoreContact]] | ||
+ | | [[StoreContact_(class)|StoreContact]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]] | ||
+ | | [[vEmployee_(class)|vEmployee]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]] | ||
+ | | [[vEmployeeDepartment_(class)|vEmployeeDepartment]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]] | ||
+ | | [[vEmployeeDepartmentHistory_(class)|vEmployeeDepartmentHistory]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]] | ||
+ | | [[vJobCandidate_(class)|vJobCandidate]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]] | ||
+ | | [[vJobCandidateEducation_(class)|vJobCandidateEducation]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]] | ||
+ | | [[vJobCandidateEmployment_(class)|vJobCandidateEmployment]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Person.vAdditionalContactInfo_(view)|Person.vAdditionalContactInfo]] | ||
+ | | [[vAdditionalContactInfo_(class)|vAdditionalContactInfo]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Person.vStateProvinceCountryRegion_(view)|Person.vStateProvinceCountryRegion]] | ||
+ | | [[vStateProvinceCountryRegion_(class)|vStateProvinceCountryRegion]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]] | ||
+ | | [[vProductAndDescription_(class)|vProductAndDescription]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.vProductModelCatalogDescription_(view)|Production.vProductModelCatalogDescription]] | ||
+ | | [[vProductModelCatalogDescription_(class)|vProductModelCatalogDescription]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Production.vProductModelInstructions_(view)|Production.vProductModelInstructions]] | ||
+ | | [[vProductModelInstructions_(class)|vProductModelInstructions]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Purchasing.vVendor_(view)|Purchasing.vVendor]] | ||
+ | | [[vVendor_(class)|vVendor]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]] | ||
+ | | [[vIndividualCustomer_(class)|vIndividualCustomer]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.vIndividualDemographics_(view)|Sales.vIndividualDemographics]] | ||
+ | | [[vIndividualDemographics_(class)|vIndividualDemographics]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]] | ||
+ | | [[vSalesPerson_(class)|vSalesPerson]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]] | ||
+ | | [[vSalesPersonSalesByFiscalYears_(class)|vSalesPersonSalesByFiscalYears]] | ||
+ | |||
+ | |- valign="top" | ||
+ | | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]] | ||
+ | | [[vStoreWithDemographics_(class)|vStoreWithDemographics]] | ||
+ | |||
+ | |} | ||
+ | |||
+ | == wikibot == | ||
edmx upload (20100609 200009 AdventureWorks2005ef1.edmx) | edmx upload (20100609 200009 AdventureWorks2005ef1.edmx) | ||
Latest revision as of 01:09, 24 June 2010
edmx upload (20100609 200009 AdventureWorks2005ef1.edmx)
Namespace[edit]
wikibot[edit]
edmx upload (20100609 200009 AdventureWorks2005ef1.edmx)