What should be the attribute for a Model property that corresponds to the Identity column of the database?

Answer:

The attribute in the Model field for the Identity column of the database should be DatabaseGenerated(System.ComponentModel.DataAnnotations.Schema.DatabaseGeneratedOption.Identity) like below

[Key]

[DatabaseGenerated(System.ComponentModel.DataAnnotations.Schema.DatabaseGeneratedOption.Identity)] 

[Required]

public int CategoryId { get; set; }

Thanks