Ado.net & Entity Framework : creating entities

Question

I'm creating an entity diagram and I have a question about the StoreGeneratedPattern property on the Id's. I have both Identity and Computed options, and I'm not sure when to use each one. I guess that I should use Identity when it is generated by the entity and use Computed when is a foreign key, since is generated by another identity. Am I right or is the other way around ? Thanks!

marc_s · Accepted Answer · 2017-04-29 16:47:31Z

1

If you would just simply look at the official MSDN documentation for this property, you would see:

Member name    Description  
-----------------------------------------------------------------------------
Computed       A value is generated on both insert and update.
Identity       A value is generated on insert and remains unchanged on update.
None           A value indicating that it is not a server generated property.

So if you have a PK column that's an INT IDENTITY, then it's clear - use the Identity value.

The Computed value should be used for computed columns in your database tables, that are typically calculated on insert and re-calculated on update. This is NOT intended for foreign key columns! Those are just regular columns - do NOT set any StoreGeneratedPattern value for those!!

answered Apr 29, 2017 at 16:47

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

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

Collectives™ on Stack Overflow

Ado.net & Entity Framework : creating entities

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