remove auto increment from primary key

Question

Hi,

In an MVC app with code first I have a table with the key field as Long and the scaffolding made it automatic an auto increment field.

that is not what I wanted, I want to generate my own key. So I annotated the key field with:

 [Key]
 [DatabaseGenerated(DatabaseGeneratedOption.None)]

I ran the migration (Add-Migration and Update-Database) But nothing happens with the Primary key. sneeking in the Generated Migration SQL I do also not find anything that is relevant.

How can I do this??

---

Rob

Answer 1

Hi rob warning,

>>How can I do this??

Based on your description, I create a simple demo and reproduce your issue on my side. Because migrations can’t handle this operation yet, in SQL Server you can’t just make the change with an ALTER statement.

The following document provide a solution via custom migrations operation for your reference.

https://romiller.com/2013/04/30/ef6-switching-identity-onoff-with-a-custom-migration-operation/

Best regards,

Zhanglong Wu

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].