Inserting Null to int field

Question

1.11/5 (2 votes)

See more:

Hi,

I am trying to insert null to int field in the database using Entity Framework.
That field is foreign key and nullable.

But it is giving exception of constraint while saving the changes.

Help me...

Thanks in Advance....

Posted 6-Oct-10 5:52am

Member 7217874

Add a Solution

Comments

Toli Cuturicu 6-Oct-10 14:59pm

Absurdity

thatraja 7-Oct-10 1:18am

Hi, The link is working now which was not worked in Answer1.

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AmbiguousName · Answer 1 · 2010-10-06T06:29:00

If this field is foreign key then it means it means that it is primary key in some table. Now how can the primary key be null?

A FOREIGN KEY constraint does not have to be linked only to a PRIMARY KEY constraint in another table; it can also be defined to reference the columns of a UNIQUE constraint in another table. A FOREIGN KEY constraint can contain null values; however, if any column of a composite FOREIGN KEY constraint contains null values, verification of all values that make up the FOREIGN KEY constraint is skipped. To make sure that all values of a composite FOREIGN KEY constraint are verified, specify NOT NULL on all the participating columns

Check This[^]

omarsoft20010 · Answer 2 · 2016-02-09T15:24:00

Solution 3

You Can use this :

C#

Nullable<int> value=null;
var entity = new Model()
           {
               Dbvalue = value
           };

  DataContext.Models.Add(entity);
  DataContext.SaveChanges();</int>

Omarsoft For IT Solutions

Posted 9-Feb-16 15:24pm

omarsoft20010

Dj@y · Answer 3 · 2016-02-09T19:17:00

Solution 4

you can use
int? i = null
this will help you

Posted 9-Feb-16 19:17pm

Dj@y

Inserting Null to int field

3 solutions

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0

Inserting Null to int field

3 solutions

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us