/// <summary>
/// Maps the AmpPages items.
/// </summary>
/// <param name="mappings">The mappings.</param>
private void MapAmpPageses(List <MappingConfiguration> mappings)
{
var mapping = new MappingConfiguration <AmpPage>();
mapping.MapType(p => new { }).SetTableName("AMP_AmpPages", this.Context);
mapping.HasProperty(p => p.Id).IsIdentity().IsNotNullable();
mapping.HasProperty(p => p.Title).IsNotNullable().IsText(this.Context, 255);
mapping.HasProperty(p => p.ItemType).IsText(this.Context, 255);
mapping.HasProperty(p => p.UrlName).IsText(this.Context, 255);
mapping.HasProperty(p => p.PageId);
mapping.HasProperty(p => p.FieldsListJson).IsNullable().WithInfiniteLength();
mapping.HasProperty(p => p.ApplicationName);
mapping.HasProperty(p => p.LastModified);
mapping.HasProperty(p => p.DateCreated);
mapping.HasProperty(p => p.LayoutTemplatePath).IsText(this.Context, 255);
mapping.HasProperty(p => p.TemplatePath).IsText(this.Context, 255);
mapping.HasProperty(p => p.PageUrl).IsText(this.Context);
mapping.HasIndex(p => p.Title).IsUnique().WithName("idx_title");
mapping.HasIndex(p => p.UrlName).IsUnique().WithName("idx_urlName");
mapping.HasIndex(p => p.PageId).IsUnique().WithName("idx_pageId");
mappings.Add(mapping);
}
/// <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");
fileDataMapping.HasIndex(p => new { p.FilePath }).IsUnique().WithName("idx_sf_fls_mntr_dta_path");
mappings.Add(fileDataMapping);
}
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 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);
}
