public override void Up() { Execute.WithConnection((connection, transaction) => { var userId = connection.Query <Guid>("SELECT [UserID] FROM [Membership].[User] WHERE [UserName] = @UserName", new { UserName = "******" }, transaction).First(); var accountParams = new { AccountNo = "3014" + Seed.RandomStringOfNumbers(9), CurrencyISOName = "USD", Balance = 10000m, OpenDateUtc = new DateTime(2014, 09, 1), ExpirationDateUtc = new DateTime(2015, 2, 1), Type = "CardAccount" }; connection.Execute(@"INSERT INTO [Accounting].[Account] ([AccountNo], [CurrencyISOName], [Balance], [OpenDateUtc], [ExpirationDateUtc], [Type]) " + "VALUES (@AccountNo, @CurrencyISOName, @Balance, @OpenDateUtc, @ExpirationDateUtc, @Type)", accountParams, transaction); connection.Execute(@"INSERT INTO [Accounting].[User_Account] ([AccountNo], [UserID]) VALUES (@AccountNo, @UserID)", new { AccountNo = accountParams.AccountNo, UserID = userId }, transaction); var cardParams = new { CardId = Guid.NewGuid(), CardNo = "4666" + Seed.RandomStringOfNumbers(2) + "00" + Seed.RandomStringOfNumbers(8), CardVendorId = "visa", HolderFirstName = "TERMINATOR", HolderLastName = "TERMINATOV", ExpirationDateUtc = new DateTime(2014, 12, 1) }; connection.Execute("INSERT INTO [Accounting].[Card] ([CardId], [CardNo], [CardVendorId], [HolderFirstName], [HolderLastName], [ExpirationDateUtc]) " + "VALUES (@CardId, @CardNo, @CardVendorId, @HolderFirstName, @HolderLastName, @ExpirationDateUtc)", cardParams, transaction); connection.Execute("INSERT INTO [Accounting].[User_Card_Account] ([CardId], [UserId], [AccountNo]) VALUES (@CardId, @UserId, @AccountNo)", new { CardId = cardParams.CardId, UserId = userId, AccountNo = accountParams.AccountNo }, transaction); connection.Execute("INSERT INTO [Accounting].[CardSettings] ([CardId], [Blocked], [LimitOperationsPerDayLocal], [LimitOperationsPerDayAbroad], [LimitAmountPerDayLocal], [LimitAmountPerDayAbroad]) " + "VALUES (@CardId, 0, 20, 10, 1000.0, 500.0)", new { CardId = cardParams.CardId }, transaction); }); }