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)" ); } }