cannot use "Include" in Linqpad

Question

I am connecting to an Oracle DB and want to do a simple query using Include:

but I am getting this error:

CS1061 'ISessionTable<People>' does not contain a definition for 'Include' and no extension method 'Include' accepting a first argument of type 'ISessionTable<People>' could be found (press F4 to add a using directive or assembly reference)

I have already added these References:

System.Data.Entity.dll
System.Data.Linq.dll

Yar · Accepted Answer · 2015-10-25T23:18:30.827

9

Here's what I did: First off, add EntityFramework.dll in you Additional References (Press F4!). If you can't find it, download it from here

Then switch to "C# Statement(s)" and add using System.Data.Entity; and it should work. It seems as an alternative you also can add System.Data.Entity in "Additional Namespace Imports".

edited Oct 25 '15 at 23:18

answered Oct 23 '15 at 17:59

Yar

7,020
11
49
69

1

I tried this, and I can still see it running multiple queries in the SQL view – UnionP May 30 '18 at 20:46

score 0 · Answer 2 · answered Oct 23 '15 at 17:45

0

Go to Query Properties and in 'Additional Namespaces', include System.Data.Objects

The Include method is not supported with LINQ to SQL.

See this.

answered Oct 23 '15 at 17:45

maxshuty

9,708
13
64
77

_Also, I take it that you're connecting to a custom Entity Framework context? The Include method is not supported with LINQ to SQL._ [their](http://forum.linqpad.net/discussion/205/include-extension-method-is-not-found) – dovid Jun 20 '19 at 09:24

cannot use "Include" in Linqpad

2 Answers2