dataannotations set identity seed value on Primary Key with code first

asp.net-mvc-3, data-annotations, ef-code-first

Solution

Thanks Craig, after looking at https://stackoverflow.com/a/5974656/968301 it was pretty simple.

Create an intializer

public class MyInitializer : DropCreateDatabaseIfModelChanges<MyContext> 
{   
  protected override void Seed(MyContext context) 
  {   
    context.Database.ExecuteSqlCommand("DBCC CHECKIDENT ('Account', RESEED, 1000000)");
  }  
}

Then call from the Application_Start section of the Global.asax.cs

protected void Application_Start()
{
  Database.SetInitializer(new MyInitializer());
  AreaRegistration.RegisterAllAreas();

  RegisterGlobalFilters(GlobalFilters.Filters);
  RegisterRoutes(RouteTable.Routes);
}

Problem

ASP.NET MVC3 code first project. In my class definition how do I set the Identity seed value. ``` public class Account { [Key] public int Id { get; set; } ``` What would be the syntax to set the Identity seed to 1000000? Thank you

Original source

Related problems