Can't find ADO.net Entity Data Model template

Question

I was trying to create an ASP.NET MVC web application in Visual Studio 2017. I need to take an EF database-first approach for the work.

Unfortunately I can't find the ADO.NET Entity Data Model template in my "Data" template folder:

I have tried following suggestions which didn't work for me.

1. Installing Entity Framework 6.x via NuGet
2. Installing package manually by double clicking latest msi file
3. Changing .NET version from 4.6.x to 3.5

NOTE: I have VS 2015 and VS 2017 both installed on my machine. Only VS 2017 has the problem.

I have created the ASP.NET MVC project as follows:

File -> New -> Project -> Web -> ASP.NET Web Application (.NET Framework) -> MVC

Does anyone know a solution for this problem?

Answer 1

For those of you trying the other solutions and still not seeing the templates...

Perhaps you are attempting to add ADO EF to a .NET Core 2.0 project, and EF is not supported out of the box.

You have 2 options:

1. Install Core 2.0 SDK and NuGet that is aware of .NET Standard 2.0
2. Use a .NET 4.x project rather than Core

I recommend #1. VS 2017 doesn't actually have the full Core 2.0 SDK installed, nor is it available from the VS installer (which many comments here struggle with).

I know, confusing, right?

From Microsoft:

"You will need to download and install a version of the .NET Core 2.0 SDK that is appropriate to your platform. This is true even if you have installed Visual Studio 2017 version 15.3."

"In order to use EF Core 2.0 or any other .NET Standard 2.0 library with a .NET platforms besides .NET Core 2.0 (e.g. with .NET Framework 4.6.1 or greater) you will need a version of NuGet that is aware of the .NET Standard 2.0 and its compatible frameworks"

https://blogs.msdn.microsoft.com/dotnet/2017/08/14/announcing-entity-framework-core-2-0/

Now... got all that installed and still not seeing the ADO template? I believe that is because it is deprecated/obsolete. This is the way to get EF working in .NET Core: https://docs.microsoft.com/en-us/ef/core/get-started/aspnetcore/existing-db

Hope this helps! You're welcome.

Answer 2

1. Go to Visual Studio 2017 Tools Menu => Click Get Tools and Features.
2. Expand More Drop down => Click on Modify.
3. Click on Individual components.
4. Choose Entity Framework 6 tools underSDK's, libraries, and frameworks => Click on Modify

Answer 3

in my case ,I had used ADO .NET before so I knew it was installed ..so I just typed ADO in the search box on the upper right corner , and THERE it was , SOLVED ! hope this helps

Answer 4

1. File -> New Project
2. Select Web -> ASP.NET Web Application (.NET Framework) image 1
3. Right Click Moduls -> Add -> New Item image 2
4. Choose Visual C# Then ADO.NET Entity Data Model image 3

Answer 5

Just simply open Visual studio setup. If you already installed choose to modify section and tick .NET desktop development option and install it.

Answer 6

i my case my project->properties->target framework was 2.0, i change to 4.5 and know it works know i see the ado.net entity data model.