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