Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class City
- {
- public City()
- {
- Attractions = new HashSet<Attraction>();
- }
- public int Id { get; set; }
- public string Name { get; set; }
- public string Description { get; set; }
- public int Population { get; set; }
- public int NumberOfAttractions { get { return Attractions.Count(); } }
- public virtual ICollection<Attraction> Attractions { get; set; }
- }
- public class Attraction
- {
- public int Id { get; set; }
- public string Name { get; set; }
- public string Description { get; set; }
- public int CityId { get; set; }
- public virtual City City { get; set; }
- }
- public class CityInfoContext : DbContext
- {
- public CityInfoContext(DbContextOptions options) : base(options)
- {
- }
- public virtual DbSet<City> Cities { get; set; }
- public virtual DbSet<Attraction> Attractions { get; set; }
- protected override void OnModelCreating(ModelBuilder modelBuilder)
- {
- modelBuilder.Entity<Attraction>(entity =>
- {
- entity.HasIndex(e => e.CityId);
- entity.Property(e => e.Description).IsRequired().HasMaxLength(200);
- entity.Property(e => e.Name).IsRequired().HasMaxLength(50);
- entity.HasOne(d => d.City).WithMany(p => p.Attractions).HasForeignKey(d => d.CityId);
- });
- modelBuilder.Entity<City>(entity =>
- {
- entity.Property(e => e.Description).IsRequired().HasMaxLength(200);
- entity.Property(e => e.Name).IsRequired().HasMaxLength(50);
- });
- }
- }
Add Comment
Please, Sign In to add comment