sorry you have to use SaveChanges instead. and use Single() instead of FirstorDefault
public void UpdateMoneyEarned(User user)
{
using (TeachableEntities db = new TeachableEntities())
{
User q = (from u in db.Users
where u.UserID == user.UserID
select u).Single();
q.MoneyEarned = 0
db.SaveChanges();
}
}
Please 'Mark as Answer' if my post helped you
--------------------------------------------------
Muhammad Amin
محمد امين
mameenkhn
Contributor
2026 Points
391 Posts
Re: Update
Mar 26, 2012 09:39 AM|LINK
sorry you have to use SaveChanges instead. and use Single() instead of FirstorDefault
public void UpdateMoneyEarned(User user) { using (TeachableEntities db = new TeachableEntities()) { User q = (from u in db.Users where u.UserID == user.UserID select u).Single(); q.MoneyEarned = 0 db.SaveChanges(); } }--------------------------------------------------
Muhammad Amin
محمد امين