Long Le's Blog

After creating a new C# MVC4 application in VS 2012, for migrations and simplemembership, do the following

1. Check the Connection String in the web.config. If using Machine\SQLExpress

2. In Web.Config

3. After PM> enable-migrations, in Configuration.cs

#region

using System;
using System.Data.Entity;
using System.Data.Entity.Migrations;
using System.Linq;
using System.Web.Security;
using TSBVISTP.Models;
using WebMatrix.WebData;
using System.Collections.Generic;

#endregion

namespace TSBVISTP.Migrations
{
internal sealed class Configuration : DbMigrationsConfiguration
{
public Configuration()
{
AutomaticMigrationsEnabled = true;
}

protected override void Seed(STPDBContext context)
{
// This method will be called after migrating to the latest version.

// You can use the DbSet.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data. E.g.
//
// context.People.AddOrUpdate(
// p => p.FullName,
// new Person { FullName = “Andrew Peters” },
// new Person { FullName = “Brice Lambson” },
// new Person { FullName = “Rowan Miller” }
// );
//
WebSecurity.InitializeDatabaseConnection(“DefaultConnection”, “UserProfile”, “UserId”, “UserName”,
autoCreateTables: true);
if (!Roles.RoleExists(“Administrator”))
Roles.CreateRole(“Administrator”);
if (!WebSecurity.UserExists(“UserGA”))
WebSecurity.CreateUserAndAccount(“UserGA”, “password”,
new
{
FirstName = “User”,
LastName = “GA”,
userAddress = “123 something dr”,
userCity = “Austin”,
userZip = “78750″,
WorkPhone = “512-555-5555″,
AlternatePhone = “512-668-7898″,
FaxNumber = “512-232-1212″,
EmailAddress = “Simitt@gmail.com”
}, false);
if (!Roles.GetRolesForUser(“UserGA”).Contains(“Administrator”))
Roles.AddUsersToRoles(new[] {“UserGA”}, new[] {“Administrator”});

//var students = new List
//{
// new Student { FirstMidName = “Carson”, LastName = “Alexander”, EnrollmentDate = DateTime.Parse(“2005-09-01″) },
// new Student { FirstMidName = “Meredith”, LastName = “Alonso”, EnrollmentDate = DateTime.Parse(“2002-09-01″) },
// new Student { FirstMidName = “Arturo”, LastName = “Anand”, EnrollmentDate = DateTime.Parse(“2003-09-01″) },
// new Student { FirstMidName = “Gytis”, LastName = “Barzdukas”, EnrollmentDate = DateTime.Parse(“2002-09-01″) },
// new Student { FirstMidName = “Yan”, LastName = “Li”, EnrollmentDate = DateTime.Parse(“2002-09-01″) },
// new Student { FirstMidName = “Peggy”, LastName = “Justice”, EnrollmentDate = DateTime.Parse(“2001-09-01″) },
// new Student { FirstMidName = “Laura”, LastName = “Norman”, EnrollmentDate = DateTime.Parse(“2003-09-01″) },
// new Student { FirstMidName = “Nino”, LastName = “Olivetto”, EnrollmentDate = DateTime.Parse(“2005-09-01″) }
//};
//students.ForEach(s => context.Students.Add(s));
//context.SaveChanges();

//var Staffs = new List
//{
// new Staff { FirstMidName = “Kim”, LastName = “Abercrombie”, HireDate = DateTime.Parse(“1995-03-11″) },
// new Staff { FirstMidName = “Fadi”, LastName = “Fakhouri”, HireDate = DateTime.Parse(“2002-07-06″) },
// new Staff { FirstMidName = “Roger”, LastName = “Harui”, HireDate = DateTime.Parse(“1998-07-01″) },
// new Staff { FirstMidName = “Candace”, LastName = “Kapoor”, HireDate = DateTime.Parse(“2001-01-15″) },
// new Staff { FirstMidName = “Roger”, LastName = “Zheng”, HireDate = DateTime.Parse(“2004-02-12″) }
//};
//Staffs.ForEach(s => context.Staffs.Add(s));
//context.SaveChanges();

//var departments = new List
//{
// new Department { Name = “English”, Budget = 350000, StartDate = DateTime.Parse(“2007-09-01″), PersonId = 9 },
// new Department { Name = “Mathematics”, Budget = 100000, StartDate = DateTime.Parse(“2007-09-01″), PersonId = 10 },
// new Department { Name = “Engineering”, Budget = 350000, StartDate = DateTime.Parse(“2007-09-01″), PersonId = 11 },
// new Department { Name = “Economics”, Budget = 100000, StartDate = DateTime.Parse(“2007-09-01″), PersonId = 12 }
//};
//departments.ForEach(s => context.Departments.Add(s));
//context.SaveChanges();

//var programs = new List
//{
// new Program { ProgramId = 1050, Title = “ASE”, Credits = 3, DepartmentId = 3, Staffs = new List() },
// new Program { ProgramId = 4022, Title = “ESC2″, Credits = 3, DepartmentId = 4, Staffs = new List() },
// new Program { ProgramId = 4041, Title = “SWEAT”, Credits = 3, DepartmentId = 4, Staffs = new List() },
// new Program { ProgramId = 1045, Title = “ESE”, Credits = 4, DepartmentId = 2, Staffs = new List() },
// new Program { ProgramId = 3141, Title = “ASE2″, Credits = 4, DepartmentId = 2, Staffs = new List() },
// new Program { ProgramId = 2021, Title = “SWT”, Credits = 3, DepartmentId = 1, Staffs = new List() },
// new Program { ProgramId = 2042, Title = “ABC”, Credits = 4, DepartmentId = 1, Staffs = new List() }
//};
//programs.ForEach(s => context.Programs.Add(s));
//context.SaveChanges();

//programs[0].Staffs.Add(Staffs[0]);
//programs[1].Staffs.Add(Staffs[1]);
//programs[2].Staffs.Add(Staffs[2]);
//programs[3].Staffs.Add(Staffs[2]);
//programs[4].Staffs.Add(Staffs[3]);
//programs[5].Staffs.Add(Staffs[3]);
//programs[6].Staffs.Add(Staffs[3]);
//programs[7].Staffs.Add(Staffs[3]);
//context.SaveChanges();

//var enrollments = new List
//{
// new Enrollment { PersonId = 1, ProgramId = 1050, Grade = 1 },
// new Enrollment { PersonId = 1, ProgramId = 4022, Grade = 3 },
// new Enrollment { PersonId = 1, ProgramId = 4041, Grade = 1 },
// new Enrollment { PersonId = 2, ProgramId = 1045, Grade = 2 },
// new Enrollment { PersonId = 2, ProgramId = 3141, Grade = 4 },
// new Enrollment { PersonId = 2, ProgramId = 2021, Grade = 4 },
// new Enrollment { PersonId = 3, ProgramId = 1050 },
// new Enrollment { PersonId = 4, ProgramId = 1050, },
// new Enrollment { PersonId = 4, ProgramId = 4022, Grade = 4 },
// new Enrollment { PersonId = 5, ProgramId = 4041, Grade = 3 },
// new Enrollment { PersonId = 6, ProgramId = 1045 },
// new Enrollment { PersonId = 7, ProgramId = 3141, Grade = 2 },
//};
//enrollments.ForEach(s => context.Enrollments.Add(s));
//context.SaveChanges();

//var officeAssignments = new List
//{
// new ClassAssignment { PersonID = 9, Location = “Class 1″ },
// new ClassAssignment { PersonID = 10, Location = “Class 27″ },
// new ClassAssignment { PersonID = 11, Location = “Class 304″ },
//};
//officeAssignments.ForEach(s => context.OfficeAssignments.Add(s));
//context.SaveChanges();

var menus = new List
{
new Menu {Id = 1, Name = “Main”, MenuItems = new List()},

};
menus.ForEach(s => context.Menus.Add(s));
context.SaveChanges();

var menuitems = new List
{
new MenuItem
{
Id = 1,
Name = “Home”,
ActionName = “Index”,
ControllerName = “Home”,
Url = “”,
ParentMenu = menus[0]
},
new MenuItem
{
Id = 2,
Name = “Student”,
ActionName = “Index”,
ControllerName = “Student”,
Url = “”,
ParentMenu = menus[0]
},
new MenuItem
{
Id = 3,
Name = “Staff”,
ActionName = “Index”,
ControllerName = “Staff”,
Url = “”,
ParentMenu = menus[0]
},
new MenuItem
{
Id = 4,
Name = “Programs”,
ActionName = “Index”,
ControllerName = “Program”,
Url = “”,
ParentMenu = menus[0]
},
new MenuItem
{
Id = 5,
Name = “Residential”,
ActionName = “Index”,
ControllerName = “Department”,
ParentMenu = menus[0]
},
new MenuItem
{
Id = 6,
Name = “About”,
ActionName = “About”,
ControllerName = “Home”,
Url = “”,
ParentMenu = menus[0]
},
new MenuItem
{
Id = 7,
Name = “Contact”,
ActionName = “Contact”,
ControllerName = “Home”,
Url = “”,
ParentMenu = menus[0]
},
};
menuitems.ForEach(s => context.MenuItems.Add(s));
context.SaveChanges();

}
}
}

4. update-database -verbose

5. In SQL run update query to add columns

GO
ALTER TABLE [dbo].[UserProfile]
ADD [FirstName] VARCHAR (50) NULL,
[LastName] NVARCHAR (50) NULL,
[userAddress] NVARCHAR (50) NULL,
[userCity] NVARCHAR (50) NULL,
[userZip] NVARCHAR (50) NULL,
[WorkPhone] NVARCHAR (50) NULL,
[AlternatePhone] NVARCHAR (50) NULL,
[FaxNumber] NVARCHAR (50) NULL,
[EmailAddress] NVARCHAR (50) NULL;

6. PM> update-database -verbose

you must see migrations working.now.