Entity Framework Code first making a column non-nullable

c# entity-framework sql

Question

I am using EF code first for my project. I have following code in my DataModel

[HiddenInput(DisplayValue = false)]        
public DateTime? PasswordDate { get; set; }

To make this non-nullable I removed '?' and ran Add-Migration command from Package manager console. following migration file was generated.

  public partial class PasswordDate : DbMigration
{
    public override void Up()
    {
        AlterColumn("dbo.CertificateInfoes", "PasswordDate", c => c.DateTime(nullable: false));
    }

    public override void Down()
    {
        AlterColumn("dbo.CertificateInfoes", "PasswordDate", c => c.DateTime());
    }
}

But when I run Update-Database command:

Update-Database -SourceMigration 201309020721215_PasswordDate

I get following error: Cannot insert the value NULL into column 'PasswordDate', table ''; column does not allow nulls. UPDATE fails. The statement has been terminated.

Kindly suggest the solutions.

1
19
9/2/2013 8:46:44 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

That's because you allowed NULL values in that column, then tried to make it non-nullable. It will subsequently try to migrate your existing data into that newly non-nullable column, which will break because you already have NULL values in there.

Two solutions:

1) Change it back to nullable
2) Give it a default value for items that don't have a value.

14
9/2/2013 8:50:03 AM

Related Questions

In a call to 'join' on nullable and non-nullable ints, type inference failed.

To compare Int? and Int, append ....Value... to the nullable property:...var result = from emp in employees join dept in departments on new { Source = emp.EmployeeID } equals new { Source = dept.EmployeeID.Value };
c# entity-framework linq non-nullable nullable
asked by Greg Sansom

Framework for Entities A nullable entity property is mapped to a non-nullable column.

2017 Update (Visual Studio 2017)...If the accepted straight-forward solution mentioned by lLya didn't help you, then this might. You may notice that when you save a diagram it does some work, like changing the class properties according to your diagram changes. One would think that the generator itself would be aware of these changes, right?! You m...
c# entity-framework mapping nullable poco
asked by DerpyNerd

5 Db Entity Framework UpdateException: A non-nullable member has a null value.

Complex types cannot be null - so you have to create an instance of the class before saving. This article helped me solve the same problem. ...http://weblogs.asp.net/manavi/archive/2011/03/28/associations-in-ef-4-1-code-first-part-2-complex-types.aspx
c# entity-framework
asked by Julian Dormon

Entity Framework via Code First, nullable property to entity field

The other option is to tell EF to allow the column to be null:...protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity<SomeObject>().Property(m => m.somefield).IsOptional(); base.OnModelCreating(modelBuilder); } ...This code should be in the object that inherits from ...DbContext....
asp.net-mvc-3 code-first entity-framework nullable
asked by Jon

Entity Framework Code First Using One column as Primary Key and another as Auto Increment Column

Apparently the ...answer... of @IronMan84 correct. But it didn't work for me. I slightly modified it to apply my another condition. And it worked. I did nothing else....This is my solution....public class Sale { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } [Key, Column(TypeName = "varchar"), MaxLeng...
c# ef-code-first entity-framework
asked by Seevali H Rathnayake

Select distinct on one column only using Entity Framework Code First

You can use ...DistinctBy(m=> m.SentBy)
c# entity-framework sql sql-server
asked by mark

Entity Framework Code-First - Define the Non-clustered key for this EntityType

AFAIK it is still not possible to create non-clustered primary key fields as part of your code first configuration....However, if you are using ...migrations... or are in a position where you are able to, see the following Entity Framework work item that goes through a solution using ...code first migrations... (as well as the thinking behind no di...
ef-code-first entity-framework entity-framework-6 entity-framework-6.1
asked by Matt Caton

Entity Framework 6 Code First int Identity column value is zero for first row

Your concrete migration class should look "something" like the following:...public class 201707132034165_MyAwesomeDbInitial : DbMigration { #region <Methods> public override void Up() { CreateTable( "dbo.HasOverdrive", c => new { HasOverdriveId = c.Int(nullable: false, identit...
c# ef-code-first entity-framework-6 sql-server
asked by Prisoner ZERO

How to create nullable one-to-many relationship in Entity Framwork 6 code first

First I would recommend doing a quick read of ...entityframeworktutorial... to make sure you have your keys set up as suggested. For a 1 to 1 relationship it is a little tricky; basically the primary key of the 'Child' is a foreign key to the 'Parent'....Alternatively you can use fluent API in the Data Context and do something like this to make sur...
c# entity-framework entity-framework-6
asked by Jared Stroebele

Entity Framework: one or more of the foreign-key properties is non-nullable

You have to analyze your object to solve this problem....Here some simple code to explain your ...Exception...:...static void Main() { using (MyDbContext ctx = new MyDbContext()) { // Build a new object MyClass o = new MyClass() { Id = 1, ChildObject = null }; // Add it to your Context (It's not in the DB yet!) ...
c# entity-framework entity-framework-6 exception sql-server
asked by kara

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow