public override void Up()
{
using (var context = new BestMoviesDBContext())
{
context.Database.ExecuteSqlCommand(
"INSERT INTO dbo.Genres (Name)"
+ " VALUES ('Comedy')"
);
context.Database.ExecuteSqlCommand(
"INSERT INTO dbo.Genres (Name)"
+ " VALUES ('Action')"
);
context.Database.ExecuteSqlCommand(
"INSERT INTO dbo.Genres (Name)"
+ " VALUES ('Drama')"
);
context.Database.ExecuteSqlCommand(
"INSERT INTO dbo.Genres (Name)"
+ " VALUES ('Horror')"
);
context.Database.ExecuteSqlCommand(
"INSERT INTO dbo.Genres (Name)"
+ " VALUES ('Fantasy')"
);
context.Database.ExecuteSqlCommand(
"INSERT INTO dbo.Genres (Name)"
+ " VALUES ('Sci-fi')"
);
}
}
public override void Up()
{
using (var context = new BestMoviesDBContext())
{
context.Database.ExecuteSqlCommand(
"UPDATE dbo.Customers SET DateOfBirth = '12/18/1963'"
+ " WHERE Id = 1"
);
}
}
public override void Up()
{
using (var context = new BestMoviesDBContext())
{
context.Database.ExecuteSqlCommand(
"INSERT INTO dbo.Movies (Title)"
+ " VALUES ('Shrek!')"
);
context.Database.ExecuteSqlCommand(
"INSERT INTO dbo.Movies (Title)"
+ " VALUES ('Mr. and Msr. Smith')"
);
}
}
public override void Up()
{
using (var context = new BestMoviesDBContext())
{
context.Database.ExecuteSqlCommand(
"INSERT INTO dbo.Customers (FirstName, LastName, IsSubscribedToNewsletter, MembershipType_Id)"
+ " VALUES ('Brad', 'Pitt', 1, 1)"
);
context.Database.ExecuteSqlCommand(
"INSERT INTO dbo.Customers (FirstName, LastName, IsSubscribedToNewsletter, MembershipType_Id)"
+ " VALUES ('Angelina', 'Jolie', 1, 2)"
);
}
}
public override void Up()
{
using (var context = new BestMoviesDBContext())
{
context.Database.ExecuteSqlCommand(
"INSERT INTO dbo.MembershipTypes (Name, SignUpFee, MonthsOfMembership, DiscountRate)"
+ " VALUES ('Pay as You Go', 0, 0, 0)"
);
context.Database.ExecuteSqlCommand(
"INSERT INTO dbo.MembershipTypes (Name, SignUpFee, MonthsOfMembership, DiscountRate)"
+ " VALUES ('Monthly', 30, 1, 10)"
);
context.Database.ExecuteSqlCommand(
"INSERT INTO dbo.MembershipTypes (Name, SignUpFee, MonthsOfMembership, DiscountRate)"
+ " VALUES ('Quarterly', 90, 3, 15)"
);
context.Database.ExecuteSqlCommand(
"INSERT INTO dbo.MembershipTypes (Name, SignUpFee, MonthsOfMembership, DiscountRate)"
+ " VALUES ('Annual', 300, 12, 20)"
);
}
}
