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