protected override void OnModelCreating(System.Data.Entity.ModelConfiguration.ModelBuilder modelBuilder)
{
modelBuilder.Entity <Dinner>().HasMany(r => r.Meals);
modelBuilder.Entity <User>().HasMany(r => r.Roles);
modelBuilder.Entity <Vendor>().HasMany(r => r.Coupons);
base.OnModelCreating(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.ModelConfiguration.ModelBuilder modelBuilder)
{
// If you don't want to create and use EdmMetadata table
// for monitoring the correspondence
// between the current model and table structure
// created in a database, then turn off IncludeMetadataConvention:
modelBuilder.Conventions.Remove <IncludeMetadataConvention>();
modelBuilder.Conventions.Add(new TableSchemaConvention());
base.OnModelCreating(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.ModelConfiguration.ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity <User>()
.HasRequired(r => r.Role)
.WithMany()
.HasForeignKey(r => r.RoleId);
modelBuilder.Entity <Right>()
.HasRequired(r => r.Role)
.WithMany()
.HasForeignKey(r => r.RoleId);
}
protected override void OnModelCreating(System.Data.Entity.ModelConfiguration.ModelBuilder modelBuilder)
{
modelBuilder.Entity <ReduxItem>().MapSingleType(item => new
{
id = item.id,
programme_name = item.programme_name,
short_description = item.short_description,
duration = item.duration,
service_id = item.service_id,
aired = item.aired,
disk_reference = item.disk_reference,
programme_crid = item.programme_crid,
series_crid = item.series_crid
}).ToTable("redux_items");
modelBuilder.Entity <ReduxItem>().HasKey(i => i.id);
modelBuilder.Entity <ReduxToPips>().MapSingleType(item => new
{
redux_id = item.redux_id,
pips_id = item.pips_id,
ischecked = item.ischecked,
title_match = item.title_match,
duration_match = item.duration_match,
start_match = item.start_match,
partial_match = item.partial_match
}).ToTable("redux_to_pips");
modelBuilder.Entity <ReduxToPips>().HasKey(i => i.redux_id);
modelBuilder.Entity <PipsProgramme>().MapSingleType(item => new
{
id = item.id,
programme_name = item.programme_name,
display_title = item.display_title,
display_subtitle = item.display_subtitle,
start_time = item.start_time,
end_time = item.end_time,
duration = item.duration,
pid = item.pid,
service_id = item.service_id,
service_name = item.service_name,
description = item.description,
matched = item.matched,
rawdata = item.rawdata,
start_gmt = item.start_gmt,
end_gmt = item.end_gmt
}).ToTable("pips_programmes");
modelBuilder.Entity <PipsProgramme>().HasKey(i => i.id);
//modelBuilder.Entity<Scanned>().MapSingleType(s => new
// {
// date_scanned = s.DateScanned
// }).ToTable("scanned");
//modelBuilder.Entity<Scanned>().HasKey(s => s.DateScanned);
//modelBuilder.Entity<TestItem>().MapSingleType().ToTable("test");
//modelBuilder.Entity<TestItem>().HasKey(s => s.programme_id);
modelBuilder.Entity <Gap>().MapSingleType(s => new
{
id = s.id,
programme_id = s.pips_id,
service_id = s.service_id,
gapstart = s.gapstart,
gapend = s.gapend
}).ToTable("gaps");
modelBuilder.Entity <Gap>().HasKey(g => g.id);
modelBuilder.Entity <PartialScheduleMatch>().MapSingleType(s => new
{
id = s.id,
redux_id = s.redux_id,
pips_id = s.pips_id,
overlap = s.overlap
}).ToTable("partialschedulematch");
modelBuilder.Entity <PartialScheduleMatch>().HasKey(p => p.id);
}
protected override void OnModelCreating(System.Data.Entity.ModelConfiguration.ModelBuilder modelBuilder)
{
modelBuilder.Entity <Content>().Property(cp => cp.Id)
.HasColumnName("ContentId");
modelBuilder.Entity <Content>().HasKey(cp => cp.Id);
modelBuilder.Entity <Content>().ToTable("dbo.Content");
modelBuilder.Entity <Charity>().Property(c => c.Id)
.HasColumnName("CharityId");
modelBuilder.Entity <Charity>().HasKey(c => c.Id);
modelBuilder.Entity <Charity>().ToTable("dbo.Charity");
modelBuilder.Entity <Volunteer>().Property(v => v.Id)
.HasColumnName("VolunteerId");
modelBuilder.Entity <Volunteer>().Property(v => v.MembershipId)
.HasColumnName("MembershipId");
modelBuilder.Entity <Volunteer>().Property(v => v.HasCancelled)
.HasColumnName("HasCancelled");
modelBuilder.Entity <Volunteer>().HasKey(v => v.Id);
modelBuilder.Entity <Volunteer>().ToTable("dbo.Volunteer");
modelBuilder.Entity <Volunteer>().Ignore(v => v.JobRoles);
modelBuilder.Entity <Volunteer>().Ignore(v => v.Technologies);
modelBuilder.Entity <JobRole>().Property(j => j.Id).HasColumnName("JobRoleId");
modelBuilder.Entity <JobRole>().HasKey(j => j.Id);
modelBuilder.Entity <JobRole>().ToTable("dbo.JobRole");
modelBuilder.Entity <VolunteerJobRole>().HasKey(v => new { v.JobRoleId, v.VolunteerId });
modelBuilder.Entity <VolunteerJobRole>().ToTable("dbo.VolunteerJobRoles");
modelBuilder.Entity <Technology>().Property(t => t.Id).HasColumnName("TechnologyId");
modelBuilder.Entity <Technology>().HasKey(t => t.Id);
modelBuilder.Entity <Technology>().ToTable("dbo.Technology");
modelBuilder.Entity <VolunteerTechnology>().HasKey(vt => new { vt.TechnologyId, vt.VolunteerId });
modelBuilder.Entity <VolunteerTechnology>().ToTable("dbo.VolunteerTechnologies");
modelBuilder.Entity <Team>().Property(t => t.Id)
.HasColumnName("TeamId");
modelBuilder.Entity <Team>().Property(t => t.Name)
.HasColumnName("TeamName");
modelBuilder.Entity <Team>().HasKey(t => t.Id);
modelBuilder.Entity <Team>().ToTable("dbo.Team");
modelBuilder.Entity <Setting>().Property(s => s.Id).HasColumnName("SettingId");
modelBuilder.Entity <Setting>().HasKey(s => s.Id);
modelBuilder.Entity <Setting>().ToTable("dbo.Setting");
modelBuilder.Entity <ExperienceLevel>().Property(e => e.Id).HasColumnName("ExperienceLevelId");
modelBuilder.Entity <ExperienceLevel>().HasKey(s => s.Id);
modelBuilder.Entity <ExperienceLevel>().ToTable("dbo.ExperienceLevel");
modelBuilder.Entity <Document>().Property(e => e.DocumentId).HasColumnName("DocumentId");
modelBuilder.Entity <Document>().HasKey(s => s.DocumentId);
modelBuilder.Entity <Document>().ToTable("dbo.Documents");
modelBuilder.Entity <NonTechVolunteer>().HasKey(v => v.Id);
modelBuilder.Entity <NonTechVolunteer>().Property(v => v.Id)
.HasColumnName("VolunteerId");
modelBuilder.Entity <NonTechVolunteer>().Property(v => v.HasCancelled)
.HasColumnName("HasCancelled");
modelBuilder.Entity <NonTechVolunteer>().Ignore(v => v.AreasOfExpertise);
modelBuilder.Entity <NonTechVolunteer>().ToTable("dbo.NonTechVolunteer");
modelBuilder.Entity <NonTechVolunteerExpertise>().HasKey(v => new { v.ExpertiseId, v.VolunteerId });
modelBuilder.Entity <NonTechVolunteerExpertise>().ToTable("dbo.NonTechVolunteerExpertise");
modelBuilder.Entity <Expertise>().HasKey(v => v.Id);
modelBuilder.Entity <Expertise>().Property(e => e.Id).HasColumnName("ExpertiseId");
modelBuilder.Entity <Expertise>().ToTable("dbo.Expertise");
modelBuilder.Entity <Sponsor>().HasKey(v => v.Id);
modelBuilder.Entity <Sponsor>().Property(e => e.Id).HasColumnName("SponsorId");
modelBuilder.Entity <Sponsor>().ToTable("dbo.Sponsor");
base.OnModelCreating(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.ModelConfiguration.ModelBuilder modelBuilder)
{
modelBuilder.Conventions.Remove <PluralizingEntitySetNameConvention>();
modelBuilder.Conventions.Add <TableNameUppercaseConvention>();
base.OnModelCreating(modelBuilder);
}
