public void CreateAccount(Account a)
 {
     var aResult = db.Database.SqlQuery<int>("EXEC CreateAccount @name, @balance, @householdId",
         new SqlParameter("name", a.Name),
         new SqlParameter("balance", a.Balance),
         new SqlParameter("householdId", a.HouseholdId)
         ).First();
 }
 public void EditAccount(Account a)
 {
     var aResult = db.Database.SqlQuery<Account>("EXEC EditAccount @name, @balance, @accountId",
                     new SqlParameter("name", a.Name),
                     new SqlParameter("balance", a.Balance),
                     new SqlParameter("accountId", a.Id)
                     );
 }
 public void ArchiveAccount(Account a)
 {
     var aResult = db.Database.SqlQuery<Account>("EXEC ArchiveAccount @accountId",
                     new SqlParameter("accountId", a.Id)
                     );
 }