public void Add(Transaction transaction) { var parameter = new { transaction.FromCheckingAccountId, transaction.ToCheckingAccountId, transaction.Amount, transaction.Created }; var sqlInsert = $@" INSERT INTO [Transaction] ( FromCheckingAccountId , ToCheckingAccountId , Amount , Active , Created ) VALUES ( @FromCheckingAccountId , @ToCheckingAccountId , @Amount, 1 , @Created )"; db.ExecuteScalar(sqlInsert, parameter); }
public void UpdateBalance(long accountNumber, decimal newBalance) { var parameter = new { accountNumber, newBalance, updated = DateTime.UtcNow }; var sqlUpdate = $@"UPDATE CheckingAccount SET Balance = @newBalance, Updated = @updated WHERE AccountNumber = @accountNumber AND Active = 1"; db.ExecuteScalar(sqlUpdate, parameter); }