C# Entity Framework 4.3

Question

EF is making some properties non nullable by default in the database, is there some way to over ride this for certain properties ? I tried searching for a data annotation but found nothing.

I am using code first the properties are an int and a datetime

Possibly a duplicate question - stackoverflow.com/questions/7941472/… — Chris Gessler
– Chris Gessler, Commented Mar 24, 2012 at 17:17

Justin Pihony · Accepted Answer · 2012-03-24 17:10:38Z

4

I am assuming that you are using code-first. You are probably getting non-nullable for types that are indeed non-nullable (value types), like int, bool, etc. You need to use the nullable version of these in order to do this:

int? MyColumnThatIsNullable

and NOT this

int MyColumnThatIsNOTNullable

Think about how the code would work and this will make sense to you. If a field is an int and a null is attempted to be passed into the code, then you will either have some sort of error, or a magic (default) value. This will not properly represent the value in the database. So, if you use the nullable version, then the null in the database can be represented for what it truly is, a null.

answered Mar 24, 2012 at 17:10

Justin Pihony

67.2k20 gold badges154 silver badges185 bronze badges

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

2 Comments

Roge Over a year ago

Hah! now that you mention it that makes perfect sense, and I cant figure out how I missed it. Thanks

Justin Pihony Over a year ago

@Roge No problem, I added an explanation below my original answer (although you said you got it :)). As usual accepted answers (once the 15 min grace period is up) and upvotes are appreciated :)

Collectives™ on Stack Overflow

C# Entity Framework 4.3

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related