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