linq to sql throwing an exception row not found or changed
<p>Hi I am linq to sql and i am getting the error of row not found or changed.</p>

<p>I am updating my table with the help of linq query then sometime it is showing this error.
I am unable to figure out this problem because sometimes it's working or sometime not.</p>

<p>But i am not getting any permanent solution to fix this problem.</p>

<pre><code>twtmob_campainincomedetails_tb incomedetails = dataContext.twtmob_campainincomedetails_tbs.Single(twtincome =&gt; twtincome.incomeid == tempincomes);
                decimal temppayout = decimal.Parse(lblpertweet.Text);
                decimal temptotal = temppayout + tempmoneyearned;
                incomedetails.moneyearned = Convert.ToString(temptotal);
                incomedetails.tweet = temptweet + 1;
                incomedetails.bonus = lblbonus.Text;
                incomedetails.budurl = tempbudurl;
                dataContext.SubmitChanges();

 twtmob_user_tb twtuserdetails = dataContext.twtmob_user_tbs.Single(twtdetail =&gt; twtdetail.twtmobuserid == tempUserId);
        {
            float temppayout = float.Parse(lblpertweet.Text);
            float tempoutstandingtotal = temppayout+tempoutstanding;
            twtuserdetails.outstandingbalances = tempoutstandingtotal;
            dataContext.SubmitChanges();
        }
</code></pre>
