I am able to do
var result = OAS_Questions.Count (oasq => oasq.Id!=0);
result.Dump();
and even
var result = OAS_Questions;
result.Dump();
But when I try to include child objects of "Questions" say "Opitons" through
var result = OAS_Questions.Include("OAS_QuestionOptions");
result.Dump();
I am shown the below error
'System.Data.Linq.Table' does not contain
a definition for 'Include' and no extension method 'Include' accepting
a first argument of type
'System.Data.Linq.Table' could be found
(press F4 to add a using directive or assembly reference)
I have already tried adding references to the below assembly references.
- System.Code
- System.Data
- System.Data.Entity
- System.Data.Linq
- System.Linq.Expressions
- System.Data.DataSetExtensions
But still the extension method "Include()" is not available while composing query and it gives a syntax error.
Best Answer
If you're using EF via LinqPad then a better method is to use the strongly typed version of
.Include
(http://msdn.microsoft.com/en-us/library/gg671236%28VS.103%29.aspx) as follows:EntityFramework.dll
System.Data.Entity
you then have intellisense and can use the strongly typed version of .Include, e.g.: