Hi mindcrackers,

Here's my code:

public List 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)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)getdata; Line 96: }

Thank You.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Akkiraju Ivaturi14y ago
DbQuery contains Include method so you don't need to convert to ObjectQuery. ObjectQuery is not accessible from DbQuery instance - it is wrapped in internal type InternalQuery and conversion operator is not defined.
0

Anonymous Types error: Retrieving data from different columns using linq

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]'.