I am starting a new ASP.NET 5 Preview template to play with client side development.
I have a database ( MS SQL ) that I want to access using the Web API and Entity Framework.
In my Models folder I do like I am used to do, add a new item and I want to add the ADO.NET Entity Data Model but it isn’t there.
What am I missing here?
UPDATE
This is the only thing I see when I try to add a new item to the project.
Client side and server side.
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
After a lot of research, I found out that there are some compatibility issues where come from the recent Microsoft migration to open source world (since Asp.net5) that I obtained from Data Points – The EF6, EF7 and ASP.NET 5 Soup MSDN Article. Read the full article please.
So if you wanna have both EF6 and Asp.net5, consider the article tips. And if you don’t persist in using Asp.net5, simply use Asp.net4.5 (following image) which have Ado.net Data Model in Add New Item dialog (I tested its availability with my Visual Studio Enterprise).
Method 2
May sound stupid, but since I got caught with this, it might be someone else’s issue too…
In VS 2015, there are 2 project templates called Class Library… one being in Windows and one in the Web and having (package) suffix. Apparently, besides misleading name they have nothing to do with each other and the second one clearly is not made to support EF models… Make sure you have created a proper project type or open a working solution made with different VS version.
__
Also this might help. I have it already installed, so not sure if it affects my configuration or not (shouldnt as EF tools are supposed to be shipped already with VS 2015):
http://thedatafarm.com/data-access/installing-ef-power-tools-into-vs2015/
Method 3
- Right click on project
- Choose Add and then New Item (or Simply press Ctrl+Shift+A)
- You will see a Data section which you can find what you are looking for
Or You can find another solution Here:
Missing ADO.NET entity data model template from visual studio 2012 professional
Method 4
Create New MVC Project using VS2015
- Right-Click on Model folder.
- Choose Add and then Select Class from the list.
- Now select ADO.Net Entity Data Model… and go for your selection.
Method 5
ADO.NET Entity Data Model missing Visual Studio 2017 Community
How to enable:
Open Visual Studio Installer -> Individual Components -> SDK’s, libraries, and frameworks -> Enable EntityFramework 6 tools-> Modify
Now, Add item in your project -> Data -> ADO.NET Entity Data Model.
Method 6
Note: While Creating project don’t select class Library(.NET Standard) Choose Class Library (.NET Framework)
Method 7
I solved the same problem by following these:
-
While Creating project don’t select class Library(.NET Standard)
Choose Class Library (.NET Framework) - Choose ASP.NET Web Application (.NET Framework)
- Go to Tools -> Get Tools and features. Select Individual components tab and check Entity Framework 6 tools under SDK’s, libraries, and framework section
- Remember you can’t make an ADO.net Entity Data Model with an interface with .NET Core, its only possible with .NET Framework.
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0


