How to make Entity Framework auto-increment IDs when using code-first

Question

I'm using the code-first approach and because of that I do not have the .edmx file so I cannot change the StoreGeneratedPattern attribute. How do I then make EF auto-increment the IDs? (right now all IDs are zeros by default)

what you are looking for is DatabaseGeneratedAttribute with DatabaseGeneratedOption as Identity. — Hopeless
– Hopeless, Commented Sep 26, 2015 at 14:43
When I use DatabaseGeneratedOption.None it doesn't auto-increment, but when I use DatabaseGeneratedOption.Identity it doesn't even generate the Id (leaves it null) — Kipras
– Kipras, Commented Sep 26, 2015 at 16:07

Jaanus Varus · Accepted Answer · 2015-09-26 14:52:29Z

1

A primary key with auto-increment (default behavior) is generated if any of the following holds true:

The class contains a property named "Id"
The class contains a property named $className + "Id"
The property of interest is annotated with KeyAttribute

Might it be that your property is named "ID" instead of "Id" without the Key attribute?

edited Sep 26, 2015 at 14:52

answered Sep 26, 2015 at 14:45

Jaanus Varus

3,6033 gold badges34 silver badges52 bronze badges

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

2 Comments

Kipras Over a year ago

I use the Key attribute and the property is named Id

Jaanus Varus Over a year ago

What is the type of the property? int or something else?

phitch · Accepted Answer · 2015-09-26 15:05:58Z

1

There are three ways to specify keys using EF code first:

Use built-in code conventions (his first two bullets)
Use the KeyAttribute data annotation directly on the property/field
Use the Fluent API to specify the key field

answered Sep 26, 2015 at 15:05

phitch

1259 bronze badges

Collectives™ on Stack Overflow

How to make Entity Framework auto-increment IDs when using code-first

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related