Entity Framework 6 - Knowledge Base (KB)
26 results in tag: visual-studio-2017
Can't enable migrations for Entity Framework on VS 2017 .NET Core
I just installed VS 2017 and created a new Core project. Inside it, I added:...Microsoft.EntityFrameworkCore (1.1.0)...Microsoft.NETCore.App (1.1.0)...I also created a folder called Models with a class in it. Then, I went to the Package Manager Console an...
asked by Konrad Viltersten
SQLite provider in VS2017
I want to connect sqlite using EF6 in VS2017. I installed "System.Data.SQLite" nuget package. I also installed "sqlite-netFx46-setup-bundle-x86-2015-1.0.104.0.exe" from ...http://system.data.sqlite.org..., but I cannot see the sqlite provider when adding ...
asked by Raymond Wong
Entity Framework not appearing in Add New Item list in Visual Studio 2017
I created a new MVC project in Visual Studio 2017. I wanted to add an EDMX file (I will be doing database-first) so right clicked on the project and selected Add|New Item....However, I cannot find the Entity Framework components that were available in the...
asked by Jonathan Wood
UTF-8 in *.cshtml
I edit the text, my english is very, very... bad...Hi!!!...I have a problem with UTF-8 in Visual Studio 2017....I work with Asp.Net Core 1.1 and need UTF-8 in my CSHTML files....The Some way i found to change the codification is goining in File->Save As....
asked by Renato Vieira
How can I install Entity Framework Power Tools for Visual Studio 2017?
I try to install Entity Framework Power Tools for Visual Studio 2017 but it does not see Visual Studio 2017. What should I do?
asked by B. UlaÅŸ Åženol
Where are Entity Framework Tools in EF6 and Visual Studio 2017?
I'm using Visual Studio 2017 and Entity Framework 6, and for the life of me, I cannot find the EDMX file, Entity Data Tools, Model Browser, or Entity Designer......Am I losing my mind here? I've created multiple new projects trying to find these UI-based ...
asked by gotmike
What is the replacement in Visual Studio 2017 for Entity Framework 'database first'
Simple question - I'm working in Visual Studio 2017 and while I know that the 'database first' approach in EF is gone, I'm wondering what the replacement is. What I specifically would like to do is generate classes from an existing database. I see this:...
asked by Ev Conrad
Can't find ADO.net Entity Data Model template in VS2017
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 follow...
asked by Sandaru
WinForms Entity Framework database connection exception at design-time
Environment: I have a Visual Studio 2017 solution with a Model project containing Entity Framework (EF6) DbContext and POCOs, a data access layer project implementing the Repository and Unit Of Work patterns, and a WinForms UI project. In the UI main form...
asked by Matthew Bishop
Entity Framework "update-database" fails in on dev env with error "Microsoft.VisualStudio.Data.Tools.Package is not marked as serializable"
I recently moved from my old dev environment running VS 2015, .Net 4.5.1 on Windows 8.1 to a new environment running VS 2017, .Net 4.6.2 on Windows 10....Previously I was able to call update-database -script from the package manager console with no prob...
asked by FryHard
No context type was found in the assembly when running code first migration
While running command enable-migrations in Package Manager Console, got this error:...No context type was found in the assembly 'Vidly'...I am using Visual Studio 2017. How to solve it?
asked by Nigar Jafar
Cannot connect to Sql Server from Visual Studio (in the process of creating a new Entity Data Model): login failed for user 'sa'
I know there are similar questions, but I have a specific problem....Microsoft Visual Studio (2017)... pops up this error when I try to create a DB connection for my ...Entity Data Model...The attempt to attach to the database failed with the following ...
asked by AlexMelw
How to add Oracle provider in VS2017 for Entity Framework?
I want to connect to a database(Oracle 12c) for generating ADO.NET model, Code First From Database. I have installed ...ODAC for VS... but there is still no option for connecting Oracle DB at the Entity Data Model Wizard: ...At Server Explorer there is a ...
asked by jack3694078
Add EF 6.x EntityObject Generator in Visual Studio 2017
We are planning to switch to Visual Studio 2017. For our Entity Framework 6 edmx file we use the ...EntityObject Generator extension... to create us the desired ObjectContext....This extension is only compatible up to VS2013 - ...inofficially... up to VS2...
asked by telandor
Returning multiple grandchildren of child of parent from Entity Framework .NET
I am using VS2017, to create an ASP.NET Web Application (not using CORE), .NET Framework is 4.6.2 and the Entity Framework .NET is 6.1.3. I have looked on here for my answer but everything that I have tried or that was mentioned is not available to me....
asked by mattgcon
Entity Framework Core 2.0 add-migration not generating anything
I'm new to EF and am trying to create a simple test solution using VS 2017, .NET Core 2.0 and EF 2.0 but I can't get ...add-migration... to create the migrations folder and the initial migration....I have created a solution called ...Driver... with two .N...
asked by Alex
Enable-Migrations gives Exception calling "SetData" with "2" argument(s) error
I have used Entity Framework migrations numerous times before, but I am unable to enable migrations in a new demo project I just created. I have tried the different options recommended on SO Posts but nothing seems to work. Here is how the project was cre...
asked by Manish
MySQL for Visual studio 1.2.7 setup wizard ended prematurely
Created a proj from VS2013 installed mysql plugin 1.1.1, can update. But after I transferred to VS2017, it wont update Model from Database on edmx file. So I am installing mysql plugin 1.2.7 but i get this error..
asked by ronIT
How to get EF6 to work with DB2 in Visual Studio 2017
I've read numerous articles and posts here about getting Entity Framework to work with DB2 but all of them reference prior versions of Visual Studio. When I repeat the steps outlined (too many to remember at this point), I still do not have DB2 in the da...
asked by SonOfPirate
Could not load file or assembly 'System.Data.DataSetExtensions, Version=4.0.0.0PublicKeyToken=b77a5c561934e089' or one of its dependencies
Error Description:...Could not load file or assembly 'System.Data.DataSetExtensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The file or directory is corrupted and unreadable. (Exception from HRES...
asked by user2695433
