asp.net - Link to Sql Update Row -

ok need update field active true code

  public static bool firstlogin(guid activationcode)     {          using (infinitynightdatacontext data = new infinitynightdatacontext())         {            user user = data.users.single(user => user.emailactivation == activationcode);               if (user != null)             {              user.active = true;             user.exp = "i has here";             data.submitchanges();                installmembershipcookie(user.userid, user.email, user.password, user.usertype, user.firstname, user.userimg, "", true);                  return true;              }             else             {                  return false;             }         }     } 

and after data.submitchanges(); can see changes on object user not in database in other function works in case it's don't work ..

any 1 know problem?

one possible option (as haven't said setup): using local database, or user instance, i.e. connection string contain attachdbfilename? if there copy of database in active bin folder (bin\debug, instance)? if there can attach sql express , see if change has appeared?