Missing "Ado.Net Entity Data Model" on Visual Studio 2013

S

13

29

I have created new web project but I can't find ADO.net Entity DAta Model to add it.

enter image description here

How to fix it or Install it ?

Spirometer answered 13/4, 2014 at 17:42 Comment(1)

Readers: Also see this SO question Can't find ADO.net Entity Data Model template in VS2017 – Palaeozoology 9/11, 2017 at 5:23

B

36

Go to "C:\ProgramData\Package Cache" and search for "EFTools.msi".

You should find two files, just install the most recent one (it should be about 960KB). This fixed the problem for me.

Berezina answered 15/4, 2014 at 10:53 Comment(0)

P

20

i have the same problem, but there is no "EFTools.msi" in "C:\ProgramData\Package Cache" for me...

UPDATE : i download and install "Entity Framework 6 Tools for Visual Studio 2012 & 2013" and it solved the problem \m/

Download Link

Posner answered 2/7, 2014 at 19:36 Comment(1)

Great, you forgot to view hidden files. That is why you are not able to wave down to EFTools.msi file. @MahdiRashid – Darrel 16/12, 2015 at 8:6

A

7

Some web tutorials show a 'ADO.NET data entity model' item in the 'Models->Add' menu. In VS2015 this menu item is not shown. You need to keep drilling down by selecting 'New Item...' and then further selecting 'Data' from the pop-up dialog.

Ampliate answered 12/2, 2016 at 19:35 Comment(1)

This is more relevant now, with VS 2015 than with the accepted answer. Should be higher up – Fractious 1/3, 2016 at 7:44

S

4

My solution was none like the above. The .msi file was nowhere in the folders suggested in prior answers, nor doing a search in my hard drive found any EFTools.msi instances.

So the failsafe approach came through this article (since the author appears to have completely removed the page from the server, I've changed the URL to a version of the page stored in Google's cache), which was poorly written by a chinese fella, so I'm gonna try to rewrite the steps in a clearer way:

The solution is as follows:

Open your VS2013 installation ISO (or pop the DVD in) and navigate to "\packages\EFTools" folder;
There you will find 2 files (a .cab file and a .msi file);
Copy both files to a directory on your hard drive;
[Optional]: You can create in that same directory, an empty .txt file ("Log.txt") so that the installation log output will be redirected to it later;
Open a MS-DOS command prompt (with administrative rights) and type the command: EFTools.msi USING_EXUIH=1 /log "Log.txt" [NOTE: If you did not perform step #4, then you do not need to type from the ' /log' on (inclusive)]
Wait patiently while the installation process finishes. Takes quite some time (guess never hurts to remind you that this needs to be done with VS2013 closed). The installation should go fine, anything weird will be logged into the text file (the one you created in step #4).

Or, you might just double-click the .msi file if you are feeling brave..

After installation, open VS2013 and try adding a new item to the Models folder. The "ADO.NET Entity Data Model" should have reappeared under the "Data" tab.

Recognition goes to the anonymous chinese poster on that link (er, "Melinda"?) - xiè-xiè!

Sec answered 17/7, 2015 at 20:4 Comment(1)

My situation was identical to yours - no EFTools.msi to be found except on the installation media. Thanks! – Kuomintang 6/8, 2015 at 18:30

Y

3

Be sure you are trying to do that in .Net Framework project. For example, when you are creating a project do not use a template called Windows Forms App (.Net Core), use Windows Forms (.Net Framework). The (.Net Framework) extension is important.

Yokoyokohama answered 15/2, 2020 at 16:38 Comment(0)

G

2

right click on your project--> properties---> framework target select 4.5 and should work.

Glaser answered 15/11, 2015 at 21:39 Comment(2)

This is completely different from all other answers, are you sure this answers the question? – Disobey 15/11, 2015 at 22:6

yes when change the target franework of the project to higher version then the ado model will appear in the list – Glaser 3/1, 2016 at 13:49

S

1

It's only for Visual Studio 2012. For me this had no effect on 2013.

Sere answered 15/4, 2015 at 17:28 Comment(1)

i'm using VS 2013, and it worked, try changing .Net framework :) – Posner 7/6, 2015 at 7:45

J

1

For the record, if you have Visual Studio 2015 RC, the "EFTools.msi" can't be downloaded from Microsoft

If you accidentally delete the "ProgramData" folder, the Repair option will not work, you have to use the Add or Remove features option from the installer, and check the SQL Server Data Tools

Jocelynjocelyne answered 15/7, 2015 at 18:6 Comment(0)

C

1

Make sure the type of project you've added is for .NET Framework and not for .NET Standard. The templates for adding things such as ADO.NET Entity Data Model are included for .NET Framework.

Clearwing answered 31/10, 2018 at 20:54 Comment(0)

B

1

For Visual Studio 2017 the following works.

Create project:

Create new project of type 'Class Library'
Install 'Entity Framework' from NuGet

Now add datamodel:

In project click 'Add New Item'
Select 'Visual C# Items' -> 'ADO.NET Entity Data Model'

Britneybritni answered 16/7, 2019 at 7:26 Comment(0)

K

1

I recently added Entity Framework and installed in one of my many projects in a single sln file.

The thing is Entity Framework works on Framework higher than 3.5.

So Class Library of NET Standard wouldn't support Entity Framework, thus missing Ado.Net Entity Data Model, Since NET Standard console Library is Framework 2.0, changing the class Library to .NET Framework one, will include Ado.Net Entity Data Model.

Klinger answered 26/3, 2020 at 20:0 Comment(0)

T

1

I had the same issue, but found out that I was selecting ASP.NET Core web App, ASP.NET Core web App(MVC) etc, Instead Choose ASP.NET Web Application (.NET Framework) and you will get the ADO.NET Entity Data Model option.

Recommended topics

Hot tags