Property containing only the KeyAttribute attribute resulting in a self-incrementing column in the database

Question

Property containing only the KeyAttribute attribute resulting in a self-incrementing column in the database

Navigation

#1 by (1 votes)

2

If I'm not mistaken, this must have come in version 6.1.1 of EntityFramework and it was not like that in previous versions.

I believe that a column only became auto-increment when the DatabaseGenerated attribute was declared with the [DatabaseGenerated(DatabaseGeneratedOption.Identity)] signature.

I have a simple classes, like this:

public class Municipio
{
    [Key]
    public int Id { get; set; }

    [StringLength(50)]
    [Required(AllowEmptyStrings = false)]
    public string Descricao { get; set; }

    [StringLength(2)]
    [Required(AllowEmptyStrings = false)]
    public string Uf { get; set; }
}

Note that the Id property is declared with the KeyAttribute attribute only. However, an Autoincrement column is being generated.

How to prevent this from happening?

c# entity-framework entity-framework-6 auto-incremento

asked by anonymous 13.10.2014 / 21:53

1 answer

Find out which Primefaces component performed an action using jQuery function Framework (Java) for Opening Remote Sessions for Execution of Commands on Unix-based Server

score 1 · Accepted Answer

I believe a column only became auto-increment when the `DatabaseGenerated` attribute was declared with the `[DatabaseGenerated(DatabaseGeneratedOption.Identity)]` signature.

Not necessarily. Since the Entity Framework 5 the use of the attribute is optional.

How do you prevent this from happening?

Using [DatabaseGenerated(DatabaseGeneratedOption.None)] .

Property containing only the KeyAttribute attribute resulting in a self-incrementing column in the database

1 answer

I believe a column only became auto-increment when the DatabaseGenerated attribute was declared with the [DatabaseGenerated(DatabaseGeneratedOption.Identity)] signature.

How do you prevent this from happening?

I believe a column only became auto-increment when the `DatabaseGenerated` attribute was declared with the `[DatabaseGenerated(DatabaseGeneratedOption.Identity)]` signature.