예제 #1
0
        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;
        }
예제 #2
0
        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;
        }
예제 #4
0
        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;
        }
예제 #5
0
        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;
        }
예제 #6
0
        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;
        }
예제 #7
0
        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;
        }
예제 #8
0
        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;
        }
예제 #9
0
        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;
        }
예제 #10
0
        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;
        }
예제 #11
0
        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;
        }
예제 #12
0
        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;
        }
예제 #14
0
        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;
        }
예제 #15
0
        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;
        }
예제 #16
0
        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;
        }
예제 #19
0
        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;
        }
예제 #22
0
        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;
        }
예제 #23
0
        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;
        }
예제 #24
0
        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;
        }
예제 #25
0
        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;
        }
예제 #26
0
        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;
        }
예제 #27
0
        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;
        }
예제 #28
0
        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;
        }
예제 #29
0
        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;
        }
예제 #30
0
        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;
        }