Missing QueryableExtensions in EF 6

Question

I can't call the new QueryableExtensions (ToListAsync, ForEachAsync,...) provided with EntityFramework 6. But i can call others (Include, Intersect).

I've a reference to System.Data.Entity. So apparently, i've an older version of System.Data.Entity, with the latest version of EntityFramework. Is it possible?

My code does not compile and I cannot see the ForEachAsync method in the object browser.

I'm working with Visual Studio 2013, .Net 4.5, EntityFramework 6.1.3, Wpf.

Edit

Entity framework is installed :

I've tried to Uninstall then Reinstall package many times, with a restart of visual studio. Still not working

Edit

In another project (referenced by this one), I can see the IQueryableExtensions needed in the object browser. If I add this project to my solution (before it was only a reference), the IQueryableExtensions needed are missing in the object browser.

Answer 1

One of your projects is probably targeting an older version of the .net framework.

I had this issue when a project was targeting .Net v4.0, update it to 4.5 or newer. I also ran the command that others recommended after this.

update-package -reinstall EntityFramework 

You can see what version of .Net is is targeting when you run the update-package command in the package console. For example output from my project when it was targeting 4.0

PM> Update-Package –reinstall EntityFramework
Attempting to gather dependencies information for multiple packages with respect to project '[My project]', targeting '.NETFramework,Version=v4.0'

and then with v4.5.2:

PM> Update-Package –reinstall EntityFramework
Attempting to gather dependencies information for multiple packages with respect to project '[My Project]', targeting '.NETFramework,Version=v4.5.2'

You update your .net version by:

right clicking on the project in the solution explorer, 
choosing "Properties"
on the Application Tab (default) from the DropDown list labeled "Target Framework" select 4.5 (or greater - I chose 4.5.2)

There is a chance you don't need to reinstall the package, however I reinstalled before checking if it worked.

Answer 2

You need to reference the EntityFramework.dll. Remove the reference to System.Data.Entity.dll manually (if it is present).

Take a look at QueryableExtensions on MSDN

With Nuget it should be simple, cause this will add the dependencies fro you

install-package EntityFramework

or use the update command

Update-Package –reinstall EntityFramework

This will install the latest version of Entity Framework (6.1.3)