protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity <Customer>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Product>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Sale>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <SaleProduct>() .HasKey(c => new { c.ProductId, c.SaleId, }); var booleanStringConverter = new BoolToStringConverter("N", "Y"); base.OnModelCreating(modelBuilder); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity <Device>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Device>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <DeviceAction>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <DeviceAction>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); var booleanStringConverter = new BoolToStringConverter("N", "Y"); }
public void Configure(EntityTypeBuilder <Repair> repair) { repair.HasKey("id").HasName("RepairId"); repair.Property(r => r.IsFixed) .HasDefaultValue(false); // repair.Property(r => r.Bill); repair.Property(r => r.DateIn); // repair.Property(r => r.DateOut); repair.Property(r => r.CarId); repair.Property(r => r.EmployeeId); repair.Property(r => r.ProblemDescription) .HasMaxLength(1000) .IsUnicode(); repair.HasOne(r => r.Employee) .WithMany(e => e.Repairs) .HasForeignKey(r => r.EmployeeId); repair.HasOne(r => r.Car) .WithMany(c => c.Repairs) .HasForeignKey(r => r.CarId); var converter = new BoolToStringConverter("Nope", "Yea"); repair.Property(r => r.IsFixed) .HasConversion(converter); }
public static void Main() { bool firstVariableToTest = true; string firstConversionResult = BoolToStringConverter.Convert(firstVariableToTest); BoolToStringConverter.WritestringOnCosole(firstConversionResult); }
public void Can_convert_bools_to_empty_strings_or_whitespace() { var converter = new BoolToStringConverter("", " ").ConvertToProviderExpression.Compile(); Assert.Equal(" ", converter(true)); Assert.Equal("", converter(false)); }
public void Can_convert_empty_strings_or_whitespace_to_bool() { var converter = new BoolToStringConverter("", " ").ConvertFromProviderExpression.Compile(); Assert.False(converter("")); Assert.True(converter(" ")); Assert.False(converter("\t")); Assert.False(converter(null)); }
public List <string> GetInfo() { var result = new List <string>(); if (BoolToStringConverter.BTS((bool)CO2) == "Да") { result.Add("Датчик CO2"); } return(result); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity <Bucket>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Bucket>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <File>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <File>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <FileType>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <FileType>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <VersionInfo>() .HasKey(c => new { c.Version, }); var booleanStringConverter = new BoolToStringConverter("N", "Y"); base.OnModelCreating(modelBuilder); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { var converter = new BoolToStringConverter("F", "T"); var myBoolConverter = new ValueConverter <bool, string>( v => v ? "T" : "F", v => v == "T" ); var enumConverter = new EnumToStringConverter <BoolEnum>(); var myEnumConverter = new ValueConverter <BooleanEnum, string>( v => v == BooleanEnum.TrueValue ? "T" : "F", v => v == "T" ? BooleanEnum.TrueValue : BooleanEnum.FalseValue ); modelBuilder.Entity <Zbozi>(ent => { ent.ToTable("ZBOZI"); ent.HasKey(k => k.C_ZBO); ent.Property(p => p.NAZEV).IsRequired(); // field ZRUSENO is Oracle: CHAR(1) NULL ent.Property(p => p.ZRUSENO).HasConversion(converter); // field ZOBR_INTERNET is Oracle: CHAR(1) NULL ent.Property(p => p.ZOBR_INTERNET).HasConversion(myBoolConverter); // field SESTAVA is Oracle: CHAR(1) NULL ent.Property(p => p.SESTAVA).HasConversion(enumConverter); // field SALOBAL is Oracle: CHAR(1) NULL ent.Property(p => p.SALOBAL).HasConversion(myEnumConverter); }); modelBuilder.Entity <Rkdav>(ent => { ent.HasKey(k => k.RKDAV); ent.Property(p => p.RKDAV).HasMaxLength(5); }); modelBuilder.Entity <Entity>(ent => { ent.HasKey(k => k.ENTITA); }); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity <DirectTweet>() .HasKey(c => new { c.TweetId, }); modelBuilder.Entity <Follower>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Following>() .HasKey(c => new { c.UserId, }); modelBuilder.Entity <Like>() .HasKey(c => new { c.LikerUserId, c.TweetId, }); modelBuilder.Entity <Location>() .HasKey(c => new { c.LocationId, }); modelBuilder.Entity <Message>() .HasKey(c => new { c.MessageId, }); modelBuilder.Entity <Messenger>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Messenger>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <QuoteTweet>() .HasKey(c => new { c.QuoteTweetId, }); modelBuilder.Entity <Reply>() .HasKey(c => new { c.ReplyId, }); modelBuilder.Entity <Retweet>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Retweet>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Tweet>() .HasKey(c => new { c.TweetId, }); modelBuilder.Entity <User>() .HasKey(c => new { c.UserId, }); var booleanStringConverter = new BoolToStringConverter("N", "Y"); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity <Admin>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Admin>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <City>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <City>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Country>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Country>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Customer>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Customer>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Event>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Event>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Province>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Province>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Sale>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Sale>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <SaleTicket>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <SaleTicket>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Ticket>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Ticket>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <TicketStatu>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <TicketStatu>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Transaction>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Transaction>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <TransactionStatu>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <TransactionStatu>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Venue>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Venue>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); var booleanStringConverter = new BoolToStringConverter("N", "Y"); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity <ColumnSameAsFKTable>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <ColumnSameAsFKTable>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <CompositePrimaryKey>() .HasKey(c => new { c.Id, c.Id2, }); modelBuilder.Entity <IncludedColumnTest>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <IncludedColumnTest>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Person>() .HasKey(c => new { c.PersonId, }); modelBuilder.Entity <Person>() .Property("PersonId") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <RowVersionCheck>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <RowVersionCheck>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <SelfReference>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <SelfReference>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Table>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Table>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <TestAllFieldType>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <TestAllFieldType>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <TestAllFieldTypesNullable>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <TestAllFieldTypesNullable>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <TimestampCheck>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <TimestampCheck>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <VPerson>() .HasKey(c => new { c.PersonId, }); modelBuilder.Entity <VPerson>() .Property("PersonId") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <SchemaAPerson>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <SchemaAPerson>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <SchemaBPerson>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <SchemaBPerson>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PersonRef>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <PersonRef>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); var booleanStringConverter = new BoolToStringConverter("N", "Y"); }
// public DbQuery<User> Users { get; private set; } protected override void OnModelCreating(ModelBuilder builder) { base.OnModelCreating(builder); var yesNoConverter = new BoolToStringConverter("no", "yes"); // Read-only tables builder.Entity <ProjectDbUser>(b => { b.Property(e => e.Id).HasColumnName("id"); b.Property(e => e.GroupId).HasColumnName("group_id"); b.Property(e => e.FirstName).HasColumnName("firstName"); b.Property(e => e.MiddleName).HasColumnName("middleName"); b.Property(e => e.LastName).HasColumnName("lastName"); b.Property(e => e.Initials).HasColumnName("initials"); b.Property(e => e.Function).HasColumnName("function"); b.Property(e => e.Email).HasColumnName("email"); b.Property(e => e.InstituteId).HasColumnName("institute_id"); b.Property(e => e.Status).HasColumnName("status").HasConversion(new CheckinStatusConverter()); // Not used // b.Ignore(e => e.Initials); // b.Ignore(e => e.Function); // b.Ignore(e => e.InstituteId); b.ToTable("users"); }); builder.Entity <ProjectDbGroup>(b => { b.Property(e => e.Id).HasColumnName("id"); b.Property(e => e.HeadId).HasColumnName("head_id"); b.Property(e => e.HeadIsPi).HasColumnName("head_is_pi").HasConversion(yesNoConverter); b.Property(e => e.Description).HasColumnName("description"); b.Property(e => e.Hidden).HasColumnName("hidden"); b.Property(e => e.InstituteId).HasColumnName("institute_id"); // Not used // b.Ignore(e => e.HeadIsPi); // b.Ignore(e => e.InstituteId); b.HasOne(e => e.Head).WithOne(); b.HasMany(e => e.Members).WithOne(e => e.Group).HasForeignKey(e => e.GroupId); b.ToTable("groups"); }); builder.Entity <ProjectDbImagingMethod>(b => { b.Property(e => e.Id).HasColumnName("id"); b.Property(e => e.BillingCategory).HasColumnName("billing_category"); b.Property(e => e.Description).HasColumnName("description"); b.Property(e => e.ImagingGroup).HasColumnName("imaging_group"); b.Property(e => e.SessionQuota).HasColumnName("sessionQuota"); b.Property(e => e.Url).HasColumnName("url"); b.ToTable("imaging_methods"); }); builder.Entity <ProjectDbFundingSource>(b => { b.Property(e => e.Id).HasColumnName("id"); b.Property(e => e.OldId).HasColumnName("oldid"); b.Property(e => e.Description).HasColumnName("description"); b.ToTable("sources"); }); // RW tables builder.Entity <ProjectDbProject>(b => { b.Property(e => e.Id).HasColumnName("id").HasMaxLength(20); b.Property(e => e.AuthorshipRemarks).IsRequired().HasColumnName("authorshipRemarks"); b.Property(e => e.AuthorshipSequence).IsRequired().HasColumnName("authorshipSequence"); b.Property(e => e.CalculatedProjectSpace).HasColumnName("calculatedProjectSpace").HasDefaultValue(); b.Property(e => e.Created).HasColumnName("created").HasDefaultValue(); b.Property(e => e.EcRequestedBy).IsRequired().HasColumnName("ecRequestedBy").HasMaxLength(255).HasDefaultValue(); b.Property(e => e.EndingDate).HasColumnName("endingDate").HasDefaultValue(); b.Property(e => e.IncreaseDate).HasColumnName("increaseDate"); b.Property(e => e.OldId).IsRequired().HasColumnName("oldid").HasMaxLength(20).HasDefaultValue(); b.Property(e => e.OwnerId).IsRequired().HasColumnName("owner_id").HasMaxLength(10).HasDefaultValue(); b.Property(e => e.PpmApprovedQuota).HasColumnName("ppmApprovedQuota").HasDefaultValue(); b.Property(e => e.PpmDate).HasColumnName("ppmDate"); b.Property(e => e.ProjectEndDate).HasColumnName("projectEndDate").HasDefaultValue(); b.Property(e => e.ProjectName).IsRequired().HasColumnName("projectName").HasMaxLength(255).HasDefaultValue(); b.Property(e => e.SourceId).IsRequired().HasColumnName("source_id").HasMaxLength(20).HasDefaultValue(); b.Property(e => e.StartingDate).HasColumnName("startingDate").HasDefaultValue(); b.Property(e => e.TotalProjectSpace).HasColumnName("totalProjectSpace").HasDefaultValue(); b.Property(e => e.Updated).HasColumnName("updated").HasDefaultValue(); b.Property(e => e.UsedProjectSpace).HasColumnName("usedProjectSpace").HasDefaultValue(); b.Property(e => e.EcApproved).HasColumnName("ecApproved").HasConversion(yesNoConverter).HasDefaultValue(); b.Property(e => e.ApprovedAdministration).HasColumnName("approvedAdministration").HasConversion(yesNoConverter).HasDefaultValue(); b.Property(e => e.Sticky).HasColumnName("sticky").HasConversion(yesNoConverter).HasDefaultValue(); b.Property(e => e.IncreaseQuota).HasColumnName("increaseQuota").HasConversion(yesNoConverter).HasDefaultValue(); b.Property(e => e.ProjectBased).HasColumnName("projectBased").HasConversion(yesNoConverter).HasDefaultValue(); b.Property(e => e.Active).HasColumnName("status").HasConversion(new BoolToStringConverter("inactive", "active")).HasDefaultValue(); b.HasMany(e => e.ProjectMembers).WithOne().HasForeignKey(e => e.ProjectId); b.HasMany(e => e.Experiments).WithOne().HasForeignKey(e => e.ProjectId); b.ToTable("projects"); }); builder.Entity <ProjectDbProjectMember>(b => { b.HasKey(e => new { e.UserId, e.ProjectId }); b.Property(e => e.UserId).HasColumnName("user_id").HasMaxLength(10).IsRequired(); b.Property(e => e.ProjectId).HasColumnName("project_id").HasMaxLength(20).IsRequired(); b.Property(e => e.Created).HasColumnName("created").IsRequired(); b.Property(e => e.Updated).HasColumnName("updated").IsRequired(); b.Property(e => e.Role).HasColumnName("role").IsRequired(); b.Property(e => e.Action).HasColumnName("action"); b.Property(e => e.Activated).HasColumnName("activated").HasConversion(yesNoConverter).HasDefaultValue().IsRequired(); b.HasOne(e => e.User).WithMany().HasForeignKey(e => e.UserId); b.ToTable("projectmembers"); }); builder.Entity <ProjectDbExperiment>(b => { b.Property(e => e.Id).HasColumnName("id"); b.Property(e => e.CalculatedQuota).HasColumnName("calculatedQuota").HasDefaultValue(); b.Property(e => e.Created).HasColumnName("created").HasDefaultValue(); b.Property(e => e.EndingDate).HasColumnName("endingDate").HasDefaultValue(); b.Property(e => e.ExperimentEndDate).HasColumnName("experimentEndDate").HasDefaultValue(); b.Property(e => e.ExperimenterId).IsRequired().HasMaxLength(10).HasColumnName("experimenter_id").HasDefaultValue(); b.Property(e => e.ImagingMethodId).IsRequired().HasMaxLength(15).HasColumnName("imaging_method_id").HasDefaultValue(); b.Property(e => e.IncreaseQuotaDate).HasColumnName("increaseQuotaDate"); b.Property(e => e.IncreasedQuota).HasColumnName("increasedQuota").HasDefaultValue(); b.Property(e => e.LabTime).HasColumnName("labtime"); b.Property(e => e.NoSessions).HasColumnName("noSessions").HasDefaultValue(); b.Property(e => e.NoSubjects).HasColumnName("noSubjects").HasDefaultValue(); b.Property(e => e.Offset).HasColumnName("offset"); b.Property(e => e.PpmApprovedQuota).HasColumnName("ppmApprovedQuota"); b.Property(e => e.ProjectId).IsRequired().HasColumnName("project_id").HasMaxLength(20).HasDefaultValue(); b.Property(e => e.ProjectOldId).IsRequired().HasColumnName("project_oldid").HasMaxLength(20).HasDefaultValue(); b.Property(e => e.QuotaUserId).IsRequired().HasMaxLength(10).HasColumnName("quota_user_id").HasDefaultValue(); b.Property(e => e.StartingDate).HasColumnName("startingDate").HasDefaultValue(); b.Property(e => e.Suffix).IsRequired().HasColumnName("suffix").HasMaxLength(4).HasDefaultValue(); b.Property(e => e.Updated).HasColumnName("updated").HasDefaultValue(); b.HasOne(e => e.Experimenter).WithMany().HasForeignKey(e => e.ExperimenterId); b.HasOne(e => e.QuotaUser).WithMany().HasForeignKey(e => e.QuotaUserId); b.HasOne(e => e.ImagingMethod).WithMany().HasForeignKey(e => e.ImagingMethodId); b.ToTable("experiments"); }); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity <Admin>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Admin>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Event>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Event>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <EventStatus>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <EventStatus>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <EventStudent>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <EventStudent>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <EventTeacher>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <EventTeacher>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Family>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Family>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Rate>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Rate>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Space>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Space>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <SpaceFeature>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <SpaceFeature>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <SpaceSpaceFeature>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <SpaceSpaceFeature>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Student>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Student>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Studio>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Studio>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Teacher>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Teacher>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <TeacherSkill>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <TeacherSkill>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <TeacherTeacherSkill>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <TeacherTeacherSkill>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <User>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <User>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); var booleanStringConverter = new BoolToStringConverter("N", "Y"); modelBuilder.Entity <Admin>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <Event>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <EventStatus>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <EventStudent>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <EventTeacher>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <Family>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <Rate>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <Space>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <SpaceFeature>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <SpaceSpaceFeature>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <Student>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <Studio>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <Teacher>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <TeacherSkill>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <TeacherTeacherSkill>().HasQueryFilter(x => !x.IsDeleted); modelBuilder.Entity <User>().HasQueryFilter(x => !x.IsDeleted); base.OnModelCreating(modelBuilder); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity <Airline>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Airline>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <AirTransport>() .HasKey(c => new { c.AirlineId, }); modelBuilder.Entity <AirTransport>() .Property("AirlineId") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Breed>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Breed>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Client>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Client>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <ClientCommunication>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <ClientCommunication>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Country>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Country>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <CountryRequirement>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <CountryRequirement>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Destination>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Destination>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Employee>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Employee>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Handler>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Handler>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <HandlerPipelineStep>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <HandlerPipelineStep>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <OtherTransport>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <OtherTransport>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Pet>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Pet>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Pipeline>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Pipeline>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PipelineStatu>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <PipelineStatu>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PipelineStep>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <PipelineStep>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PipelineStepDestination>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <PipelineStepDestination>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PipelineStepNote>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <PipelineStepNote>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PipelineStepStatu>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <PipelineStepStatu>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PipelineStepStepRequirement>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <PipelineStepStepRequirement>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Sale>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Sale>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Species>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Species>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); var booleanStringConverter = new BoolToStringConverter("N", "Y"); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity <Badge>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Badge>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Comment>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Comment>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <LinkType>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <LinkType>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PostHistory>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <PostHistory>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PostHistoryType>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <PostHistoryType>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PostLink>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <PostLink>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Post>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Post>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PostType>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <PostType>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Tag>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Tag>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <User>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <User>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Vote>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Vote>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <VoteType>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <VoteType>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); var booleanStringConverter = new BoolToStringConverter("N", "Y"); base.OnModelCreating(modelBuilder); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity <Address>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Address>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Call>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Call>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <CallAssignment>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <CallAssignment>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <CallDisposition>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <CallDisposition>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <CallPerson>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <CallPerson>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <CallStatus>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <CallStatus>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <CallType>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <CallType>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Note>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Note>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <OffCapability>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <OffCapability>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Officer>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Officer>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <OfficerCapabilities>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <OfficerCapabilities>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Person>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Person>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PersonType>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <PersonType>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Unit>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Unit>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <UnitDisposition>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <UnitDisposition>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <UnitOfficer>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <UnitOfficer>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <VehCapability>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <VehCapability>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Vehicle>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Vehicle>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <VehicleCapabilities>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <VehicleCapabilities>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <VehicleOfficer>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <VehicleOfficer>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); var booleanStringConverter = new BoolToStringConverter("N", "Y"); base.OnModelCreating(modelBuilder); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity <AWBuildVersion>() .HasKey(c => new { c.SystemInformationID, }); modelBuilder.Entity <AWBuildVersion>() .Property("SystemInformationID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <DatabaseLog>() .HasKey(c => new { c.DatabaseLogID, }); modelBuilder.Entity <DatabaseLog>() .Property("DatabaseLogID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <ErrorLog>() .HasKey(c => new { c.ErrorLogID, }); modelBuilder.Entity <ErrorLog>() .Property("ErrorLogID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Department>() .HasKey(c => new { c.DepartmentID, }); modelBuilder.Entity <Department>() .Property("DepartmentID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Employee>() .HasKey(c => new { c.BusinessEntityID, }); modelBuilder.Entity <EmployeeDepartmentHistory>() .HasKey(c => new { c.BusinessEntityID, c.StartDate, c.DepartmentID, c.ShiftID, }); modelBuilder.Entity <EmployeePayHistory>() .HasKey(c => new { c.BusinessEntityID, c.RateChangeDate, }); modelBuilder.Entity <JobCandidate>() .HasKey(c => new { c.JobCandidateID, }); modelBuilder.Entity <JobCandidate>() .Property("JobCandidateID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Shift>() .HasKey(c => new { c.ShiftID, }); modelBuilder.Entity <Shift>() .Property("ShiftID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Address>() .HasKey(c => new { c.AddressID, }); modelBuilder.Entity <Address>() .Property("AddressID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <AddressType>() .HasKey(c => new { c.AddressTypeID, }); modelBuilder.Entity <AddressType>() .Property("AddressTypeID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <BusinessEntity>() .HasKey(c => new { c.BusinessEntityID, }); modelBuilder.Entity <BusinessEntity>() .Property("BusinessEntityID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <BusinessEntityAddress>() .HasKey(c => new { c.BusinessEntityID, c.AddressID, c.AddressTypeID, }); modelBuilder.Entity <BusinessEntityContact>() .HasKey(c => new { c.BusinessEntityID, c.PersonID, c.ContactTypeID, }); modelBuilder.Entity <ContactType>() .HasKey(c => new { c.ContactTypeID, }); modelBuilder.Entity <ContactType>() .Property("ContactTypeID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <CountryRegion>() .HasKey(c => new { c.CountryRegionCode, }); modelBuilder.Entity <EmailAddress>() .HasKey(c => new { c.BusinessEntityID, c.EmailAddressID, }); modelBuilder.Entity <EmailAddress>() .Property("EmailAddressID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Password>() .HasKey(c => new { c.BusinessEntityID, }); modelBuilder.Entity <Person>() .HasKey(c => new { c.BusinessEntityID, }); modelBuilder.Entity <PersonPhone>() .HasKey(c => new { c.BusinessEntityID, c.PhoneNumber, c.PhoneNumberTypeID, }); modelBuilder.Entity <PhoneNumberType>() .HasKey(c => new { c.PhoneNumberTypeID, }); modelBuilder.Entity <PhoneNumberType>() .Property("PhoneNumberTypeID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <StateProvince>() .HasKey(c => new { c.StateProvinceID, }); modelBuilder.Entity <StateProvince>() .Property("StateProvinceID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <VStateProvinceCountryRegion>() .HasKey(c => new { c.StateProvinceID, c.CountryRegionCode, }); modelBuilder.Entity <BillOfMaterial>() .HasKey(c => new { c.BillOfMaterialsID, }); modelBuilder.Entity <BillOfMaterial>() .Property("BillOfMaterialsID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Culture>() .HasKey(c => new { c.CultureID, }); modelBuilder.Entity <Document>() .HasKey(c => new { c.Rowguid, }); modelBuilder.Entity <Document>() .Property("Rowguid") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Illustration>() .HasKey(c => new { c.IllustrationID, }); modelBuilder.Entity <Illustration>() .Property("IllustrationID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Location>() .HasKey(c => new { c.LocationID, }); modelBuilder.Entity <Location>() .Property("LocationID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Product>() .HasKey(c => new { c.ProductID, }); modelBuilder.Entity <Product>() .Property("ProductID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <ProductCategory>() .HasKey(c => new { c.ProductCategoryID, }); modelBuilder.Entity <ProductCategory>() .Property("ProductCategoryID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <ProductCostHistory>() .HasKey(c => new { c.ProductID, c.StartDate, }); modelBuilder.Entity <ProductDescription>() .HasKey(c => new { c.ProductDescriptionID, }); modelBuilder.Entity <ProductDescription>() .Property("ProductDescriptionID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <ProductInventory>() .HasKey(c => new { c.ProductID, c.LocationID, }); modelBuilder.Entity <ProductListPriceHistory>() .HasKey(c => new { c.ProductID, c.StartDate, }); modelBuilder.Entity <ProductModel>() .HasKey(c => new { c.ProductModelID, }); modelBuilder.Entity <ProductModel>() .Property("ProductModelID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <ProductModelIllustration>() .HasKey(c => new { c.ProductModelID, c.IllustrationID, }); modelBuilder.Entity <ProductModelProductDescriptionCulture>() .HasKey(c => new { c.ProductModelID, c.ProductDescriptionID, c.CultureID, }); modelBuilder.Entity <ProductPhoto>() .HasKey(c => new { c.ProductPhotoID, }); modelBuilder.Entity <ProductPhoto>() .Property("ProductPhotoID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <ProductProductPhoto>() .HasKey(c => new { c.ProductID, c.ProductPhotoID, }); modelBuilder.Entity <ProductReview>() .HasKey(c => new { c.ProductReviewID, }); modelBuilder.Entity <ProductReview>() .Property("ProductReviewID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <ProductSubcategory>() .HasKey(c => new { c.ProductSubcategoryID, }); modelBuilder.Entity <ProductSubcategory>() .Property("ProductSubcategoryID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <ScrapReason>() .HasKey(c => new { c.ScrapReasonID, }); modelBuilder.Entity <ScrapReason>() .Property("ScrapReasonID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <TransactionHistory>() .HasKey(c => new { c.TransactionID, }); modelBuilder.Entity <TransactionHistory>() .Property("TransactionID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <TransactionHistoryArchive>() .HasKey(c => new { c.TransactionID, }); modelBuilder.Entity <UnitMeasure>() .HasKey(c => new { c.UnitMeasureCode, }); modelBuilder.Entity <VProductAndDescription>() .HasKey(c => new { c.CultureID, c.ProductID, }); modelBuilder.Entity <WorkOrder>() .HasKey(c => new { c.WorkOrderID, }); modelBuilder.Entity <WorkOrder>() .Property("WorkOrderID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <WorkOrderRouting>() .HasKey(c => new { c.WorkOrderID, c.ProductID, c.OperationSequence, }); modelBuilder.Entity <ProductVendor>() .HasKey(c => new { c.ProductID, c.BusinessEntityID, }); modelBuilder.Entity <PurchaseOrderDetail>() .HasKey(c => new { c.PurchaseOrderID, c.PurchaseOrderDetailID, }); modelBuilder.Entity <PurchaseOrderDetail>() .Property("PurchaseOrderDetailID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PurchaseOrderHeader>() .HasKey(c => new { c.PurchaseOrderID, }); modelBuilder.Entity <PurchaseOrderHeader>() .Property("PurchaseOrderID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <ShipMethod>() .HasKey(c => new { c.ShipMethodID, }); modelBuilder.Entity <ShipMethod>() .Property("ShipMethodID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Vendor>() .HasKey(c => new { c.BusinessEntityID, }); modelBuilder.Entity <CountryRegionCurrency>() .HasKey(c => new { c.CountryRegionCode, c.CurrencyCode, }); modelBuilder.Entity <CreditCard>() .HasKey(c => new { c.CreditCardID, }); modelBuilder.Entity <CreditCard>() .Property("CreditCardID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Currency>() .HasKey(c => new { c.CurrencyCode, }); modelBuilder.Entity <CurrencyRate>() .HasKey(c => new { c.CurrencyRateID, }); modelBuilder.Entity <CurrencyRate>() .Property("CurrencyRateID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Customer>() .HasKey(c => new { c.CustomerID, }); modelBuilder.Entity <Customer>() .Property("CustomerID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PersonCreditCard>() .HasKey(c => new { c.BusinessEntityID, c.CreditCardID, }); modelBuilder.Entity <SalesOrderDetail>() .HasKey(c => new { c.SalesOrderID, c.SalesOrderDetailID, }); modelBuilder.Entity <SalesOrderDetail>() .Property("SalesOrderDetailID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <SalesOrderHeader>() .HasKey(c => new { c.SalesOrderID, }); modelBuilder.Entity <SalesOrderHeader>() .Property("SalesOrderID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <SalesOrderHeaderSalesReason>() .HasKey(c => new { c.SalesOrderID, c.SalesReasonID, }); modelBuilder.Entity <SalesPerson>() .HasKey(c => new { c.BusinessEntityID, }); modelBuilder.Entity <SalesPersonQuotaHistory>() .HasKey(c => new { c.BusinessEntityID, c.QuotaDate, }); modelBuilder.Entity <SalesReason>() .HasKey(c => new { c.SalesReasonID, }); modelBuilder.Entity <SalesReason>() .Property("SalesReasonID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <SalesTaxRate>() .HasKey(c => new { c.SalesTaxRateID, }); modelBuilder.Entity <SalesTaxRate>() .Property("SalesTaxRateID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <SalesTerritory>() .HasKey(c => new { c.TerritoryID, }); modelBuilder.Entity <SalesTerritory>() .Property("TerritoryID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <SalesTerritoryHistory>() .HasKey(c => new { c.BusinessEntityID, c.StartDate, c.TerritoryID, }); modelBuilder.Entity <ShoppingCartItem>() .HasKey(c => new { c.ShoppingCartItemID, }); modelBuilder.Entity <ShoppingCartItem>() .Property("ShoppingCartItemID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <SpecialOffer>() .HasKey(c => new { c.SpecialOfferID, }); modelBuilder.Entity <SpecialOffer>() .Property("SpecialOfferID") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <SpecialOfferProduct>() .HasKey(c => new { c.SpecialOfferID, c.ProductID, }); modelBuilder.Entity <Store>() .HasKey(c => new { c.BusinessEntityID, }); var booleanStringConverter = new BoolToStringConverter("N", "Y"); }
public static BoolToStringConverter ObtenerBoolToStringConverter(string falseValue, string trueValue) { var converter = new BoolToStringConverter(falseValue, trueValue); return(converter); }
public void TestConversions(bool input, string output) { var converter = new BoolToStringConverter(); Assert.Equal(output, converter.ConvertTo(input, typeof(string))); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity <Chain>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Chain>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <ChainStatus>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <ChainStatus>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Clasp>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Clasp>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Link>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Link>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <LinkLog>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <LinkLog>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <LinkStatus>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <LinkStatus>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Machine>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Machine>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <MachineRefTeam>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <MachineRefTeam>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Organization>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Organization>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Sysdiagrams>() .HasKey(c => new { c.DiagramId, }); modelBuilder.Entity <Sysdiagrams>() .Property("DiagramId") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Team>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Team>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <VersionInfo>() .HasKey(c => new { c.Version, }); var booleanStringConverter = new BoolToStringConverter("N", "Y"); base.OnModelCreating(modelBuilder); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { // zapnutí podpory pro cizí klíče Database.ExecuteSqlCommand("PRAGMA foreign_keys = ON"); var converter = new BoolToStringConverter("T", "F"); var enumConv = new EnumToStringConverter <UserType>(); modelBuilder.Entity <User>(ent => { // one to many // entita User má jednu vlastnost Gender, kde Gender může mít kolekci vlastností User spojenou přes cizí klíč User.GenderId ent.HasOne <Gender>(s => s.Gender).WithMany(m => m.Users).HasForeignKey(f => f.GenderId); ent.OwnsOne(o => o.Address).ToTable("Address"); ent.Property(p => p.Active).IsRequired().HasConversion(converter); // textový sloupec použitý pro Enum s již existujícím convertorem ent.Property(p => p.UsrType).HasMaxLength(20).HasColumnType("text").HasConversion(enumConv); }); modelBuilder.Entity <Customer>(ent => { }); modelBuilder.Entity <Color>(ent => { ent.Property(p => p.HexValue).IsRequired().HasMaxLength(6); // pokud není nullable, tak použití "IsRequired" nevygeneruje korektní migraci ent.Property(p => p.Alpha).HasDefaultValue(true); }); modelBuilder.Entity <Order>(ent => { // nastavení názvu tabulky v databázi ent.ToTable("MyOrders"); // pořadí klíče má význam pro sestavení indexu ent.HasKey(k => new { k.Prefix, k.Year, k.Number }); }); modelBuilder.Entity <OrderItem>(ent => { // primární klíč nemá nýzev dle konvencí, takže je nutné jej zde definovat ent.HasKey(k => k.ItemNumber); // vytvoříme vazbu přes složený klíč, s kaskádovým odstraňováním položek ent.HasOne <Order>(s => s.Order).WithMany(m => m.Items) .HasForeignKey(f => new { f.Prefix, f.Year, f.Number }) .OnDelete(DeleteBehavior.Cascade); }); // vlastní convertor na enumy ve stylu FISu var valConvCar = new ValueConverter <CarType?, string>( v => v.ToString().ToUpper(), v => v == null ? CarType.Vehicle : (CarType)Enum.Parse(typeof(CarType), v, true)); modelBuilder.Entity <Car>(ent => { // vazba na "master" tabulku bez nutnosti definovat kolekci "childů" ent.HasOne <User>(s => s.User).WithMany().HasForeignKey(f => f.UserId); ent.Property(p => p.Name).IsRequired().HasMaxLength(50); ent.Property(p => p.CarType).HasMaxLength(20).HasColumnType("text").HasConversion(valConvCar); }); modelBuilder.Seed(); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { var booleanStringConverter = new BoolToStringConverter("N", "Y"); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity <Breed>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Breed>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <PaymentType>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <PaymentType>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Pen>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Pen>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Pet>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Pet>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Sale>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Sale>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); modelBuilder.Entity <Species>() .HasKey(c => new { c.Id, }); modelBuilder.Entity <Species>() .Property("Id") .ValueGeneratedOnAdd() .UseSqlServerIdentityColumn(); var booleanStringConverter = new BoolToStringConverter("N", "Y"); base.OnModelCreating(modelBuilder); }