private void AddTeamCodes() { TeamCodes.Add("RUS"); // Russia 43965 TeamCodes.Add("KSA"); // Saudi Arabia 43835 TeamCodes.Add("EGY"); // Egypt 43855 TeamCodes.Add("URU"); // Uruguay 43930 TeamCodes.Add("POR"); // Portugal 43963 TeamCodes.Add("ESP"); // Spain 43969 TeamCodes.Add("MAR"); // Morocco 43872 TeamCodes.Add("IRN"); // IR Iran 43817 TeamCodes.Add("FRA"); // France 43946 TeamCodes.Add("AUS"); // Australia 43976 TeamCodes.Add("PER"); // Peru 43929 TeamCodes.Add("DEN"); // Denmark 43941 TeamCodes.Add("ARG"); // Argentina 43922 TeamCodes.Add("ISL"); // Iceland 43951 TeamCodes.Add("CRO"); // Croatia 43938 TeamCodes.Add("NGA"); // Nigeria 43876 TeamCodes.Add("BRA"); // Brazil 43924 TeamCodes.Add("SUI"); // Switzerland 43971 TeamCodes.Add("CRC"); // Costa Rica 43901 TeamCodes.Add("SRB"); // Serbia 1902465 TeamCodes.Add("GER"); // Germany 43948 TeamCodes.Add("MEX"); // Mexico 43911 TeamCodes.Add("SWE"); // Sweden 43970 TeamCodes.Add("KOR"); // Korea Republic 43822 TeamCodes.Add("BEL"); // Belgium 43935 TeamCodes.Add("PAN"); // Panama 43914 TeamCodes.Add("TUN"); // Tunisia 43888 TeamCodes.Add("ENG"); // England 43942 TeamCodes.Add("POL"); // Poland 43962 TeamCodes.Add("SEN"); // Senegal 43879 TeamCodes.Add("COL"); // Colombia 43926 TeamCodes.Add("JPN"); // Japan 43819 }
public void Configure(EntityTypeBuilder <Opponent> builder) { builder.ToTable("opponents"); builder.HasOne(p => p.Game) .WithMany(b => b.Opponents) .HasForeignKey(o => o.GameId) .HasPrincipalKey(o => o.Id); builder.Property(o => o.Id).HasSnakeCaseColumnName(); builder.Property(o => o.GameId).HasSnakeCaseColumnName(); builder.Property(o => o.BlockNumber) .HasConversion(o => o.Value, o => new BlockNumber(o)) .HasSnakeCaseColumnName(); builder.Property(o => o.GameNumber) .HasConversion(o => o.Value, o => new GameNumber(o)) .HasSnakeCaseColumnName(); builder.Property(o => o.DrawNumber) .HasConversion(o => o.Value, o => new DrawNumber(o)) .HasSnakeCaseColumnName(); builder.Property(o => o.PlayerClassification) .HasSnakeCaseColumnName() .HasEnumerationConversion(); builder.Property(o => o.SeedLevel) .HasConversion(o => o.Value, o => new SeedLevel(o)) .HasSnakeCaseColumnName(); builder.Property(o => o.AssignOrder) .HasConversion(o => o.Value, o => new AssignOrder(o)) .HasSnakeCaseColumnName(); builder.Property(o => o.FramePlayerClassification) .HasEnumerationConversion() .HasSnakeCaseColumnName(); builder.Property(o => o.IsManuallySettingFrame).HasSnakeCaseColumnName(); builder.Property(o => o.IsManuallyAssigned).HasSnakeCaseColumnName(); builder.Property(o => o.EntryNumber) .HasConversion(o => o.Value, o => new EntryNumber(o)) .HasSnakeCaseColumnName(); builder.Property(o => o.SeedNumber) .HasConversion(o => o.Value, o => new SeedNumber(o)) .HasSnakeCaseColumnName(); builder.Property(o => o.TeamCodes) .HasConversion(o => o.ToJson(), o => TeamCodes.FromJson(o)) .HasSnakeCaseColumnName() .Metadata .SetValueComparer(ValueComparerFactory.CreateListComparer <TeamCodes, TeamCode>()); builder.Property(o => o.TeamAbbreviatedNames) .HasConversion(o => o.ToJson(), o => TeamAbbreviatedNames.FromJson(o)) .HasSnakeCaseColumnName() .Metadata .SetValueComparer(ValueComparerFactory.CreateListComparer <TeamAbbreviatedNames, TeamAbbreviatedName>()); builder.Property(o => o.PlayerCodes) .HasConversion(o => o.ToJson(), o => PlayerCodes.FromJson(o)) .HasSnakeCaseColumnName() .Metadata .SetValueComparer(ValueComparerFactory.CreateListComparer <PlayerCodes, PlayerCode>()); builder.Property(o => o.PlayerNames) .HasConversion(o => o.ToJson(), o => PlayerNames.FromJson(o)) .HasSnakeCaseColumnName() .Metadata .SetValueComparer(ValueComparerFactory.CreateListComparer <PlayerNames, PlayerName>()); builder.Property(o => o.FromGameNumber) .HasConversion(o => o.Value, o => new GameNumber(o)) .HasSnakeCaseColumnName(); }