I am working on web application using OrmLite and Sql server.
I have created table "AgeGroups" with column "id" as PrimaryKey and Set Identity to True in Sql table, So that I can achieve autoincrement in my web application
But in application when I am trying to insert record it always gets "id" as 0 and don't auto increment
In my entity I have already used [Key] and Identity attribute to id column. Following is my table
public partial class age_groups
{
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int id { get; set; }
public string name { get; set; }
public DateTime created_at { get; set; }
public DateTime updated_at { get; set; }
}
I tried to use [AutoIncrement] attribute, but it says 'could not find assembly', so I am not sure which dll I am missing.
Also, Please help to save AutoIncrement Id in sql database, Any help will be appreciated.
Thank you in advance