Update

This is my User Table

FirstName

LastName

MoneyEarned

I need to set the MoneyEarned to 0 and I do not want to change the firstname and lastname that is already stored in the DB, this is my function can you anyone advise me please to rewrite the update function please.

        public void UpdateMoneyEarned(User user)
        {
            using (var db = new TeachableEntities())
            {
                user.MoneyEarned = 0;
                var q = db.Users;
                db.submitchanges();


            }
        }

Re: Update

use something like below

public void UpdateMoneyEarned(User user)
        {
            using (var db = new TeachableEntities())
            {
                
                User q = (from u in db.Users
		where u.UserID == user.UserID
		select u).FirstOrDefault();
	        q.MoneyEarned = 0
                db.submitchanges();
      
            }
        }

Re: Update

Error 1 'Teachable.Models.Data.TeachableEntities' does not contain a definition for 'submitchanges' and no extension method 'submitchanges' accepting a first argument of type 'Teachable.Models.Data.TeachableEntities' could be found (are you missing a using directive or an assembly reference?) C:\Teachable\Solution\Teachable\teachable.web\Models\ViewModels\ResourceListingVM.cs 534 21 Teachable.Web

I get an error here.

Re: Update

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