how to change department id primary key to identity and do migration to database
Posted: Thu 10 Nov 2016 11:21
Problem
I need to modify class Department to make Department ID identity then make affect by migrations to database sql server 2005 .
What I Try
I changed [DatabaseGenerated(DatabaseGeneratedOption.None)] from None to identity .
then from console write enable-migrations but it give me message
Migrations have already been enabled in project 'University Data'. To overwrite
the existing migrations configuration, use the -Force parameter.I also using
-Force but no any result or changed happened .
my class Department
I have class department inside container Containerclass as following :
Table department already created in database.
update
1-
i write also in console
update-database but also nothing changed
2-
add-migration Department but also nothing changed column DepartmentID not changed to identity
3-
i add migration then write in up() and down()
but it not change column to identity
I need to modify class Department to make Department ID identity then make affect by migrations to database sql server 2005 .
What I Try
I changed [DatabaseGenerated(DatabaseGeneratedOption.None)] from None to identity .
then from console write enable-migrations but it give me message
Migrations have already been enabled in project 'University Data'. To overwrite
the existing migrations configuration, use the -Force parameter.I also using
-Force but no any result or changed happened .
my class Department
Code: Select all
[Table("Department")]
public partial class Department {
public Department()
{
}
[DatabaseGenerated(DatabaseGeneratedOption.None)]
[Key]
public int DepartmentID { get; set; }
public string DepartmentName { get; set; }
}
}Code: Select all
public partial class ContainerClass : DbContext
{
public ContainerClass() : base("name=mycon")
{
}
public virtual DbSet<Department> Departments { get; set; }
} update
1-
i write also in console
update-database but also nothing changed
2-
add-migration Department but also nothing changed column DepartmentID not changed to identity
3-
i add migration then write in up() and down()
Code: Select all
AlterColumn("dbo.Department", "DepartmentID", c => c.Int(nullable: false, identity: true));