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?

1 Answer 1


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, 2012 at 11:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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