How to set null foreign key in Entity Framework code-first

Question

I have a Order < Customer model.

How do I set this up? When I try to insert a user with a null customerid, it tells me that it cannot be null.

The model is as follows:

public class Order
{
    public long OrderID { get; set; }
    public int CustomerID { get; set; }
    public virtual Customer Customer { get; set; }
    public virtual ICollection<OrderDetail> OrderDetails { get; set; }
}

public partial class Customer
{
    public int CustomerID { get; set; }   
}

In DbContext :

modelBuilder.Entity<Customer>()
            .HasMany(e => e.Orders)
            .WithRequired(e => e.Customer)
            .WillCascadeOnDelete(false);

You need to make the CustomerID property nullable: public int? CustomerID { get; set; } — Felipe
– Felipe, Commented Feb 26, 2017 at 7:33
Could you clarify your questions, as I don't understand "A user belongs to a country, but may not belong to any (null foreign key)". What does that mean to you? What does it have to do with the Order class you present? Please be a bit more precise with your question. Optionally, from what I can observe you can try to make the CustomerID property nullable. (edit: just like @Felipe Cruze just mentioned above :)) — Yves Schelpe
– Yves Schelpe, Commented Feb 26, 2017 at 7:34
You are talking about problems with user and country but the code deals with customer and order. Did not make sense to me — Sir Rufo
– Sir Rufo, Commented Feb 26, 2017 at 8:27

Oleg Tamarintsev · Accepted Answer · 2017-02-26 11:19:56Z

1

Have you tried to replace line

.WithRequired(e => e.Customer)

with

.WithOptional(e => e.Customer)

?

And I make the CustomerID property nullable: public int? CustomerID { get; set; }

edited Feb 26, 2017 at 11:19

answered Feb 26, 2017 at 9:56

Oleg Tamarintsev

437 bronze badges

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

Collectives™ on Stack Overflow

How to set null foreign key in Entity Framework code-first

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related