Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

ado.net model for db is gone Visual studio 2015

Tags:

ado.net

model

After installing the community version of Visual Studio 2015, I've run into a problem with my database connector, the ADO.net model. I usually connect to that with EF 5 or 6 depending on whether I'm using MYSQL or SQL Server.

But I've run in to the problem that I simply don't see it anymore. This is what I see: http://i.imgur.com/idJH106.png

Compared to Visual Studio 2013: http://i.imgur.com/g4KTMeM.png

I've tried reinstalling EF6.

However I can't find out if this is intentional or not. Does anyone have any idea what I should do? I'll obviously stick to VS2013 as of now. But I wanna get working with 2015 asap.

like image 853
Dennis Pedersen Avatar asked Jul 22 '15 04:07

Dennis Pedersen


People also ask

How do I add ado net entity data model in Visual Studio?

Create the ADO.NET Entity Data Model Right-click on your project in the Solution Explorer window and select the menu option Add -> New Item. In the Add New Item dialog, select the Data category. Select the ADO.NET Entity Data Model template, give the Entity Data Model the name Northwind. edmx, and click the Add button.

Is ADO.NET going away?

ADO.NET has not been replaced, it's just been enhanced and built upon.


2 Answers

obviously the EF just isn't available for VS 2015 for now... I searched for hours now, but there seems to be no way to get this working. I'll use VS 2013 to update my data model from the database.

check the following link:

http://blogs.msdn.com/b/adonet/archive/2015/03/10/ef6-1-3-rtm-available.aspx

EDIT:

I found a solution :)

Just change your installation of VS 2015 and include the Microsoft SQL Server Data Tools (via Control Panel>Program & Features>VS2015>Change>Customize(? I see the german word there)>Windows- and Webdevelopment>Microsoft SQL Server Data Tools).

This will bring you back the .edmx designer and the ADO.NET model.

like image 167
Roman R. Avatar answered Nov 16 '22 01:11

Roman R.


Entity Framework is made up of the EF Tools for Visual Studio and the EF Runtime. Installing EF Tools (Entity Framework Tools) can help you find the missing templates .

In order to install newer version you could go to ->

C:\ProgramData\Package Cache

(paste the location to address tab of windows explorer)

you could find some folders in that location search for EFTools.msi,install the latest(if you find multiple) file .

Second solution is :

  1. Open your Visual studio installation package and find for : EFTools in /packages.
  2. Copy both .cab and .msi files of eftools
  3. Also create a Log.txt file in a folder where you are going to paste above files (you could use C:\Temp)
  4. Open cmd in Admin privilege and type : EFTools.msi USING_EXUIH=1 /log "Log.txt"
like image 21
Tharif Avatar answered Nov 16 '22 01:11

Tharif