Anonymous Types error: Retrieving data from different columns using linq

Question

Hi mindcrackers,

Here's my code:

public List<DAL.Assessment> search_by_id(Int64 id)
        {

            DAL.PVA_DBMSEntities objEntity = new DAL.PVA_DBMSEntities();
           
           var getdata = (from sub in objEntity.Subjects
                          from skul in objEntity.Schools
                          from leaner in objEntity.Learners
                          from ass in objEntity.Assessments
                          where (ass.Learner_Id == leaner.Learner_Id)
                          && (ass.Learner_Id == id) && (ass.Subject_Id == sub.Subject__Id)
                          select new
                          {
                              leaner.Learner_Id,
                              sub.Description,
                              ass.Assessment_type,
                              ass.Mark,
                          });
   return (List<DAL.Assessment>)getdata;
        }

Server Error in '/' Application.

---

Unable to cast object of type 'System.Data.Objects.ObjectQuery`1[<>f__AnonymousType3`4[System.Int32,System.String,System.String,System.Decimal]]' to type 'System.Collections.Generic.List`1[PVA.DAL.Assessment]'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidCastException: Unable to cast object of type 'System.Data.Objects.ObjectQuery`1[<>f__AnonymousType3`4[System.Int32,System.String,System.String,System.Decimal]]' to type 'System.Collections.Generic.List`1[PVA.DAL.Assessment]'.

Source Error:

Line 93:                           }); Line 94:  Line 95:            return (List<DAL.Assessment>)getdata; Line 96:         } 

Thank You.