C# (CSharp) VaBank.Data.Migrations M2UserAccount示例

示例#1

文件： 28_SeedAccountsForTestUsers.cs 项目： developeramarish/vabank

 private void InsertUserAccount(M2UserAccount userAccount, IDbConnection connection, IDbTransaction transaction)
 {
     using (var command = connection.CreateCommand())
     {
         command.Transaction = transaction;
         command.CommandText = "INSERT INTO [Accounting].[User_Account] ([AccountNo], [UserID]) VALUES (@AccountNo, @UserID)";
         command.CreateSqlParameter("@AccountNo", userAccount.AccountNo);
         command.CreateSqlParameter("@UserID", userAccount.UserId);
         command.ExecuteNonQuery();
     }
 }

示例#2

文件： 44_SeedUserWithAccountAndCards.cs 项目： al-main/vabank

 private void InsertUserAccount(M2UserAccount userAccount, IDbConnection connection, IDbTransaction transaction)
 {
     using (var command = connection.CreateCommand())
     {
         command.Transaction = transaction;
         command.CommandText = "INSERT INTO [Accounting].[User_Account] ([AccountNo], [UserID]) VALUES (@AccountNo, @UserID)";
         command.CreateSqlParameter("@AccountNo", userAccount.AccountNo);
         command.CreateSqlParameter("@UserID", userAccount.UserId);
         command.ExecuteNonQuery();
     }
 }