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