I have one list in which there is field with the datatype of Yes/No. I am trying to retrieve data of that field but it is giving me following error :

System.InvalidCastException: Specified cast is not valid. at Microsoft.SharePoint.Linq.SPQueryable.GetSPFieldValue[T](PropertyMap pm, DataContext dc, SPListItem item, Object entity, JoinPath joinPath) at lambda_method(ExecutionScope , SPListItem ) at System.Linq.Enumerable.WhereSelectEnumerableIterator2.MoveNext() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)

My query is as follows:

var query = (from san in db.San
             select san.IsDeclaredCompleted).ToList();

So can anyone suggest me what i am doing wrong?


Try to put ToList() method after db.San: db.San.ToList()
more detail

  • i have tried it.....and only thing changed is the error.... – Stark Jul 16 '12 at 11:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.