About Identity-Auto Increment Id in MVC

Guest User

5y5.5k.NET

Hello everyone,

Hope everyone is fine

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

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User5y ago
Thank you, Rizwan

I have tried your code,still It takes id as 0
if (ModelState.IsValid)
{
age_groups objAgeGroups = new age_groups();
objAgeGroups.name = fm.name
objAgeGroups.created_at = DateTime.Now;
objAgeGroups.updated_at= DateTime.Now;
val = objage.Save(objAgeGroups);
val.IsSuccess = true;
Rijwan Ansari5y ago
Your this code need to modify I guess.
..
if (ModelState.IsValid)
{
fm.created_at = DateTime.Now;
fm.updated_at= DateTime.Now;
val = objage.Save(fm);
val.IsSuccess = true;
...
Instead of taking direct fm from input initiate new obj before save like
if (ModelState.IsValid)
{
age_groups objAgeGroups = new age_groups();
objAgeGroups.name = fm.name
objAgeGroups.created_at = DateTime.Now;
objAgeGroups.updated_at= DateTime.Now;
val = objage.Save(objAgeGroups);
val.IsSuccess = true;
Do this for other save as well. Try and let me know.
Regards
Rijwan
Guest User5y ago
Thank you for reply Satya & Rizwan.

Following is my code :
[HttpPost]
public ActionResult Save([Bind(Exclude = "id")]age_groups fm)
{
List list = new List();
Do_Validation val = new Do_Validation();
if (ModelState.IsValid)
{
fm.created_at = DateTime.Now;
fm.updated_at= DateTime.Now;
val = objage.Save(fm);
val.IsSuccess = true;
if (val.IsSuccess == false)
{
ModelState.AddModelError(val.Property, val.Message);
list = objage.GetAllAgeGroups();
}
else
{
list = objage.GetAllAgeGroups();
}
}
else
{
val.IsSuccess = false;
val.Message = "Please correct the Error list.";
}
return Json(new { val = val, partialView = MvcHelper.RenderPartialView(this, "_AgeGroupListpartial", list, null) }, JsonRequestBehavior.AllowGet);
}
Following is my code inside Save function (In Service)
public Do_Validation Save(age_groups bm)
{
if (val.IsSuccess == true)
{
try
{
db.Save(bm);
val.Message = "Age Group added";
}
catch (Exception e)
{
val.IsSuccess = false;
val.Message = "Age Group not added.";
}
}
return val;
}
Following is My ageGroups 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; }
}
Satya Karki5y ago
Please, share your save function. There might be issue with save method.
Rijwan Ansari5y ago
Would you please share your insert function?

Regards
Rijwan
Guest User5y ago
how do you get this [AutoIncrement] attribute, because it is saying - the type or namespace [AutoIncrementAttribute] could not be found

I have used all namespaces
using System;
using ServiceStack.OrmLite;
using ServiceStack.DataAnnotations;
Sachin Singh5y ago
yes i forgot to mention autoincrement
please add all using statements and then
using System;
using ServiceStack.OrmLite;
using ServiceStack.DataAnnotations;

public partial class age_groups
{
[PrimaryKey]
[AutoIncrement]
public int id { get; set; }
public string name { get; set; }
public DateTime created_at { get; set; }
public DateTime updated_at { get; set; }
}
Guest User5y ago
Thank you for reply Sachin,

I have already using my entity like this, you can see my post.
Sachin Singh5y ago
using System;
using ServiceStack.OrmLite;
using ServiceStack.DataAnnotations;

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; }
}