title: try to fetch new generated event id with linq to sql query
body: <p>suppose i have 100 event id in my table (dbo.event), and currently i generate 101 event id
  so i want to get only this event id(101) .i use linq to sql query for this.
  here is my code.</p>
  
  <pre><code>protected void getDataforemail(int EventID,int ClientID)
  {
          try
          {
              EventManagerDataContext db = new EventManagerDataContext();
              {
                  var q = from a in db.EMR_EVENTs
                          join b in db.EMR_CLIENTs on a.ClientID equals b.ClientID
  
                          where a.ClientID == ClientID
                          orderby a.EventID descending 
                          select new
                          {
                              EventID = a.EventID,
                              Client_Name = b.Name,
                              Event_Name = a.Name,
  
                          }.Take(1);
  
                   q.ToString();
              }
          }
          catch (Exception)
          {
              throw;
          }
      }
  </code></pre>
  
  <p>But this does not work for me, how can I fetch only newly generated <code>event_id</code> related data?</p>