protected override IList<MappingConfiguration> PrepareMapping() { List<MappingConfiguration> configurations = new List<MappingConfiguration>(); var saleMapping = new MappingConfiguration<Sale>(); saleMapping.MapType(sale => new { ID = sale.Id, Dish = sale.Dish, Quantity = sale.Quantity, Month = sale.Month, Year = sale.Year }).ToTable("Sale"); saleMapping.HasProperty(s => s.Id).IsIdentity(); configurations.Add(saleMapping); var dishReportMapping = new MappingConfiguration<DishReport>(); dishReportMapping.MapType(report => new { Month = report.Month, DeliveredPrice = report.DeliveredPrice, SoldPrice = report.SoldPrice, Code = report.Code, }).ToTable("DishReport"); saleMapping.HasProperty(s => s.Id).IsIdentity(); configurations.Add(dishReportMapping); return configurations; }
public void PrepareRentalRatePropertyConfigurations(MappingConfiguration <RentalRate> configuration) { configuration.HasProperty(x => x.RentalRateID). IsIdentity(KeyGenerator.Autoinc). HasFieldName("_rentalRateID"). WithDataAccessKind(DataAccessKind.ReadWrite). ToColumn("RentalRateID").IsNotNullable(). HasColumnType("int").HasPrecision(0).HasScale(0); configuration.HasProperty(x => x.CategoryID). HasFieldName("_categoryID"). WithDataAccessKind(DataAccessKind.ReadWrite). ToColumn("CategoryID").IsNullable(). HasColumnType("int").HasPrecision(0).HasScale(0); configuration.HasProperty(x => x.Daily). HasFieldName("_daily"). WithDataAccessKind(DataAccessKind.ReadWrite). ToColumn("Daily").IsNullable(). HasColumnType("smallmoney").HasPrecision(0).HasScale(0); configuration.HasProperty(x => x.Weekly). HasFieldName("_weekly"). WithDataAccessKind(DataAccessKind.ReadWrite). ToColumn("Weekly").IsNullable(). HasColumnType("smallmoney").HasPrecision(0).HasScale(0); configuration.HasProperty(x => x.Monthly). HasFieldName("_monthly"). WithDataAccessKind(DataAccessKind.ReadWrite). ToColumn("Monthly").IsNullable(). HasColumnType("smallmoney").HasPrecision(0).HasScale(0); }
private MappingConfiguration UserMapping() { var mapping = new MappingConfiguration <User>(); mapping.MapType() .ToTable("User"); mapping.HasProperty(m => m.Id) .IsIdentity(KeyGenerator.Autoinc); mapping.HasProperty(m => m.IsActive) .HasColumnType("bit"); mapping.HasAssociation(m => m.Things) .WithOpposite(m => m.AssignedToUser) .IsManaged() .ToColumn("AssignedToUserId"); mapping.HasAssociation(m => m.StarredThings) .MapJoinTable("UserStarredThings", (u, t) => new { UserId = u.Id, ThingId = t.Id }).CreatePrimaryKeyFromForeignKeys(); mapping.HasAssociation(m => m.Teams) .WithOpposite(t => t.User) .IsManaged() .IsDependent() .ToColumn("UserId"); return(mapping); }
public void PrepareDataAccessIncomePropertyConfigurations(MappingConfiguration<DataAccessIncome> configuration) { configuration.HasProperty(x => x.Id) .IsIdentity(KeyGenerator.Autoinc) .HasFieldName("id") .WithDataAccessKind(DataAccessKind.ReadWrite) .ToColumn("Id") .IsNotNullable() .HasColumnType("integer") .HasPrecision(0) .HasScale(0); configuration.HasProperty(x => x.DealerId) .HasFieldName("dealerId") .WithDataAccessKind(DataAccessKind.ReadWrite) .ToColumn("DealerId") .IsNotNullable() .HasColumnType("integer") .HasPrecision(0) .HasScale(0); configuration.HasProperty(x => x.Date) .HasFieldName("date") .WithDataAccessKind(DataAccessKind.ReadWrite) .ToColumn("Date") .IsNotNullable() .HasColumnType("datetime"); configuration.HasProperty(x => x.Amount) .HasFieldName("amount") .WithDataAccessKind(DataAccessKind.ReadWrite) .ToColumn("Amount") .IsNotNullable() .HasColumnType("decimal") .HasPrecision(18) .HasScale(2); }
private MappingConfiguration TeamMapping() { var mapping = new MappingConfiguration<Team>(); mapping.MapType() .ToTable("Team"); mapping.HasProperty(m => m.Id) .IsIdentity(KeyGenerator.Autoinc); mapping.HasProperty(m => m.IsOpen) .HasColumnType("bit"); mapping.HasAssociation(m => m.Owner) .IsManaged() .ToColumn("OwnerId"); mapping.HasAssociation(m => m.Things) .IsManaged() .ToColumn("TeamId"); mapping.HasAssociation(m => m.Members) .WithOpposite(t => t.Team) .IsManaged() .IsDependent() .ToColumn("TeamId"); return mapping; }
private MappingConfiguration TeamMapping() { var mapping = new MappingConfiguration <Team>(); mapping.MapType() .ToTable("Team"); mapping.HasProperty(m => m.Id) .IsIdentity(KeyGenerator.Autoinc); mapping.HasProperty(m => m.IsOpen) .HasColumnType("bit"); mapping.HasAssociation(m => m.Owner) .IsManaged() .ToColumn("OwnerId"); mapping.HasAssociation(m => m.TeamThings) .IsManaged() .ToColumn("TeamId"); mapping.HasAssociation(m => m.TeamMembers) .WithOpposite(t => t.Team) .IsManaged() .IsDependent() .ToColumn("TeamId"); return(mapping); }
public void PrepareTeamPropertyConfigurations(MappingConfiguration <Team> configuration) { configuration.HasProperty(x => x.TeamId).IsIdentity().HasFieldName("_teamId").WithDataAccessKind(DataAccessKind.ReadWrite); configuration.HasProperty(x => x.TeamMembers).HasFieldName("_teamMembers").WithDataAccessKind(DataAccessKind.ReadWrite); configuration.HasProperty(x => x.TeamName).HasFieldName("_teamName").WithDataAccessKind(DataAccessKind.ReadWrite); configuration.HasProperty(x => x.IsEnabled).HasFieldName("_isEnabled").WithDataAccessKind(DataAccessKind.ReadWrite); }
public void PrepareTeamPropertyConfigurations(MappingConfiguration<Team> configuration) { configuration.HasProperty(x => x.TeamId).IsIdentity().HasFieldName("_teamId").WithDataAccessKind(DataAccessKind.ReadWrite); configuration.HasProperty(x => x.TeamMembers).HasFieldName("_teamMembers").WithDataAccessKind(DataAccessKind.ReadWrite); configuration.HasProperty(x => x.TeamName).HasFieldName("_teamName").WithDataAccessKind(DataAccessKind.ReadWrite); configuration.HasProperty(x => x.IsEnabled).HasFieldName("_isEnabled").WithDataAccessKind(DataAccessKind.ReadWrite); }
private MappingConfiguration ThingMapping() { var mapping = new MappingConfiguration <Thing>(); mapping.MapType() .ToTable("Thing"); mapping.HasProperty(m => m.Id) .IsIdentity(KeyGenerator.Autoinc); mapping.HasProperty(m => m.IsDeleted) .HasColumnType("bit"); mapping.HasAssociation(m => m.AssignedTo) .WithOpposite(t => t.Thing) .IsManaged() .IsDependent(); mapping.HasAssociation(m => m.Owner) .IsManaged() .ToColumn("OwnerId"); mapping.HasAssociation(m => m.Team) .WithOpposite(m => m.TeamThings) .ToColumn("TeamId"); mapping.HasProperty(m => m.Status) .HasColumnType("varchar") .HasPrecision(25) .WithConverter <EnumToStringConverter <ThingStatus> >(); return(mapping); }
public void PreparePositionPropertyConfigurations(MappingConfiguration<Position> configuration) { configuration.HasProperty(x => x.Id).IsIdentity(KeyGenerator.Autoinc); configuration.HasProperty(x => x.HeaderId); configuration.HasProperty(x => x.Description); configuration.HasProperty(x => x.SequenceNumber); configuration.HasProperty(x => x.DateCreated); configuration.HasProperty(x => x.DateModified); }
public void PrepareVRTileconfigsetConfigurations(MappingConfiguration <VRTileconfigset> configuration) { configuration.HasProperty(x => x.ID).ToColumn(@"ID").IsIdentity(KeyGenerator.Autoinc).WithOpenAccessType(OpenAccessType.Int32).IsNotNullable().HasPrecision(11); configuration.HasProperty(x => x.Name).ToColumn(@"Name").WithOpenAccessType(OpenAccessType.Clob).IsNullable().IsUnicode(); configuration.HasProperty(x => x.IsDeleted).ToColumn(@"IsDeleted").WithOpenAccessType(OpenAccessType.Boolean).IsNotNullable(); configuration.HasAssociation <VRClient>(x => x.Clients).WithOpposite(op => op.Tileconfigset).HasConstraint((x, y) => x.ID == y.TileConfigSetID); configuration.HasAssociation <VRTileconfig>(x => x.Tileconfigs).WithOpposite(op => op.Tileconfigset).HasConstraint((x, y) => x.ID == y.TileConfigSetID); }
public void PrepareRentalRatePropertyConfigurations(MappingConfiguration<RentalRate> configuration) { configuration.HasProperty(x => x.RentalRateID).IsIdentity(KeyGenerator.Autoinc).HasFieldName("_rentalRateID").WithDataAccessKind(DataAccessKind.ReadWrite).ToColumn("RentalRateID").IsNotNullable().HasColumnType("int").HasPrecision(0).HasScale(0); configuration.HasProperty(x => x.CategoryID).HasFieldName("_categoryID").WithDataAccessKind(DataAccessKind.ReadWrite).ToColumn("CategoryID").IsNullable().HasColumnType("int").HasPrecision(0).HasScale(0); configuration.HasProperty(x => x.Daily).HasFieldName("_daily").WithDataAccessKind(DataAccessKind.ReadWrite).ToColumn("Daily").IsNullable().HasColumnType("smallmoney").HasPrecision(0).HasScale(0); configuration.HasProperty(x => x.Weekly).HasFieldName("_weekly").WithDataAccessKind(DataAccessKind.ReadWrite).ToColumn("Weekly").IsNullable().HasColumnType("smallmoney").HasPrecision(0).HasScale(0); configuration.HasProperty(x => x.Monthly).HasFieldName("_monthly").WithDataAccessKind(DataAccessKind.ReadWrite).ToColumn("Monthly").IsNullable().HasColumnType("smallmoney").HasPrecision(0).HasScale(0); }
public static MappingConfiguration <ProtokolSprzedazy> PobierzMapping() { var customerMapping = new MappingConfiguration <ProtokolSprzedazy>(); customerMapping.MapType(); MapujPropercjeBazowe(customerMapping); customerMapping.HasProperty(x => x.Nazwa).HasLength(RozmiarNazwy); customerMapping.HasProperty(x => x.Opis).WithInfiniteLength(); return(customerMapping); }
public static MappingConfiguration <OperacjaGospodarczaElement> PobierzMapping() { var customerMapping = new MappingConfiguration <OperacjaGospodarczaElement>(); customerMapping.MapType(); MapujPropercjeBazowe(customerMapping); customerMapping.HasProperty(x => x.Nazwa).HasLength(RozmiarNazwy); customerMapping.HasProperty(x => x.Tresc).WithInfiniteLength(); return(customerMapping); }
public static MappingConfiguration <EMailKonto> PobierzMapping() { var customerMapping = new MappingConfiguration <EMailKonto>(); customerMapping.MapType(); MapujPropercjeBazowe(customerMapping); customerMapping.HasProperty(x => x.Przywitanie).WithInfiniteLength(); customerMapping.HasProperty(x => x.Stopka).WithInfiniteLength(); return(customerMapping); }
/// <summary> /// Maps the file data. /// </summary> /// <param name="mappings">The mappings.</param> private void MapFileData(List<MappingConfiguration> mappings) { var fileDataMapping = new MappingConfiguration<FileData>(); fileDataMapping.MapType(p => new { }).WithConcurencyControl(OptimisticConcurrencyControlStrategy.None).ToTable("sf_files_monitor_data"); fileDataMapping.HasProperty(p => p.Id).IsIdentity(); fileDataMapping.HasProperty(p => p.FileName).ToColumn("file_name"); fileDataMapping.HasProperty(p => p.FilePath).ToColumn("file_path"); fileDataMapping.HasProperty(p => p.PackageName).ToColumn("package_name"); mappings.Add(fileDataMapping); }
private MappingConfiguration <AQCIMRCMD> GetAQCIMRCMDMappingConfiguration() { MappingConfiguration <AQCIMRCMD> configuration = new MappingConfiguration <AQCIMRCMD>(); configuration.MapType().ToTable(typeof(AQCIMRCMD).Name); configuration.HasProperty(x => x.Code).IsIdentity().HasColumnType("nvarchar").HasLength(16); configuration.HasProperty(x => x.Time).IsIdentity(); configuration.HasProperty(x => x.PrimaryPollutant).HasColumnType("nvarchar").HasLength(64); return(configuration); }
/// <summary> /// Maps the file data. /// </summary> /// <param name="mappings">The mappings.</param> private void MapFileData(List <MappingConfiguration> mappings) { var fileDataMapping = new MappingConfiguration <FileData>(); fileDataMapping.MapType(p => new { }).WithConcurencyControl(OptimisticConcurrencyControlStrategy.None).ToTable("sf_files_monitor_data"); fileDataMapping.HasProperty(p => p.Id).IsIdentity(); fileDataMapping.HasProperty(p => p.FileName).ToColumn("file_name"); fileDataMapping.HasProperty(p => p.FilePath).ToColumn("file_path"); fileDataMapping.HasProperty(p => p.PackageName).ToColumn("package_name"); mappings.Add(fileDataMapping); }
public static MappingConfiguration <WiadomoscSms> PobierzMapping() { var customerMapping = new MappingConfiguration <WiadomoscSms>(); customerMapping.MapType(); MapujPropercjeBazowe(customerMapping); customerMapping.HasProperty(x => x.Tresc).HasLength(RozmiarNazwy); customerMapping.HasProperty(x => x.StatusTekstowy).WithInfiniteLength(); customerMapping.HasAssociation(u => u.SmsKonto) .WithOpposite(p => p.Wiadomosci) .HasConstraint((u, p) => u.SmsKontoId == p.Id); return(customerMapping); }
protected override IList <MappingConfiguration> PrepareMapping() { List <MappingConfiguration> configurations = new List <MappingConfiguration>(); MappingConfiguration <Report> reportConfiguration = new MappingConfiguration <Report>(); reportConfiguration.MapType(x => new { ID = x.Id, Name = x.Name, Duration = x.Duration, Destination = x.Destination, ClientsCount = x.ClientsCount, TotalIncome = x.TotalIncome, TransportCompany = x.TransportCompany, TransportType = x.TransportType, GuideName = x.GuideName, ExpenseId = x.ExpenseId }).ToTable("Reports"); reportConfiguration.HasProperty(p => p.Id).IsIdentity(KeyGenerator.Autoinc); configurations.Add(reportConfiguration); return(configurations); }
private MappingConfiguration<Question> CreateQuestionMapping() { MappingConfiguration<Question> questionMapping = new MappingConfiguration<Question>(); questionMapping.MapType(question => new { QuestionId = question.Id, QueryText = question.QueryText, PostedById = question.PostedById }) .ToTable("Questions"); questionMapping.HasProperty(q => q.Id).IsIdentity(); questionMapping.HasAssociation(q => q.PostedBy) .WithOpposite(u => u.CreatedQuestions) .HasConstraint((q, u) => q.PostedById == u.Id); questionMapping.HasAssociation(q => q.UsersThatVoted) .WithOpposite(u => u.VotedOnQuestions) .IsManaged() .MapJoinTable("QuestionsUsers", (q, u) => new { QuestionGuid = q.Id, UserGuid = u.Id }); questionMapping.HasAssociation(q => q.Answers) .WithOpposite(a => a.Question) .HasConstraint((q, a) => q.Id == a.QuestionId) .IsManaged(); return questionMapping; }
protected override IList<MappingConfiguration> PrepareMapping() { List<MappingConfiguration> configurations = new List<MappingConfiguration>(); MappingConfiguration<Report> reportConfiguration = new MappingConfiguration<Report>(); reportConfiguration.MapType(x => new { ID = x.Id, Name = x.Name, Duration = x.Duration, Destination = x.Destination, ClientsCount = x.ClientsCount, TotalIncome = x.TotalIncome, TransportCompany = x.TransportCompany, TransportType = x.TransportType, GuideName = x.GuideName, ExpenseId = x.ExpenseId }).ToTable("Reports"); reportConfiguration.HasProperty(p => p.Id).IsIdentity(KeyGenerator.Autoinc); configurations.Add(reportConfiguration); return configurations; }
public void PrepareDataAccessCountryPropertyConfigurations(MappingConfiguration<DataAccessCountry> configuration) { configuration.HasProperty(x => x.Id) .IsIdentity(KeyGenerator.Autoinc) .HasFieldName("id") .WithDataAccessKind(DataAccessKind.ReadWrite) .ToColumn("Id") .IsNotNullable() .HasColumnType("integer") .HasPrecision(0) .HasScale(0); configuration.HasProperty(x => x.Name) .HasFieldName("name") .WithDataAccessKind(DataAccessKind.ReadWrite) .ToColumn("Name") .IsNullable() .HasColumnType("longtext") .HasLength(0); configuration.HasProperty(x => x.Region) .HasFieldName("region") .WithDataAccessKind(DataAccessKind.ReadWrite) .ToColumn("Region") .IsNotNullable() .HasColumnType("integer") .HasPrecision(0) .HasScale(0); }
public static MappingConfiguration GetMapping() { var mapping = new MappingConfiguration<Instance>(); mapping.MapType().ToTable("Instances"); mapping.HasProperty(p => p.SurrogateInstanceId).IsIdentity(KeyGenerator.Autoinc); mapping.HasProperty(p => p.PrimitiveDataProperties).WithInfiniteLength().IsNullable(); mapping.HasProperty(p => p.ComplexDataProperties).WithInfiniteLength().IsNullable(); mapping.HasProperty(p => p.WriteOnlyPrimitiveDataProperties).WithInfiniteLength().IsNullable(); mapping.HasProperty(p => p.WriteOnlyComplexDataProperties).WithInfiniteLength().IsNullable(); mapping.HasProperty(p => p.MetadataProperties).WithInfiniteLength().IsNullable(); mapping.HasProperty(p => p.SuspensionExceptionName).WithVariableLength(450).IsNullable().IsUnicode(); mapping.HasProperty(p => p.SuspensionReason).WithInfiniteLength().IsUnicode().IsNullable(); mapping.HasProperty(p => p.BlockingBookmarks).WithInfiniteLength().IsUnicode().IsNullable(); mapping.HasProperty(p => p.LastMachineRunOn).WithVariableLength(450).IsUnicode().IsNullable(); return mapping; }
private void MapItem(IList<MappingConfiguration> mappings) { var itemMapping = new MappingConfiguration<ProductItem>(); itemMapping.HasProperty(p => p.Id).IsIdentity(); itemMapping.MapType(p => new { }).ToTable("custom_products"); itemMapping.HasProperty(p => p.Price); itemMapping.HasProperty(p => p.QuantityInStock); itemMapping.HasAssociation<Telerik.Sitefinity.Security.Model.Permission>(p => p.Permissions); itemMapping.HasProperty(p => p.InheritsPermissions); itemMapping.HasProperty(p => p.CanInheritPermissions); itemMapping.HasAssociation(p => p.Urls).WithOppositeMember("parent","Parent").ToColumn("content_id").IsDependent().IsManaged(); //map language data & published translations CommonFluentMapping.MapILifecycleDataItemFields<ProductItem>(itemMapping, this.Context); mappings.Add(itemMapping); }
private void MapItem(IList <MappingConfiguration> mappings) { var itemMapping = new MappingConfiguration <ProductItem>(); itemMapping.HasProperty(p => p.Id).IsIdentity(); itemMapping.MapType(p => new { }).ToTable("custom_products"); itemMapping.HasProperty(p => p.Price); itemMapping.HasProperty(p => p.QuantityInStock); itemMapping.HasAssociation <Telerik.Sitefinity.Security.Model.Permission>(p => p.Permissions); itemMapping.HasProperty(p => p.InheritsPermissions); itemMapping.HasProperty(p => p.CanInheritPermissions); itemMapping.HasAssociation(p => p.Urls).WithOppositeMember("parent", "Parent").ToColumn("content_id").IsDependent().IsManaged(); //map language data & published translations CommonFluentMapping.MapILifecycleDataItemFields <ProductItem>(itemMapping, this.Context); mappings.Add(itemMapping); }
private static MappingConfiguration<Category> GetCategoryMapping() { MappingConfiguration<Category> result = new MappingConfiguration<Category>(); result.MapType(x => new { CategoryID = x.Id, CategoryName = x.Name, Description = x.Description }). ToTable("Categories"); result.HasProperty(x => x.Id).IsIdentity(KeyGenerator.Autoinc); result.HasProperty(x => x.Name).WithFixedLength(50); result.HasProperty(x => x.Description).WithInfiniteLength(); result.HasIndex(x => x.Name).WithName("IX_Category").IsUnique(); return result; }
private MappingConfiguration<Group> PrepareGroupMappingConfig() { MappingConfiguration<Group> groupMappingConfig = new MappingConfiguration<Group>(); groupMappingConfig.MapType().ToTable("Groups"); //backend independent property mapping groupMappingConfig.HasProperty(grp => grp.GroupId).IsIdentity().WithOpenAccessType(OpenAccessType.Int32).ToColumn("GroupId"); groupMappingConfig.HasProperty(grp => grp.Name).WithOpenAccessType(OpenAccessType.StringInfiniteLength).ToColumn("Name"); groupMappingConfig.HasProperty(grp => grp.Description).WithOpenAccessType(OpenAccessType.StringInfiniteLength).ToColumn("Description"); groupMappingConfig.HasAssociation(grp => grp.UsersInGroup) .WithOpposite(usr => usr.Group) .HasConstraint((grp, usr) => grp.GroupId == usr.GroupId) .IsManaged(); return groupMappingConfig; }
private MappingConfiguration<IdentityRole> CreateIdentityRoleMapping() { MappingConfiguration<IdentityRole> identityRoleMapping = new MappingConfiguration<IdentityRole>(); identityRoleMapping.MapType(role => new { id = role.Id, Name = role.Name }).ToTable("IdentityRoles"); identityRoleMapping.HasProperty(x => x.Id).IsIdentity(); return identityRoleMapping; }
private MappingConfiguration<IdentityUser> CraeteIdentityUserMapping() { MappingConfiguration<IdentityUser> identityUserMapping = new MappingConfiguration<IdentityUser>(); identityUserMapping.MapType(user => new { Id = user.Id, Name = user.UserName, PasswordHash = user.PasswordHash }).ToTable("IdentityUsers"); identityUserMapping.HasProperty(x => x.Id).IsIdentity(); return identityUserMapping; }
public void PrepareHeaderPropertyConfigurations(MappingConfiguration<Header> configuration) { configuration.HasProperty(x => x.Id); configuration.HasProperty(x => x.Title); configuration.HasProperty(x => x.IsChecked); configuration.HasProperty(x => x.Status); configuration.HasProperty(x => x.DateCreated); configuration.HasProperty(x => x.DateModified); }
private MappingConfiguration<CLASSNAME> GetTable() { MappingConfiguration<Position> configuration = new MappingConfiguration<CLASSNAME>(); configuration.MapType() .Inheritance(Telerik.OpenAccess.InheritanceStrategy.Flat) .WithConcurencyControl(OptimisticConcurrencyControlStrategy.Version); configuration.HasProperty(x => x.Id).IsIdentity(KeyGenerator.Autoinc); //configuration.HasIndex(x => new { // x.Price, // x.ProductName //}).IsUnique() //.IsClustered() return configuration; }
protected override IList<MappingConfiguration> PrepareMapping() { List<MappingConfiguration> configurations = new List<MappingConfiguration>(); var stefan = new MappingConfiguration<Stefan>(); stefan.MapType(s => new { ID = s.StefanID, Name = s.Name, }).ToTable("Stefan"); stefan.HasProperty(s => s.StefanID).IsIdentity(); configurations.Add(stefan); return configurations; }
protected override IList<MappingConfiguration> PrepareMapping() { IList<MappingConfiguration> result = new List<MappingConfiguration>(); MappingConfiguration<Category> productConfiguration = new MappingConfiguration<Category>(); productConfiguration.MapType(x => new { CategoryId = x.Id, CategoryName = x.Name, Description = x.Description }).ToTable("Categories"); productConfiguration.HasProperty(x => x.Id).IsIdentity(KeyGenerator.Autoinc); result.Add(productConfiguration); return result; }
protected override IList<MappingConfiguration> PrepareMapping() { List<MappingConfiguration> configurations = new List<MappingConfiguration>(); var modelMapping = new MappingConfiguration<MakersProfit>(); modelMapping.MapType(r => new { Id = r.MakerId, Name = r.MakerName, Profit = r.Profit }).ToTable("Reports"); modelMapping.HasProperty(r => r.MakerId).IsIdentity(); configurations.Add(modelMapping); return configurations; }
protected override IList<MappingConfiguration> PrepareMapping() { List<MappingConfiguration> configurations = new List<MappingConfiguration>(); var salesMapping = new MappingConfiguration<SalesTotalCostReport>(); salesMapping.MapType(report => new { Id = report.Id, Name = report.Name, TotalCost = report.TotalCost, }).ToTable("Sales"); salesMapping.HasProperty(c => c.Id).IsIdentity(); configurations.Add(salesMapping); return configurations; }
protected override IList<MappingConfiguration> PrepareMapping() { List<MappingConfiguration> configurations = new List<MappingConfiguration>(); var mediaMapping = new MappingConfiguration<MySqlMediaModel>(); mediaMapping.MapType(m => new { Id = m.Id, Name = m.Name, Distributor = m.Distributor, TotalSells = m.TotalSells, Incomes = m.Incomes }).ToTable("Packages"); mediaMapping.HasProperty(p => p.Id).IsIdentity(KeyGenerator.Autoinc); configurations.Add(mediaMapping); return configurations; }
protected override IList<MappingConfiguration> PrepareMapping() { List<MappingConfiguration> configurations = new List<MappingConfiguration>(); var weaponMapping = new MappingConfiguration<WeaponReport>(); weaponMapping.MapType(wr => new { Id = wr.weaponId, Name = wr.weaponName, EmailAddress = wr.manufacturer, }).ToTable("Weapon Reports"); weaponMapping.HasProperty(c => c.weaponId).IsIdentity(); configurations.Add(weaponMapping); return configurations; }
protected override IList<MappingConfiguration> PrepareMapping() { List<MappingConfiguration> configurations = new List<MappingConfiguration>(); var report = new MappingConfiguration<Report>(); report.MapType(r => new { ReportID = r.ReportId, StoreName = r.StoreName, ProductName = r.ProductName, Quantity = r.Quantity, Price = r.Price, Sun = r.Sum, }).ToTable("Report"); report.HasProperty(r => r.ReportId).IsIdentity(); configurations.Add(report); return configurations; }
/// <summary> /// prepare for mapping /// </summary> /// <returns>configuration to map</returns> protected override IList<MappingConfiguration> PrepareMapping() { List<MappingConfiguration> configurations = new List<MappingConfiguration>(); var mySqlMapping = new MappingConfiguration<MonthlyNumberOfContracts>(); mySqlMapping.MapType(report => new { Id = report.Id, Date = report.Date, NumberOfContracts = report.NumberOfContracts }).ToTable("MySql"); mySqlMapping.HasProperty(c => c.Id).IsIdentity(KeyGenerator.Autoinc); configurations.Add(mySqlMapping); return configurations; }
protected override IList<MappingConfiguration> PrepareMapping() { List<MappingConfiguration> configurations = new List<MappingConfiguration>(); var reportsMapping = new MappingConfiguration<ProductReport>(); reportsMapping.MapType(sale => new { MedicamentId = sale.MedicamentId, MedicamentName = sale.MedicamentName, VendorName = sale.ManufacturerName, Quantity = sale.Quantity, Income = sale.Income }).ToTable("Reports"); reportsMapping.HasProperty(c => c.MedicamentId).IsIdentity(KeyGenerator.HighLow); configurations.Add(reportsMapping); return configurations; }
protected override IList<MappingConfiguration> PrepareMapping() { // Getting Started with the Fluent Mapping API // http://documentation.telerik.com/openaccess-orm/developers-guide/code-only-mapping/fluent-mapping-overview List<MappingConfiguration> configurations = new List<MappingConfiguration>(); MappingConfiguration<Product> productConfiguration = new MappingConfiguration<Product>(); productConfiguration.MapType(x => new { ID = x.ID, Price = x.Price, ProductName = x.ProductName }).ToTable("Products"); productConfiguration.HasProperty(x => x.ID).IsIdentity(KeyGenerator.Autoinc); configurations.Add(productConfiguration); return configurations; }
protected override IList<MappingConfiguration> PrepareMapping() { List<MappingConfiguration> mappingConfigurations = new List<MappingConfiguration>(); MappingConfiguration<Vendor> vendorConfiguration = new MappingConfiguration<Vendor>(); vendorConfiguration.MapType(v => new { VendorId = v.Id, VendorName = v.Name, }).ToTable("Vendors"); vendorConfiguration.HasProperty(v => v.Id).IsIdentity(); MappingConfiguration<Measure>measureConfiguration = new MappingConfiguration<Measure>(); measureConfiguration.MapType(m => new { MeasureId = m.Id, MeasureName = m.Name, }).ToTable("Measures"); measureConfiguration.HasProperty(m => m.Id).IsIdentity(); MappingConfiguration<Product> productConfiguration = new MappingConfiguration<Product>(); productConfiguration.MapType(p => new { ProductId = p.Id, ProductName = p.Name, VendorId=p.VendorId, MeasureId=p.MeasureId, BasePrice=p.BasePrice }).ToTable("Products"); productConfiguration.HasProperty(p => p.Id).IsIdentity(); productConfiguration.HasAssociation(p => p.Vendor).ToColumn("VendorId"); productConfiguration.HasAssociation(p => p.Measure).ToColumn("MeasureId"); mappingConfigurations.Add(productConfiguration); mappingConfigurations.Add(vendorConfiguration); mappingConfigurations.Add(measureConfiguration); return mappingConfigurations; }
protected override IList<MappingConfiguration> PrepareMapping() { List<MappingConfiguration> configurations = new List<MappingConfiguration>(); var salesMapping = new MappingConfiguration<SalesReport>(); salesMapping.HasProperty(c => c.Id).IsIdentity(KeyGenerator.Autoinc); salesMapping.MapType(report => new { // Id = report.Id, Town = report.Town, Date = report.Date, LaptopId = report.LaptopId, Quantity = report.Quantity, Sum = report.Sum }).ToTable("sales"); configurations.Add(salesMapping); return configurations; }