Entity Model - How to use Database's Default Column Values while inserting

Question

I am using SQLServer 2008, WebForms, C#, Frameowrk 3.5, Entity Framework 1 I generated entity model from DB.

My DB has various tables & lets take example of one table user It has fields id, name, email, created_on, is_active, is_on_leave default values for is_active and on_leave properties are default to 0 ( zero ) in db

But When I try to insert a record in this table using entity model, it saves NULL in these fields. How to avoid this? I don't want to set a value for them from my page and want to use the one mentioned in DB.

How can I achieve that?

Community · Accepted Answer · 2017-05-23 10:34:20Z

3

This columns can be nullable. Right click property in designer, choose properties and set StoreGeneratedPatern for property to computed in the property window. I found similar question: Set default value in EF designer datetime

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered Jul 27, 2011 at 13:11

objectbox

1,2811 gold badge11 silver badges13 bronze badges

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

3 Comments

Steve Wilkes Over a year ago

Assuming 1. You have a default value because you don't ever want to have null in those columns, and 2. You have control over the database, it seems sensible to make the columns non-nullable. If either of those assumptions are incorrect, this is a good workaround :)

objectbox Over a year ago

I agree with the first assumption - if you set default, you do not want null in columns, but I disagree with that my solution is a workaround - he MUST set StoreGeneratedPattern even if he alter column and make it not nullable. If he only set not null in the db level, and not set storegeneratedpattern, he will receive an error because of the insertion of null value in the column that not allow null.

Steve Wilkes Over a year ago

If you set the column to non-nullable then update your model from the database, the property corresponding to the database field will be non-nullable and the EF will insert the default value of the property type, not null. In this case the default value of the property type is false, which is also the default value in the database. I'd say setting storegeneratedpattern cures the problem, but making the columns non-nullable prevents it.

Steve Wilkes · Accepted Answer · 2011-07-27 10:38:31Z

1

The is_active and is_on_leave columns in your database are nullable. If you make them non-nullable the default values should be used when you do an insert.

ALTER TABLE [user] ALTER COLUMN [is_active] DEFAULT(0) NOT NULL
ALTER TABLE [user] ALTER COLUMN [is_on_leave] DEFAULT(0) NOT NULL
GO

answered Jul 27, 2011 at 10:38

Steve Wilkes

7,1433 gold badges31 silver badges33 bronze badges

Collectives™ on Stack Overflow

Entity Model - How to use Database's Default Column Values while inserting

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related