Default values not mapping into edmx file

sophia · December 18th, 2011, 04:44 AM

Hi Imar,
Although we have set up the default values for createdatetime and updatedatetime in table schema but these default values are not mapped into edmx files. it shows only (None) under Default Value property for these fields in edmx file.
Why this happens and how a complete schema be mapped perfectly in edmx file ?

Thanks...

Imar · December 18th, 2011, 08:42 AM

It's just a default in the database, in case your code doesn't supply a value. It's not meant to be imported into the EDMX.

If you want a default in your code, create a partial class for your entity and set the default value in the default constructor.

Cheers,

Imar

sophia · December 18th, 2011, 09:19 AM

Thanks Imar,
But I have an extra field ViewCounts (bigint) in Reviews table, and have set a default value to 1 in Default Value or Binding Property.

When I inserted a new record without supplying any value for this column, the value got inserted was 0, and when I changed default value for this column in EDMX file to 1 then it inserted 1 in new record.

Why it got inserted 0 for the first case?

Thanks for link you posted.

Imar · December 18th, 2011, 09:35 AM

It's probably not nullable in the database. Therefore, EF creates a non-nullable integer that defaults to 0.

Imar

sophia · December 18th, 2011, 10:50 AM

what a vast knowledge you have. yes it does not allow null values.
Is it ok to set 1 manually in edmx file for that field.

Thanks...

Imar · December 18th, 2011, 11:38 AM

You could, but it would be a hardcoded default value, not something dynamic like GetDate in case of dates. I prefer to use a partial class and set the behavior through code.

But isn't zero for a ViewCount exactly right?

Imar

sophia · December 18th, 2011, 01:19 PM

Quote:

I prefer to use a partial class and set the behavior through code.

Thanks...

Quote:

But isn't zero for a ViewCount exactly right?

hummm, I will change it...