LINQ Table does not contain a definition for count (or any other Queryable extension methods)

Question

We are changing some legacy code to use LINQ to SQL.

In a seperate test throwaway class I tried making my db context and I can do

mydbcontext.mytable.Count()

fine, and it's all intellisensed.

However, when trying to implement this in the class (which is in the same assembly), the Queryable methods, such as Count, Where, etc are no longer valid.

Any ideas why this would be?

Answer 1

make sure you have using System.Linq;