static ProductReview() { // Cache field metadata. EntityMeta <ProductReview> .LoadColumnMetadata ( new ColumnMetadata(nameof(ProductReviewID), @"ProductReviewID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(ProductID), @"ProductID", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(ReviewerName), @"ReviewerName", DbType.String, isRequired : true), new ColumnMetadata(nameof(ReviewDate), @"ReviewDate", DbType.DateTime, isRequired : true), new ColumnMetadata(nameof(EmailAddress), @"EmailAddress", DbType.String, isRequired : true), new ColumnMetadata(nameof(Rating), @"Rating", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(Comments), @"Comments", DbType.String, isRequired : false), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <ProductReview> .LoadRelationMetadata ( new RelationMetadata(nameof(e_ProductID), nameof(ProductID), nameof(AdventureWorks.Production.Product.ProductID)) ); // Cache table metadata. EntityMeta <ProductReview> .HasLanguageTable = false; EntityMeta <ProductReview> .TableSchema = @"Production"; EntityMeta <ProductReview> .TableName = @"ProductReview"; EntityMeta <ProductReview> .LanguageTableSchema = null; EntityMeta <ProductReview> .LanguageTableName = null; }
static CreditCard() { // Cache field metadata. EntityMeta <CreditCard> .LoadColumnMetadata ( new ColumnMetadata(nameof(CreditCardID), @"CreditCardID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(CardType), @"CardType", DbType.String, isRequired : true), new ColumnMetadata(nameof(CardNumber), @"CardNumber", DbType.String, isRequired : true), new ColumnMetadata(nameof(ExpMonth), @"ExpMonth", DbType.Byte, isRequired : true), new ColumnMetadata(nameof(ExpYear), @"ExpYear", DbType.Int16, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <CreditCard> .LoadRelationMetadata ( null ); // Cache table metadata. EntityMeta <CreditCard> .HasLanguageTable = false; EntityMeta <CreditCard> .TableSchema = @"Sales"; EntityMeta <CreditCard> .TableName = @"CreditCard"; EntityMeta <CreditCard> .LanguageTableSchema = null; EntityMeta <CreditCard> .LanguageTableName = null; }
static BusinessEntityAddress() { // Cache field metadata. EntityMeta <BusinessEntityAddress> .LoadColumnMetadata ( new ColumnMetadata(nameof(BusinessEntityID), @"BusinessEntityID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(AddressID), @"AddressID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(AddressTypeID), @"AddressTypeID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(rowguid), @"rowguid", DbType.Guid, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <BusinessEntityAddress> .LoadRelationMetadata ( new RelationMetadata(nameof(e_AddressID), nameof(AddressID), nameof(AdventureWorks.Person.Address.AddressID)), new RelationMetadata(nameof(e_AddressTypeID), nameof(AddressTypeID), nameof(AdventureWorks.Person.AddressType.AddressTypeID)), new RelationMetadata(nameof(e_BusinessEntityID), nameof(BusinessEntityID), nameof(AdventureWorks.Person.BusinessEntity.BusinessEntityID)) ); // Cache table metadata. EntityMeta <BusinessEntityAddress> .HasLanguageTable = false; EntityMeta <BusinessEntityAddress> .TableSchema = @"Person"; EntityMeta <BusinessEntityAddress> .TableName = @"BusinessEntityAddress"; EntityMeta <BusinessEntityAddress> .LanguageTableSchema = null; EntityMeta <BusinessEntityAddress> .LanguageTableName = null; }
static WorkOrderRouting() { // Cache field metadata. EntityMeta <WorkOrderRouting> .LoadColumnMetadata ( new ColumnMetadata(nameof(WorkOrderID), @"WorkOrderID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(ProductID), @"ProductID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(OperationSequence), @"OperationSequence", DbType.Int16, isPrimaryKey : true), new ColumnMetadata(nameof(LocationID), @"LocationID", DbType.Int16, isRequired : true), new ColumnMetadata(nameof(ScheduledStartDate), @"ScheduledStartDate", DbType.DateTime, isRequired : true), new ColumnMetadata(nameof(ScheduledEndDate), @"ScheduledEndDate", DbType.DateTime, isRequired : true), new ColumnMetadata(nameof(ActualStartDate), @"ActualStartDate", DbType.DateTime, isRequired : false), new ColumnMetadata(nameof(ActualEndDate), @"ActualEndDate", DbType.DateTime, isRequired : false), new ColumnMetadata(nameof(ActualResourceHrs), @"ActualResourceHrs", DbType.Decimal, isRequired : false), new ColumnMetadata(nameof(PlannedCost), @"PlannedCost", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(ActualCost), @"ActualCost", DbType.Decimal, isRequired : false), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <WorkOrderRouting> .LoadRelationMetadata ( new RelationMetadata(nameof(e_LocationID), nameof(LocationID), nameof(AdventureWorks.Production.Location.LocationID)), new RelationMetadata(nameof(e_WorkOrderID), nameof(WorkOrderID), nameof(AdventureWorks.Production.WorkOrder.WorkOrderID)) ); // Cache table metadata. EntityMeta <WorkOrderRouting> .HasLanguageTable = false; EntityMeta <WorkOrderRouting> .TableSchema = @"Production"; EntityMeta <WorkOrderRouting> .TableName = @"WorkOrderRouting"; EntityMeta <WorkOrderRouting> .LanguageTableSchema = null; EntityMeta <WorkOrderRouting> .LanguageTableName = null; }
static ProductModel() { // Cache field metadata. EntityMeta <ProductModel> .LoadColumnMetadata ( new ColumnMetadata(nameof(ProductModelID), @"ProductModelID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(Name), @"Name", DbType.String, isRequired : true), new ColumnMetadata(nameof(CatalogDescription), @"CatalogDescription", DbType.Xml, isRequired : false), new ColumnMetadata(nameof(Instructions), @"Instructions", DbType.Xml, isRequired : false), new ColumnMetadata(nameof(rowguid), @"rowguid", DbType.Guid, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <ProductModel> .LoadRelationMetadata ( null ); // Cache table metadata. EntityMeta <ProductModel> .HasLanguageTable = false; EntityMeta <ProductModel> .TableSchema = @"Production"; EntityMeta <ProductModel> .TableName = @"ProductModel"; EntityMeta <ProductModel> .LanguageTableSchema = null; EntityMeta <ProductModel> .LanguageTableName = null; }
static Password() { // Cache field metadata. EntityMeta <Password> .LoadColumnMetadata ( new ColumnMetadata(nameof(BusinessEntityID), @"BusinessEntityID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(PasswordHash), @"PasswordHash", DbType.String, isRequired : true), new ColumnMetadata(nameof(PasswordSalt), @"PasswordSalt", DbType.String, isRequired : true), new ColumnMetadata(nameof(rowguid), @"rowguid", DbType.Guid, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <Password> .LoadRelationMetadata ( new RelationMetadata(nameof(e_BusinessEntityID), nameof(BusinessEntityID), nameof(AdventureWorks.Person.Person.BusinessEntityID)) ); // Cache table metadata. EntityMeta <Password> .HasLanguageTable = false; EntityMeta <Password> .TableSchema = @"Person"; EntityMeta <Password> .TableName = @"Password"; EntityMeta <Password> .LanguageTableSchema = null; EntityMeta <Password> .LanguageTableName = null; }
static ProductPhoto() { // Cache field metadata. EntityMeta <ProductPhoto> .LoadColumnMetadata ( new ColumnMetadata(nameof(ProductPhotoID), @"ProductPhotoID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(ThumbNailPhoto), @"ThumbNailPhoto", DbType.Binary, isRequired : false), new ColumnMetadata(nameof(ThumbnailPhotoFileName), @"ThumbnailPhotoFileName", DbType.String, isRequired : false), new ColumnMetadata(nameof(LargePhoto), @"LargePhoto", DbType.Binary, isRequired : false), new ColumnMetadata(nameof(LargePhotoFileName), @"LargePhotoFileName", DbType.String, isRequired : false), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <ProductPhoto> .LoadRelationMetadata ( null ); // Cache table metadata. EntityMeta <ProductPhoto> .HasLanguageTable = false; EntityMeta <ProductPhoto> .TableSchema = @"Production"; EntityMeta <ProductPhoto> .TableName = @"ProductPhoto"; EntityMeta <ProductPhoto> .LanguageTableSchema = null; EntityMeta <ProductPhoto> .LanguageTableName = null; }
static Store() { // Cache field metadata. EntityMeta<Store>.LoadColumnMetadata ( new ColumnMetadata(nameof(BusinessEntityID), @"BusinessEntityID", DbType.Int32, isPrimaryKey: true), new ColumnMetadata(nameof(Name), @"Name", DbType.String, isRequired: true), new ColumnMetadata(nameof(SalesPersonID), @"SalesPersonID", DbType.Int32, isRequired: false), new ColumnMetadata(nameof(Demographics), @"Demographics", DbType.Xml, isRequired: false), new ColumnMetadata(nameof(rowguid), @"rowguid", DbType.Guid, isRequired: true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired: true) ); // Cache entites metadata. EntityMeta<Store>.LoadRelationMetadata ( new RelationMetadata(nameof(e_BusinessEntityID), nameof(BusinessEntityID), nameof(AdventureWorks.Person.BusinessEntity.BusinessEntityID)), new RelationMetadata(nameof(e_SalesPersonID), nameof(SalesPersonID), nameof(AdventureWorks.Sales.SalesPerson.BusinessEntityID)) ); // Cache table metadata. EntityMeta<Store>.HasLanguageTable = false; EntityMeta<Store>.TableSchema = @"Sales"; EntityMeta<Store>.TableName = @"Store"; EntityMeta<Store>.LanguageTableSchema = null; EntityMeta<Store>.LanguageTableName = null; }
static Suppliers() { // Cache field metadata. EntityMeta <Suppliers> .LoadColumnMetadata ( new ColumnMetadata(nameof(SupplierID), @"SupplierID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(CompanyName), @"CompanyName", DbType.String, isRequired : true), new ColumnMetadata(nameof(ContactName), @"ContactName", DbType.String, isRequired : false), new ColumnMetadata(nameof(ContactTitle), @"ContactTitle", DbType.String, isRequired : false), new ColumnMetadata(nameof(Address), @"Address", DbType.String, isRequired : false), new ColumnMetadata(nameof(City), @"City", DbType.String, isRequired : false), new ColumnMetadata(nameof(Region), @"Region", DbType.String, isRequired : false), new ColumnMetadata(nameof(PostalCode), @"PostalCode", DbType.String, isRequired : false), new ColumnMetadata(nameof(Country), @"Country", DbType.String, isRequired : false), new ColumnMetadata(nameof(Phone), @"Phone", DbType.String, isRequired : false), new ColumnMetadata(nameof(Fax), @"Fax", DbType.String, isRequired : false), new ColumnMetadata(nameof(HomePage), @"HomePage", DbType.String, isRequired : false) ); // Cache entites metadata. EntityMeta <Suppliers> .LoadRelationMetadata ( null ); // Cache table metadata. EntityMeta <Suppliers> .HasLanguageTable = false; EntityMeta <Suppliers> .TableSchema = @"dbo"; EntityMeta <Suppliers> .TableName = @"Suppliers"; EntityMeta <Suppliers> .LanguageTableSchema = null; EntityMeta <Suppliers> .LanguageTableName = null; }
static EmployeeDepartmentHistory() { // Cache field metadata. EntityMeta <EmployeeDepartmentHistory> .LoadColumnMetadata ( new ColumnMetadata(nameof(BusinessEntityID), @"BusinessEntityID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(DepartmentID), @"DepartmentID", DbType.Int16, isPrimaryKey : true), new ColumnMetadata(nameof(ShiftID), @"ShiftID", DbType.Byte, isPrimaryKey : true), new ColumnMetadata(nameof(StartDate), @"StartDate", DbType.Date, isPrimaryKey : true), new ColumnMetadata(nameof(EndDate), @"EndDate", DbType.Date, isRequired : false), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <EmployeeDepartmentHistory> .LoadRelationMetadata ( new RelationMetadata(nameof(e_BusinessEntityID), nameof(BusinessEntityID), nameof(AdventureWorks.HumanResources.Employee.BusinessEntityID)), new RelationMetadata(nameof(e_DepartmentID), nameof(DepartmentID), nameof(AdventureWorks.HumanResources.Department.DepartmentID)), new RelationMetadata(nameof(e_ShiftID), nameof(ShiftID), nameof(AdventureWorks.HumanResources.Shift.ShiftID)) ); // Cache table metadata. EntityMeta <EmployeeDepartmentHistory> .HasLanguageTable = false; EntityMeta <EmployeeDepartmentHistory> .TableSchema = @"HumanResources"; EntityMeta <EmployeeDepartmentHistory> .TableName = @"EmployeeDepartmentHistory"; EntityMeta <EmployeeDepartmentHistory> .LanguageTableSchema = null; EntityMeta <EmployeeDepartmentHistory> .LanguageTableName = null; }
static PersonPhone() { // Cache field metadata. EntityMeta <PersonPhone> .LoadColumnMetadata ( new ColumnMetadata(nameof(BusinessEntityID), @"BusinessEntityID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(PhoneNumber), @"PhoneNumber", DbType.String, isPrimaryKey : true), new ColumnMetadata(nameof(PhoneNumberTypeID), @"PhoneNumberTypeID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <PersonPhone> .LoadRelationMetadata ( new RelationMetadata(nameof(e_BusinessEntityID), nameof(BusinessEntityID), nameof(AdventureWorks.Person.Person.BusinessEntityID)), new RelationMetadata(nameof(e_PhoneNumberTypeID), nameof(PhoneNumberTypeID), nameof(AdventureWorks.Person.PhoneNumberType.PhoneNumberTypeID)) ); // Cache table metadata. EntityMeta <PersonPhone> .HasLanguageTable = false; EntityMeta <PersonPhone> .TableSchema = @"Person"; EntityMeta <PersonPhone> .TableName = @"PersonPhone"; EntityMeta <PersonPhone> .LanguageTableSchema = null; EntityMeta <PersonPhone> .LanguageTableName = null; }
static SalesTaxRate() { // Cache field metadata. EntityMeta <SalesTaxRate> .LoadColumnMetadata ( new ColumnMetadata(nameof(SalesTaxRateID), @"SalesTaxRateID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(StateProvinceID), @"StateProvinceID", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(TaxType), @"TaxType", DbType.Byte, isRequired : true), new ColumnMetadata(nameof(TaxRate), @"TaxRate", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(Name), @"Name", DbType.String, isRequired : true), new ColumnMetadata(nameof(rowguid), @"rowguid", DbType.Guid, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <SalesTaxRate> .LoadRelationMetadata ( new RelationMetadata(nameof(e_StateProvinceID), nameof(StateProvinceID), nameof(AdventureWorks.Person.StateProvince.StateProvinceID)) ); // Cache table metadata. EntityMeta <SalesTaxRate> .HasLanguageTable = false; EntityMeta <SalesTaxRate> .TableSchema = @"Sales"; EntityMeta <SalesTaxRate> .TableName = @"SalesTaxRate"; EntityMeta <SalesTaxRate> .LanguageTableSchema = null; EntityMeta <SalesTaxRate> .LanguageTableName = null; }
static BillOfMaterials() { // Cache field metadata. EntityMeta <BillOfMaterials> .LoadColumnMetadata ( new ColumnMetadata(nameof(BillOfMaterialsID), @"BillOfMaterialsID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(ProductAssemblyID), @"ProductAssemblyID", DbType.Int32, isRequired : false), new ColumnMetadata(nameof(ComponentID), @"ComponentID", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(StartDate), @"StartDate", DbType.DateTime, isRequired : true), new ColumnMetadata(nameof(EndDate), @"EndDate", DbType.DateTime, isRequired : false), new ColumnMetadata(nameof(UnitMeasureCode), @"UnitMeasureCode", DbType.StringFixedLength, isRequired : true), new ColumnMetadata(nameof(BOMLevel), @"BOMLevel", DbType.Int16, isRequired : true), new ColumnMetadata(nameof(PerAssemblyQty), @"PerAssemblyQty", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <BillOfMaterials> .LoadRelationMetadata ( new RelationMetadata(nameof(e_ComponentID), nameof(ComponentID), nameof(AdventureWorks.Production.Product.ProductID)), new RelationMetadata(nameof(e_ProductAssemblyID), nameof(ProductAssemblyID), nameof(AdventureWorks.Production.Product.ProductID)), new RelationMetadata(nameof(e_UnitMeasureCode), nameof(UnitMeasureCode), nameof(AdventureWorks.Production.UnitMeasure.UnitMeasureCode)) ); // Cache table metadata. EntityMeta <BillOfMaterials> .HasLanguageTable = false; EntityMeta <BillOfMaterials> .TableSchema = @"Production"; EntityMeta <BillOfMaterials> .TableName = @"BillOfMaterials"; EntityMeta <BillOfMaterials> .LanguageTableSchema = null; EntityMeta <BillOfMaterials> .LanguageTableName = null; }
static SpecialOfferProduct() { // Cache field metadata. EntityMeta <SpecialOfferProduct> .LoadColumnMetadata ( new ColumnMetadata(nameof(SpecialOfferID), @"SpecialOfferID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(ProductID), @"ProductID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(rowguid), @"rowguid", DbType.Guid, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <SpecialOfferProduct> .LoadRelationMetadata ( new RelationMetadata(nameof(e_ProductID), nameof(ProductID), nameof(AdventureWorks.Production.Product.ProductID)), new RelationMetadata(nameof(e_SpecialOfferID), nameof(SpecialOfferID), nameof(AdventureWorks.Sales.SpecialOffer.SpecialOfferID)) ); // Cache table metadata. EntityMeta <SpecialOfferProduct> .HasLanguageTable = false; EntityMeta <SpecialOfferProduct> .TableSchema = @"Sales"; EntityMeta <SpecialOfferProduct> .TableName = @"SpecialOfferProduct"; EntityMeta <SpecialOfferProduct> .LanguageTableSchema = null; EntityMeta <SpecialOfferProduct> .LanguageTableName = null; }
static Shift() { // Cache field metadata. EntityMeta <Shift> .LoadColumnMetadata ( new ColumnMetadata(nameof(ShiftID), @"ShiftID", DbType.Byte, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(Name), @"Name", DbType.String, isRequired : true), new ColumnMetadata(nameof(StartTime), @"StartTime", DbType.Time, isRequired : true), new ColumnMetadata(nameof(EndTime), @"EndTime", DbType.Time, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <Shift> .LoadRelationMetadata ( null ); // Cache table metadata. EntityMeta <Shift> .HasLanguageTable = false; EntityMeta <Shift> .TableSchema = @"HumanResources"; EntityMeta <Shift> .TableName = @"Shift"; EntityMeta <Shift> .LanguageTableSchema = null; EntityMeta <Shift> .LanguageTableName = null; }
static Customer() { // Cache field metadata. EntityMeta <Customer> .LoadColumnMetadata ( new ColumnMetadata(nameof(CustomerID), @"CustomerID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(PersonID), @"PersonID", DbType.Int32, isRequired : false), new ColumnMetadata(nameof(StoreID), @"StoreID", DbType.Int32, isRequired : false), new ColumnMetadata(nameof(TerritoryID), @"TerritoryID", DbType.Int32, isRequired : false), new ColumnMetadata(nameof(AccountNumber), @"AccountNumber", DbType.String, isRequired : true), new ColumnMetadata(nameof(rowguid), @"rowguid", DbType.Guid, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <Customer> .LoadRelationMetadata ( new RelationMetadata(nameof(e_PersonID), nameof(PersonID), nameof(AdventureWorks.Person.Person.BusinessEntityID)), new RelationMetadata(nameof(e_StoreID), nameof(StoreID), nameof(AdventureWorks.Sales.Store.BusinessEntityID)), new RelationMetadata(nameof(e_TerritoryID), nameof(TerritoryID), nameof(AdventureWorks.Sales.SalesTerritory.TerritoryID)) ); // Cache table metadata. EntityMeta <Customer> .HasLanguageTable = false; EntityMeta <Customer> .TableSchema = @"Sales"; EntityMeta <Customer> .TableName = @"Customer"; EntityMeta <Customer> .LanguageTableSchema = null; EntityMeta <Customer> .LanguageTableName = null; }
static TransactionHistory() { // Cache field metadata. EntityMeta <TransactionHistory> .LoadColumnMetadata ( new ColumnMetadata(nameof(TransactionID), @"TransactionID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(ProductID), @"ProductID", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(ReferenceOrderID), @"ReferenceOrderID", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(ReferenceOrderLineID), @"ReferenceOrderLineID", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(TransactionDate), @"TransactionDate", DbType.DateTime, isRequired : true), new ColumnMetadata(nameof(TransactionType), @"TransactionType", DbType.StringFixedLength, isRequired : true), new ColumnMetadata(nameof(Quantity), @"Quantity", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(ActualCost), @"ActualCost", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <TransactionHistory> .LoadRelationMetadata ( new RelationMetadata(nameof(e_ProductID), nameof(ProductID), nameof(AdventureWorks.Production.Product.ProductID)) ); // Cache table metadata. EntityMeta <TransactionHistory> .HasLanguageTable = false; EntityMeta <TransactionHistory> .TableSchema = @"Production"; EntityMeta <TransactionHistory> .TableName = @"TransactionHistory"; EntityMeta <TransactionHistory> .LanguageTableSchema = null; EntityMeta <TransactionHistory> .LanguageTableName = null; }
static SalesOrderDetail() { // Cache field metadata. EntityMeta <SalesOrderDetail> .LoadColumnMetadata ( new ColumnMetadata(nameof(SalesOrderID), @"SalesOrderID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(SalesOrderDetailID), @"SalesOrderDetailID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(CarrierTrackingNumber), @"CarrierTrackingNumber", DbType.String, isRequired : false), new ColumnMetadata(nameof(OrderQty), @"OrderQty", DbType.Int16, isRequired : true), new ColumnMetadata(nameof(ProductID), @"ProductID", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(SpecialOfferID), @"SpecialOfferID", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(UnitPrice), @"UnitPrice", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(UnitPriceDiscount), @"UnitPriceDiscount", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(LineTotal), @"LineTotal", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(rowguid), @"rowguid", DbType.Guid, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <SalesOrderDetail> .LoadRelationMetadata ( new RelationMetadata(nameof(e_SalesOrderID), nameof(SalesOrderID), nameof(AdventureWorks.Sales.SalesOrderHeader.SalesOrderID)), new RelationMetadata(nameof(SpecialOfferIDProductID), nameof(SpecialOfferID), nameof(AdventureWorks.Sales.SpecialOfferProduct.SpecialOfferID)), new RelationMetadata(nameof(SpecialOfferIDProductID), nameof(ProductID), nameof(AdventureWorks.Sales.SpecialOfferProduct.ProductID)) ); // Cache table metadata. EntityMeta <SalesOrderDetail> .HasLanguageTable = false; EntityMeta <SalesOrderDetail> .TableSchema = @"Sales"; EntityMeta <SalesOrderDetail> .TableName = @"SalesOrderDetail"; EntityMeta <SalesOrderDetail> .LanguageTableSchema = null; EntityMeta <SalesOrderDetail> .LanguageTableName = null; }
static CurrencyRate() { // Cache field metadata. EntityMeta <CurrencyRate> .LoadColumnMetadata ( new ColumnMetadata(nameof(CurrencyRateID), @"CurrencyRateID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(CurrencyRateDate), @"CurrencyRateDate", DbType.DateTime, isRequired : true), new ColumnMetadata(nameof(FromCurrencyCode), @"FromCurrencyCode", DbType.StringFixedLength, isRequired : true), new ColumnMetadata(nameof(ToCurrencyCode), @"ToCurrencyCode", DbType.StringFixedLength, isRequired : true), new ColumnMetadata(nameof(AverageRate), @"AverageRate", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(EndOfDayRate), @"EndOfDayRate", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <CurrencyRate> .LoadRelationMetadata ( new RelationMetadata(nameof(e_FromCurrencyCode), nameof(FromCurrencyCode), nameof(AdventureWorks.Sales.Currency.CurrencyCode)), new RelationMetadata(nameof(e_ToCurrencyCode), nameof(ToCurrencyCode), nameof(AdventureWorks.Sales.Currency.CurrencyCode)) ); // Cache table metadata. EntityMeta <CurrencyRate> .HasLanguageTable = false; EntityMeta <CurrencyRate> .TableSchema = @"Sales"; EntityMeta <CurrencyRate> .TableName = @"CurrencyRate"; EntityMeta <CurrencyRate> .LanguageTableSchema = null; EntityMeta <CurrencyRate> .LanguageTableName = null; }
static ProductSubcategory() { // Cache field metadata. EntityMeta <ProductSubcategory> .LoadColumnMetadata ( new ColumnMetadata(nameof(ProductSubcategoryID), @"ProductSubcategoryID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(ProductCategoryID), @"ProductCategoryID", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(Name), @"Name", DbType.String, isRequired : true), new ColumnMetadata(nameof(rowguid), @"rowguid", DbType.Guid, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <ProductSubcategory> .LoadRelationMetadata ( new RelationMetadata(nameof(e_ProductCategoryID), nameof(ProductCategoryID), nameof(AdventureWorks.Production.ProductCategory.ProductCategoryID)) ); // Cache table metadata. EntityMeta <ProductSubcategory> .HasLanguageTable = false; EntityMeta <ProductSubcategory> .TableSchema = @"Production"; EntityMeta <ProductSubcategory> .TableName = @"ProductSubcategory"; EntityMeta <ProductSubcategory> .LanguageTableSchema = null; EntityMeta <ProductSubcategory> .LanguageTableName = null; }
static PurchaseOrderHeader() { // Cache field metadata. EntityMeta <PurchaseOrderHeader> .LoadColumnMetadata ( new ColumnMetadata(nameof(PurchaseOrderID), @"PurchaseOrderID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(RevisionNumber), @"RevisionNumber", DbType.Byte, isRequired : true), new ColumnMetadata(nameof(Status), @"Status", DbType.Byte, isRequired : true), new ColumnMetadata(nameof(EmployeeID), @"EmployeeID", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(VendorID), @"VendorID", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(ShipMethodID), @"ShipMethodID", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(OrderDate), @"OrderDate", DbType.DateTime, isRequired : true), new ColumnMetadata(nameof(ShipDate), @"ShipDate", DbType.DateTime, isRequired : false), new ColumnMetadata(nameof(SubTotal), @"SubTotal", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(TaxAmt), @"TaxAmt", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(Freight), @"Freight", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(TotalDue), @"TotalDue", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <PurchaseOrderHeader> .LoadRelationMetadata ( new RelationMetadata(nameof(e_EmployeeID), nameof(EmployeeID), nameof(AdventureWorks.HumanResources.Employee.BusinessEntityID)), new RelationMetadata(nameof(e_ShipMethodID), nameof(ShipMethodID), nameof(AdventureWorks.Purchasing.ShipMethod.ShipMethodID)), new RelationMetadata(nameof(e_VendorID), nameof(VendorID), nameof(AdventureWorks.Purchasing.Vendor.BusinessEntityID)) ); // Cache table metadata. EntityMeta <PurchaseOrderHeader> .HasLanguageTable = false; EntityMeta <PurchaseOrderHeader> .TableSchema = @"Purchasing"; EntityMeta <PurchaseOrderHeader> .TableName = @"PurchaseOrderHeader"; EntityMeta <PurchaseOrderHeader> .LanguageTableSchema = null; EntityMeta <PurchaseOrderHeader> .LanguageTableName = null; }
static ShipMethod() { // Cache field metadata. EntityMeta <ShipMethod> .LoadColumnMetadata ( new ColumnMetadata(nameof(ShipMethodID), @"ShipMethodID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(Name), @"Name", DbType.String, isRequired : true), new ColumnMetadata(nameof(ShipBase), @"ShipBase", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(ShipRate), @"ShipRate", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(rowguid), @"rowguid", DbType.Guid, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <ShipMethod> .LoadRelationMetadata ( null ); // Cache table metadata. EntityMeta <ShipMethod> .HasLanguageTable = false; EntityMeta <ShipMethod> .TableSchema = @"Purchasing"; EntityMeta <ShipMethod> .TableName = @"ShipMethod"; EntityMeta <ShipMethod> .LanguageTableSchema = null; EntityMeta <ShipMethod> .LanguageTableName = null; }
static ProductProductPhoto() { // Cache field metadata. EntityMeta <ProductProductPhoto> .LoadColumnMetadata ( new ColumnMetadata(nameof(ProductID), @"ProductID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(ProductPhotoID), @"ProductPhotoID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(Primary), @"Primary", DbType.Boolean, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <ProductProductPhoto> .LoadRelationMetadata ( new RelationMetadata(nameof(e_ProductID), nameof(ProductID), nameof(AdventureWorks.Production.Product.ProductID)), new RelationMetadata(nameof(e_ProductPhotoID), nameof(ProductPhotoID), nameof(AdventureWorks.Production.ProductPhoto.ProductPhotoID)) ); // Cache table metadata. EntityMeta <ProductProductPhoto> .HasLanguageTable = false; EntityMeta <ProductProductPhoto> .TableSchema = @"Production"; EntityMeta <ProductProductPhoto> .TableName = @"ProductProductPhoto"; EntityMeta <ProductProductPhoto> .LanguageTableSchema = null; EntityMeta <ProductProductPhoto> .LanguageTableName = null; }
static SalesTerritory() { // Cache field metadata. EntityMeta <SalesTerritory> .LoadColumnMetadata ( new ColumnMetadata(nameof(TerritoryID), @"TerritoryID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(Name), @"Name", DbType.String, isRequired : true), new ColumnMetadata(nameof(CountryRegionCode), @"CountryRegionCode", DbType.String, isRequired : true), new ColumnMetadata(nameof(Group), @"Group", DbType.String, isRequired : true), new ColumnMetadata(nameof(SalesYTD), @"SalesYTD", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(SalesLastYear), @"SalesLastYear", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(CostYTD), @"CostYTD", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(CostLastYear), @"CostLastYear", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(rowguid), @"rowguid", DbType.Guid, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <SalesTerritory> .LoadRelationMetadata ( new RelationMetadata(nameof(e_CountryRegionCode), nameof(CountryRegionCode), nameof(AdventureWorks.Person.CountryRegion.CountryRegionCode)) ); // Cache table metadata. EntityMeta <SalesTerritory> .HasLanguageTable = false; EntityMeta <SalesTerritory> .TableSchema = @"Sales"; EntityMeta <SalesTerritory> .TableName = @"SalesTerritory"; EntityMeta <SalesTerritory> .LanguageTableSchema = null; EntityMeta <SalesTerritory> .LanguageTableName = null; }
static ProductCostHistory() { // Cache field metadata. EntityMeta <ProductCostHistory> .LoadColumnMetadata ( new ColumnMetadata(nameof(ProductID), @"ProductID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(StartDate), @"StartDate", DbType.DateTime, isPrimaryKey : true), new ColumnMetadata(nameof(EndDate), @"EndDate", DbType.DateTime, isRequired : false), new ColumnMetadata(nameof(StandardCost), @"StandardCost", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <ProductCostHistory> .LoadRelationMetadata ( new RelationMetadata(nameof(e_ProductID), nameof(ProductID), nameof(AdventureWorks.Production.Product.ProductID)) ); // Cache table metadata. EntityMeta <ProductCostHistory> .HasLanguageTable = false; EntityMeta <ProductCostHistory> .TableSchema = @"Production"; EntityMeta <ProductCostHistory> .TableName = @"ProductCostHistory"; EntityMeta <ProductCostHistory> .LanguageTableSchema = null; EntityMeta <ProductCostHistory> .LanguageTableName = null; }
static SalesTerritoryHistory() { // Cache field metadata. EntityMeta <SalesTerritoryHistory> .LoadColumnMetadata ( new ColumnMetadata(nameof(BusinessEntityID), @"BusinessEntityID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(TerritoryID), @"TerritoryID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(StartDate), @"StartDate", DbType.DateTime, isPrimaryKey : true), new ColumnMetadata(nameof(EndDate), @"EndDate", DbType.DateTime, isRequired : false), new ColumnMetadata(nameof(rowguid), @"rowguid", DbType.Guid, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <SalesTerritoryHistory> .LoadRelationMetadata ( new RelationMetadata(nameof(e_BusinessEntityID), nameof(BusinessEntityID), nameof(AdventureWorks.Sales.SalesPerson.BusinessEntityID)), new RelationMetadata(nameof(e_TerritoryID), nameof(TerritoryID), nameof(AdventureWorks.Sales.SalesTerritory.TerritoryID)) ); // Cache table metadata. EntityMeta <SalesTerritoryHistory> .HasLanguageTable = false; EntityMeta <SalesTerritoryHistory> .TableSchema = @"Sales"; EntityMeta <SalesTerritoryHistory> .TableName = @"SalesTerritoryHistory"; EntityMeta <SalesTerritoryHistory> .LanguageTableSchema = null; EntityMeta <SalesTerritoryHistory> .LanguageTableName = null; }
static ProductVendor() { // Cache field metadata. EntityMeta <ProductVendor> .LoadColumnMetadata ( new ColumnMetadata(nameof(ProductID), @"ProductID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(BusinessEntityID), @"BusinessEntityID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(AverageLeadTime), @"AverageLeadTime", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(StandardPrice), @"StandardPrice", DbType.Decimal, isRequired : true), new ColumnMetadata(nameof(LastReceiptCost), @"LastReceiptCost", DbType.Decimal, isRequired : false), new ColumnMetadata(nameof(LastReceiptDate), @"LastReceiptDate", DbType.DateTime, isRequired : false), new ColumnMetadata(nameof(MinOrderQty), @"MinOrderQty", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(MaxOrderQty), @"MaxOrderQty", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(OnOrderQty), @"OnOrderQty", DbType.Int32, isRequired : false), new ColumnMetadata(nameof(UnitMeasureCode), @"UnitMeasureCode", DbType.StringFixedLength, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <ProductVendor> .LoadRelationMetadata ( new RelationMetadata(nameof(e_BusinessEntityID), nameof(BusinessEntityID), nameof(AdventureWorks.Purchasing.Vendor.BusinessEntityID)), new RelationMetadata(nameof(e_ProductID), nameof(ProductID), nameof(AdventureWorks.Production.Product.ProductID)), new RelationMetadata(nameof(e_UnitMeasureCode), nameof(UnitMeasureCode), nameof(AdventureWorks.Production.UnitMeasure.UnitMeasureCode)) ); // Cache table metadata. EntityMeta <ProductVendor> .HasLanguageTable = false; EntityMeta <ProductVendor> .TableSchema = @"Purchasing"; EntityMeta <ProductVendor> .TableName = @"ProductVendor"; EntityMeta <ProductVendor> .LanguageTableSchema = null; EntityMeta <ProductVendor> .LanguageTableName = null; }
static Person() { // Cache field metadata. EntityMeta <Person> .LoadColumnMetadata ( new ColumnMetadata(nameof(BusinessEntityID), @"BusinessEntityID", DbType.Int32, isPrimaryKey : true), new ColumnMetadata(nameof(PersonType), @"PersonType", DbType.StringFixedLength, isRequired : true), new ColumnMetadata(nameof(NameStyle), @"NameStyle", DbType.Boolean, isRequired : true), new ColumnMetadata(nameof(Title), @"Title", DbType.String, isRequired : false), new ColumnMetadata(nameof(FirstName), @"FirstName", DbType.String, isRequired : true), new ColumnMetadata(nameof(MiddleName), @"MiddleName", DbType.String, isRequired : false), new ColumnMetadata(nameof(LastName), @"LastName", DbType.String, isRequired : true), new ColumnMetadata(nameof(Suffix), @"Suffix", DbType.String, isRequired : false), new ColumnMetadata(nameof(EmailPromotion), @"EmailPromotion", DbType.Int32, isRequired : true), new ColumnMetadata(nameof(AdditionalContactInfo), @"AdditionalContactInfo", DbType.Xml, isRequired : false), new ColumnMetadata(nameof(Demographics), @"Demographics", DbType.Xml, isRequired : false), new ColumnMetadata(nameof(rowguid), @"rowguid", DbType.Guid, isRequired : true), new ColumnMetadata(nameof(ModifiedDate), @"ModifiedDate", DbType.DateTime, isRequired : true) ); // Cache entites metadata. EntityMeta <Person> .LoadRelationMetadata ( new RelationMetadata(nameof(e_BusinessEntityID), nameof(BusinessEntityID), nameof(AdventureWorks.Person.BusinessEntity.BusinessEntityID)) ); // Cache table metadata. EntityMeta <Person> .HasLanguageTable = false; EntityMeta <Person> .TableSchema = @"Person"; EntityMeta <Person> .TableName = @"Person"; EntityMeta <Person> .LanguageTableSchema = null; EntityMeta <Person> .LanguageTableName = null; }
static Products() { // Cache field metadata. EntityMeta <Products> .LoadColumnMetadata ( new ColumnMetadata(nameof(ProductID), @"ProductID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(ProductName), @"ProductName", DbType.String, isRequired : true), new ColumnMetadata(nameof(SupplierID), @"SupplierID", DbType.Int32, isRequired : false), new ColumnMetadata(nameof(CategoryID), @"CategoryID", DbType.Int32, isRequired : false), new ColumnMetadata(nameof(QuantityPerUnit), @"QuantityPerUnit", DbType.String, isRequired : false), new ColumnMetadata(nameof(UnitPrice), @"UnitPrice", DbType.Decimal, isRequired : false), new ColumnMetadata(nameof(UnitsInStock), @"UnitsInStock", DbType.Int16, isRequired : false), new ColumnMetadata(nameof(UnitsOnOrder), @"UnitsOnOrder", DbType.Int16, isRequired : false), new ColumnMetadata(nameof(ReorderLevel), @"ReorderLevel", DbType.Int16, isRequired : false), new ColumnMetadata(nameof(Discontinued), @"Discontinued", DbType.Boolean, isRequired : true) ); // Cache entites metadata. EntityMeta <Products> .LoadRelationMetadata ( new RelationMetadata(nameof(Categories), nameof(CategoryID), nameof(Northwind.Dbo.Categories.CategoryID)), new RelationMetadata(nameof(Suppliers), nameof(SupplierID), nameof(Northwind.Dbo.Suppliers.SupplierID)) ); // Cache table metadata. EntityMeta <Products> .HasLanguageTable = false; EntityMeta <Products> .TableSchema = @"dbo"; EntityMeta <Products> .TableName = @"Products"; EntityMeta <Products> .LanguageTableSchema = null; EntityMeta <Products> .LanguageTableName = null; }
static DatabaseLog() { // Cache field metadata. EntityMeta <DatabaseLog> .LoadColumnMetadata ( new ColumnMetadata(nameof(DatabaseLogID), @"DatabaseLogID", DbType.Int32, isIdentity : true, isPrimaryKey : true), new ColumnMetadata(nameof(PostTime), @"PostTime", DbType.DateTime, isRequired : true), new ColumnMetadata(nameof(DatabaseUser), @"DatabaseUser", DbType.String, isRequired : true), new ColumnMetadata(nameof(Event), @"Event", DbType.String, isRequired : true), new ColumnMetadata(nameof(Schema), @"Schema", DbType.String, isRequired : false), new ColumnMetadata(nameof(Object), @"Object", DbType.String, isRequired : false), new ColumnMetadata(nameof(TSQL), @"TSQL", DbType.String, isRequired : true), new ColumnMetadata(nameof(XmlEvent), @"XmlEvent", DbType.Xml, isRequired : true) ); // Cache entites metadata. EntityMeta <DatabaseLog> .LoadRelationMetadata ( null ); // Cache table metadata. EntityMeta <DatabaseLog> .HasLanguageTable = false; EntityMeta <DatabaseLog> .TableSchema = @"dbo"; EntityMeta <DatabaseLog> .TableName = @"DatabaseLog"; EntityMeta <DatabaseLog> .LanguageTableSchema = null; EntityMeta <DatabaseLog> .LanguageTableName = null; }