Required property but Nullable, Entity Framework through Code First

Question

How to make a property required (for field validation) but Nullable for the DB code migrations?

I do have a DB table with a thousand entries. recently was required to add a required DateTime property.

    [Required]
    [Display(Name = "Birth", Order = 10)]
    public DateTime? Birth { get; set; }

If I set [Required] annotation, the Code first migration will add NOT NULL to the column declaration. However all current entries does not have "Birth" data. and it will be NULL.

the Birth property should be required to the view field validatoin, but it could be nullable into the DB. Is that possible somehow?

I already tried add "?" (nullable) to the property and "virtual" without success.

If you editng data, you should not be using a data model in the view - you should be using a view model and the DateTime can be decorated with [Required] but omitted from the data model. — user3559349
– user3559349, Commented Aug 6, 2016 at 2:39

Siavas · Accepted Answer · 2017-07-14 01:20:21Z

7

Use your model for DB/Entity communication.

Use a View Model for your UI layer. Mark Required on the property in the ViewModel, mark Nullable on the model. Perform casting in your code as needed. Move all the UI-related attribute decoration (like Display, validation/etc) to the ViewModel as well.

Casting can automatically be performed with the AutoMapper plugin, available via the NuGet package manager.

edited Jul 14, 2017 at 1:20

Siavas

5,1202 gold badges28 silver badges38 bronze badges

answered Aug 6, 2016 at 2:05

mariocatch

8,72312 gold badges52 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TaiT's · Accepted Answer · 2016-08-06 02:28:14Z

One quick way could be overriding the OnModelCreating() method of your DB Context.

This way :

public class AppContext : DbContext
{
   protected override void OnModelCreating(DbModelBuilder modelBuilder)
   {
      // ...
      modelBuilder.Entity<YourModelEntity>.Property(p => p.Birth).IsOptional();
   }

}

or another proper way is that you can create an extended class of the generic EntityTypeConfiguration type for your model and then add this specific configuration to the DBModelBuilder in the OnModelCreating() method this way :

public class YourModelTypeConfiguration : EntityTypeConfiguration<YourModelType>
{
    public YourModelTypeConfiguration()
    {
        // ... some other configurations ;

        Property(p => p.Birth).IsOptional();
    }
}

Note that you need the

using System.Data.Entity.ModelConfiguration;

at top of your class file.

Then in the OnModelCreating() method you should add this :

    public class AppContext : DbContext
{
   protected override void OnModelCreating(DbModelBuilder modelBuilder)
   {
      // quick and dirty solution
      // modelBuilder.Entity<YourModelEntity>.Property(p => p.Birth).IsOptional()

      // cleaner solution
      modelBuilder.Configurations.Add(new YourModelTypeConfiguration());
   }

}

This way you keep your specific configurations separated and don't mix everything together.

When applying code first migration the "Birth" database field should be nullable.

I hope this helps.

Collectives™ on Stack Overflow

Required property but Nullable, Entity Framework through Code First

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related