Bug #70602 .Net connector does not add auto_increment to bigint columns
Submitted: 11 Oct 2013 12:45 Modified: 31 Dec 2013 16:41
Reporter: M D Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:6.7.4 OS:Windows
Assigned to: Francisco Alberto Tirado Zavala CPU Architecture:Any
Tags: IDENTITY

[11 Oct 2013 12:45] M D
Description:
In EF5, when using the HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity) method, the column is not created with the AUTO_INCREMENT directive is the column is an Int64. I works perfectly for an Int32 column. When I looked at the source, i saw that only ints are supported, not bigints or possibly tinyint.

How to repeat:
Using EF5 code-first, create a model with an Int64 primary key.
update the database
Confirm that the AUTO_INCREMENT property IS NOT on the key column.

Create another model with an Int32 primary key
Update the database
Confirm that the AUTO_INCREMENT property IS on the key column.
[31 Oct 2013 21:40] Francisco Alberto Tirado Zavala
Hello MD.

I was able to replicate the issue, but using EF6. I can't reproduce it using EF5.
I'll take a look to know why is failing with EF6, but please can you provide the code or the project where the issue is?

Thanks for your time.
[11 Dec 2013 19:24] Daniel So
Added the following entry to the Connector/Net 6.6.7, 6.7.5, and 6.8.2 changelogs:

"Connector/Net did not add the AUTO_INCREMENT property to a primary key column of type BIGINT."
[11 Dec 2013 19:28] Daniel So
Adjusted changelog entry to:

"Connector/Net did not add the AUTO_INCREMENT property to a primary key column of type BIGINT when creating a model in Entity Framework."