Where condition in a LINQ lambda expression
<p>I am new to LINQ query expressions that use a <strong>lambda expression</strong>. I have one method by which I want to update the value in a different table.
It is working fine in single or default, but not when I use a Where condition.</p>

<pre><code>public static void UpdateData(int UserID)
{
    using (var objEntity = new DataContext())
    {

        UserMaster objUser = objEntity.UserMasters.SingleOrDefault(TBL =&gt; TBL.UserID == UserID);
        UserOfferUsed objUserUsed = objEntity.UserOfferUseds.Where(TBL =&gt; TBL.UserID == UserID);
        objUser.Purchaseon = DateTime.Now.ToString("dd MMMM  yyyy");
        objUserUsed.UsedCoupon = 0;
        objEntity.SaveChanges();
        objData = null;
    }
}
</code></pre>

<blockquote>
  <p>Error :Cannot implicitly convert type
  'System.Linq.IQueryable' to
  'Database.UserOfferUsed'. An explicit conversion exists (are you
  missing a cast?)</p>
</blockquote>