Converting MVC4 Dbcontext to MVC5 ApplicationDbContext

Question

I'm currently cloning a MVC5 with Identity. I was previously coding a MVC4 Code First Entity Framework application and wanted to upgrade it to MVC5 because of Identitiy. I'm currently trying to add a controller but I need to choose a data context class. In MVC4 I made a dbcontext called Issue Context and was wondering how do I convert it so it's compatitble with ApplicationDbContext(MVC5)

IssueContext.cs in MVC4

public class IssueContext : DbContext
{
    public DbSet<User> Users { get; set; }
    public DbSet<Ticket> Tickets { get; set; }
    public DbSet<Category> Categories { get; set; }
    public DbSet<Department> Departments { get; set; }
    public DbSet<Depot> Depots { get; set; }


    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();

    }
}

ApplicationdbContext in IdentitiyModels.cs

public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
{
    public ApplicationDbContext()
        : base("DefaultConnection", throwIfV1Schema: false)
    {
    }

    static ApplicationDbContext()
    {
        Database.SetInitializer<ApplicationDbContext>(new ApplicationDbInitializer());
    }

    public static ApplicationDbContext Create()
    {
        return new ApplicationDbContext();
    }
}

Updated MV5 ApplicationDBContext.cs

public class ApplicationUser : IdentityUser
{
    public async Task<ClaimsIdentity> 
        GenerateUserIdentityAsync(UserManager<ApplicationUser> manager)
    {
        var userIdentity = await manager
            .CreateIdentityAsync(this, DefaultAuthenticationTypes.ApplicationCookie);
        return userIdentity;
    }

    public int UserID { get; set; } <---We don't need this right?

    public bool IsAdministrator { get; set; }
    [StringLength(50, MinimumLength = 1)]
    public string LastName { get; set; }
    [StringLength(50, MinimumLength = 1, ErrorMessage = "First name cannot be longer than 50 characters.")]

    [Column("FirstName")]
    public string FirstMidName { get; set; }

    public string FullName
    {
        get { return FirstMidName + " " + LastName; }
    }
    [DataType(DataType.Date)]
    [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}", ApplyFormatInEditMode = true)]
    public DateTime EnrollmentDate { get; set; }

    public int DepartmentID { get; set; }
    [ForeignKey("DepartmentID")]
    public virtual Department Department { get; set; }
    public int DepotID { get; set; }
    [ForeignKey("DepotID")]
    public virtual Depot Depot { get; set; }
    public virtual ICollection<Ticket> Tickets { get; set; }
}


public class ApplicationRole : IdentityRole
{
    public ApplicationRole() : base() { }
    public ApplicationRole(string name) : base(name) { }
    public string Description { get; set; }

}


public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
{
    public ApplicationDbContext()
        : base("DefaultConnection", throwIfV1Schema: false)
    {
    }


    public DbSet<Ticket> Tickets { get; set; }
    public DbSet<Category> Categories { get; set; }
    public DbSet<Department> Departments { get; set; }
    public DbSet<Depot> Depots { get; set; }

    static ApplicationDbContext()
    {
        Database.SetInitializer<ApplicationDbContext>(new ApplicationDbInitializer());
    }

    public static ApplicationDbContext Create()
    {
        return new ApplicationDbContext();
    }
}

}

Ebimie Abari · Accepted Answer · 2016-03-26 22:53:14Z

0

you need to make User class inherit from IdentityUser then remove users dataset while other data set remains intact.

public class ApplicationDbContext : IdentityDbContext<User>
{
public ApplicationDbContext()
    : base("DefaultConnection")
{
}

public DbSet<Ticket> Tickets { get; set; }
public DbSet<Category> Categories { get; set; }
public DbSet<Department> Departments { get; set; }
public DbSet<Depot> Depots { get; set; }

static ApplicationDbContext()
{
    Database.SetInitializer<ApplicationDbContext>(new ApplicationDbInitializer());
}

public static ApplicationDbContext Create()
{
    return new ApplicationDbContext();
}
}


public class User : IdentityUser{

  // other properties
}

answered Mar 26, 2016 at 22:53

Ebimie Abari

964 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TykiMikk Over a year ago

I've redited the question and added the updated version. Is that how we do it?? We don't need UserID because IdentityUser has it right?

James Culshaw · Accepted Answer · 2016-03-26 22:56:38Z

0

IdentityDbContext inherits DbContext. You can just add your DbSets from your original context to the ApplicationDbContext. However, you could use two separate Contexts, that way you don't have the identity tooling muddying up your database.

answered Mar 26, 2016 at 22:56

James Culshaw

1,0578 silver badges20 bronze badges

1 Comment

TykiMikk Over a year ago

So when I add a controller I just redirect it to my IssueContext?

Collectives™ on Stack Overflow

Converting MVC4 Dbcontext to MVC5 ApplicationDbContext

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related