Autogenerate primary key (Guid) Entity Framework CTP5

Question

I have a following POCO class

public class Account
    {
        [Key,DatabaseGenerated(DatabaseGenerationOption.Identity)]
        public string AccountId { set; get; }

        public string FirstName { set; get; }

        public string LastName { set; get; }

        public string Email { set; get; }


    }

I get the following exception when the database gets created

Identity column 'AccountId' must be of data type int, bigint, smallint, tinyint, or decimal or numeric with a scale of 0, and constrained to be nonnullable.

Note: This also happens if you use the "reserved" identity column name `Id` in your model class, even if you have `[Key,DatabaseGenerated(...)]` on it - you have to "rename away" your identity property in your model to something else, as in this case, `AccountId`. — Matt Borja, Sep 22 '16 at 20:11

score 8 · Accepted Answer · edited Aug 12 '14 at 18:55

8

Shouldn't you have:

    [Key,DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public Guid AccountId { set; get; }

?

edited Aug 12 '14 at 18:55

Andrius Naruševičius

8,348
7
49
78

answered Apr 10 '11 at 09:18

Jeff

35,755
15
108
220

Exactly...I have bymistakenly typed string...as soon as i changed it to Guid it worked....thanks – taher chhabrawala Apr 10 '11 at 09:55

Artiom · Answer 2 · 2014-01-05T17:46:14.487

Jeff's answer is right. Just a little tip for you. Using EF6 I wrote next configuration in order to set all fields with name "Id" and type "Guid" as identity.

modelBuilder.Properties<Guid>()
           .Where(info => info.Name.ToLower()== "id")
           .Configure(configuration => configuration.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity));

So I don't have to write [DatabaseGenerated(DatabaseGenerationOption.Identity)] everytime.

score 0 · Answer 3 · answered Apr 10 '11 at 09:18

Sound like you have to update your AccountId property from string to one of the mentioned datatypes in the exception:

int, bigint, smallint, tinyint, or decimal or numeric with a scale of 0, and constrained to be nonnullable

Any reason why it's now a string?

Autogenerate primary key (Guid) Entity Framework CTP5

3 Answers3

Linked