Entity Framework Core - Knowledge Base (KB)

EF6/Code First: Super slow during the 1st query, but only in Debug

I'm using EF6 rc1 with Code First strategy, without precompiled views and the problem is: If I compile and run the exe application it takes like 15 seconds to run the first query (that's okay, since I'm still working on the pre-generated views). But if I ...

EntityDeploySplit error - Microsoft.Data.Entity.Build.Tasks.dll missing

After a clean Windows reformat and installing Visual Studio 2013, trying to build a project with database-first Entity Framework edmx files yields the following error:...The "EntityDeploySplit" task could not be loaded from the assembly C:\Program Files...

EF 6 database first: How to update stored procedures?

We are using ...Entity Framework 6.0.0... and use database first ...(like this)... to generate code from tables and stored procedures. This seems to work great, except that changes in stored procedures are not reflected when updating or refreshing the mo...

Entity Framework Code First Migration during deploy to production host does not work

I am using VS2013 with Entity Framework 6.1 against SQL 2012....When I use Code First to create my classes and tables in Dev it works fine. When I go to publish via Web Deploy to my third party host everything deploys but none of the tables are created in...

Publishing with Multiple Context in Same Database

I encountered a problem with multiple context in EF 6. Recently i had splitted my context into three parts and configured them as had been told ...here...Everything was fine, until i decided to publish via Visual Studio; because publish wizard detected on...

Nuget can't resolve Entity Framework 7 dependency which is referenced in project

I'm currently developing a piece of software as coursework for a class and I've elected to make a Windows App and Windows Phone App. Being hit by the knowledge that Entity Framework 6 wasn't supported almost made me give up, but I started a complicated wo...

code first to existing database missing from wizard selection

In the ...video here... the Entity Data Model Wizard includes options "EF Designer from database" and "Code First from database"...I do not get these options appearing in the wizard when I add a new data item and select ADO.Net entity data model...I am us...

How to make Package Manager Console in VS2013 available (not disabled)?

Currently, when I open Package Manager Console in VS2013 it is unavailable (all controls are in disabled state). I want to preform migrations in EF7. (EntityFramework.Commands packages from EF7 is installed in the project.)...I am not sure, why it is no l...

Unique constraint entity framework

I'm using MS SQL Server 2012 + the Entity Framework 6.1.1. I have created a model using the designer. Now, I would like to add a unique to an attribute. How can I achieve this using the designer / keep the model generation?...Edit: I do the model first ap...

Unable to determine the provider name for provider factory of type "System.Data.Sqlite.SqliteFactory"

I want to use sqlite entity framework in my web api project, but it always can't work well, ...here is my development enviroment....1.Visual studio 2013, .net framework 4.5...sqlite package version is 1.0.97, I installed below packages...system.data.sqli...

Entity Framework 6 query with Distinct filter

I have a problem. When I run the code below: ...var data = context.TableX.Where(w => w.userId == 9999&& w.id == 9999) .Distinct().ToList(); ...This is the query generated: ...SELECT [Extent1].[id] AS [id], [Extent1].[name] AS [name], [Extent1].[companyId]...