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