public void Configure(EntityTypeBuilder <Car> builder)
        {
            builder.ToTable("CAR")
            .HasKey(c => c.CarId);

            builder.Property(c => c.CarId)
            .HasColumnName("ID")
            .ValueGeneratedOnAdd();

            builder.Property(c => c.Vin)
            .HasColumnName("VIN")
            .IsRequired()
            .HasMaxLength(17);

            builder.Property(c => c.Name)
            .HasColumnName("NAME")
            .HasMaxLength(250);

            builder.Property(c => c.Mileage)
            .HasColumnName("MILEAGE");

            builder.Property(c => c.MileageLastUserSet)
            .HasColumnName("MILEAGE_LAST_USER_SET");

            builder.AddTrackedEntityProperties();
            builder.AddOwnedEntityProperties(u => u.Cars);
        }
Exemple #2
0
        public void Configure(EntityTypeBuilder <PlaceVisit> builder)
        {
            builder.ToTable("PLACE_VISIT")
            .HasKey(pv => pv.PlaceVisitId);

            builder.Property(pv => pv.PlaceVisitId)
            .HasColumnName("ID")
            .ValueGeneratedOnAdd();

            builder.Property(pv => pv.Latitude)
            .HasColumnName("LATITUDE")
            .IsRequired();

            builder.Property(pv => pv.Longitude)
            .HasColumnName("LONGITUDE")
            .IsRequired();

            builder.Property(pv => pv.PlaceType)
            .HasColumnName("PLACE_TYPE")
            .IsRequired();

            builder.Property(pv => pv.VisitDate)
            .HasColumnName("VISIT_DATE");

            builder.Property(pv => pv.UserSelected)
            .HasColumnName("USER_SELECTED")
            .IsRequired();

            builder.Property(pv => pv.PlaceId)
            .HasColumnName("PLACE_ID")
            .IsRequired();

            builder.Property(pv => pv.TripId)
            .HasColumnName("TRIP_ID");

            builder.HasOne(pv => pv.Place)
            .WithMany(p => p.Visits)
            .HasForeignKey(pv => pv.PlaceId);

            builder.HasOne(pv => pv.Trip)
            .WithMany(t => t.PlaceVisits)
            .HasForeignKey(pv => pv.TripId);

            builder.AddTrackedEntityProperties();
            builder.AddOwnedEntityProperties(u => u.PlaceVisits);
        }
        public void Configure(EntityTypeBuilder <UserPlace> builder)
        {
            builder.ToTable("USER_PLACE")
            .HasKey(p => p.UserPlaceId);

            builder.Property(p => p.UserPlaceId)
            .HasColumnName("ID")
            .ValueGeneratedOnAdd();

            builder.Property(u => u.PlaceId)
            .HasColumnName("PLACE_ID")
            .IsRequired();

            builder.HasOne(u => u.Place)
            .WithMany(p => p.UserPlaces)
            .HasForeignKey(g => g.PlaceId);

            builder.AddTrackedEntityProperties();
            builder.AddOwnedEntityProperties(u => u.UserPlaces);
            builder.AddActiveEntityProperties();
        }