ASP.NET

Dim query = From mm In dataContext.Mail_Message
                        Group Join mmr In dataContext.Mail_MessageRecipient On mm.MailMessageId Equals mmr.MailMessageId Into mmrm = Group From mrm In mmrm.DefaultIfEmpty
                        Group Join u In dataContext.Application_User On mm.SenderId Equals u.UserId Into us = Group From ums In us.DefaultIfEmpty
                        Group Join sr In dataContext.Personnel_StaffRecord On ums.StaffRecordId Equals sr.StaffRecordId Into srm = Group From smrm In srm.DefaultIfEmpty
                        Group Join ma In dataContext.Mail_MessageAttachment On mm.MailMessageId Equals ma.MailMessageId Into mam = Group From mamm In mam.DefaultIfEmpty
                        Where mm.MailMessageId = messageId
                        Select mrm.MailMessageRecipientId, smrm.Surname, smrm.Firstname, smrm.Othername, mm.Date, mm.Subject, mm.MailContent

            If query IsNot Nothing Then
                Dim row = query(1)
                With result
                    .MailMessageId = row.MailMessageRecipientId
                    .Sender = CStr(IIf(row.Surname Is Nothing, "BISM Limited", String.Format("{0} {1} {2}", row.Surname, row.Firstname, row.Othername)))
                    .Subject = row.Subject
                    .Body = row.MailContent
                    .Dates = row.Date
                    .RecipientNames = GetMailRecipients(messageId)
                    .Attachments = GetMailAttachments(messageId)
                End With
                ReadMessage(row.MailMessageRecipientId)
            End If

This is the error I get:

LINQ to Entities does not recognize the method 'VB$AnonymousType_48`7[System.Int64,System.String,System.String,System.String,System.DateTime,System.String,System.String] ElementAtOrDefault[VB$AnonymousType_48`7](System.Linq.IQueryable`1[VB$AnonymousType_48`7[System.Int64,System.String,System.String,System.String,System.DateTime,System.String,System.String]], Int32)' method, and this method cannot be translated into a store expression.

What am I getting wrong here?

public ActionResult Query()
{
    // How to get text box value?
    int cid = ... ?

    var data = from continents in db.Continents
               where continents.ContinentID == cid
               select continents;

    return View(data);
}

$("[id$='txtApplicant']").autocomplete("../../AutoSuggest.ashx");

public void ProcessRequest(HttpContext context)
        {
            HttpRequest Request = context.Request;
            HttpResponse Response = context.Response;

           // some code and logic here

           dtResult = getResult(cno,table,field,q);
           DataRow[] drs = dtResult.Select();
           foreach (DataRow dr in drs)
           {
               Response.Write(dr["Result"].ToString() + Environment.NewLine);  
           }
                        
        }

if (subordinateValueType.TaskTypeId > 0)
           {
               TaskTypeController taskTypeController = new TaskTypeController();
               subordinateValueTypeEntity.TaskType = taskTypeController.GetEntity(subordinateValueType

[System.InvalidOperationException] = {"A referential integrity constraint violation occurred: A primary key property that is a part of referential integrity constraint cannot be changed when the dependent object is Unchanged unless it is being set to the association's principal object

<sessionState mode="InProc" cookieless="UseCookies" timeout="10" >>

protected void Session_Start(object sender, EventArgs e)
        {
            if (Context.Session != null)
            {
                if (Context.Session.IsNewSession)
                {
                    string sCookieHeader = Request.Headers["Cookie"];
                                       

                    if ((null != sCookieHeader) && (sCookieHeader.IndexOf("ASP.NET_SessionId") >= 0))
                    {
                        //signout the user and redirect to the login page
                        FormsAuthentication.SignOut();
                        HttpContextBase httpContext = new HttpContextWrapper(HttpContext.Current);
                        UrlHelper urlHelper = new UrlHelper(new RequestContext(httpContext, new RouteData()));
                        string redirectUrl = urlHelper.Action("LogOn", "Account");
                        httpContext.Response.Redirect(redirectUrl);
                    }
                }
            }
        }