ADO.NET Entity Framework and identity columns

.net sql-server entity-framework identity
matthew thomas picture matthew thomas · Sep 23, 2008 · Viewed 44k times · Source

Is the Entity Framework aware of identity columns?

I am using SQL Server 2005 Express Edition and have several tables where the primary key is an identity column. when I use these tables to create an entity model and use the model in conjunction with an entity datasource bond to a formview in order to create a new entity I am asked to enter a value for the identity column. Is there a way to make the framework not ask for values for identity columns?

Answer

biozinc picture biozinc · Dec 23, 2008

I know this post is quite old, but this may help the next person arriving hear via a Google search for "Entitiy Framework" and "Identity".

It seems that Entity Frameworks does respect server-generated primary keys, as the case would be if the "Identity" property is set. However, the application side model still requires a primary key to be supplied in the CreateYourEntityHere method. The key specified here is discarded upon the SaveChanges() call to the context.

The page here gives the detailed information regarding this.

Related questions

Like Operator in Entity Framework?

We're trying to implement the "LIKE" operator in Entity Framework for our entities with string fields, but it doesn't appear to be supported. Has anyone else tried to do something like this? This blog post summarizes the issue we're having. …

Read More
The DELETE statement conflicted with the SAME TABLE REFERENCE constraint with Entity Framework

I have a table with a self reference where the ParentId is an FK to the ID (PK). Using EF (code-first), I've set up my relationship as follows: this.HasOptional(t => t.ParentValue) .WithMany(t => t.ChildValues) .HasForeignKey(…

Read More
The number of primary key values passed must match number of primary key values defined on the entity

I've created a view in SQL Server that contains the most important columns from different tables. Printing the content of the table to the ASP.NET MVC view works fine, but when I want to get the details of a …

Read More