Entity Framework Core ObjectContext.Refresh equivalence

Add stored procedure to entity framework model (.edmx) without refreshing existing entities

I have a stored procedure in development environment that I want to add to EF data model (.edmx) and call it in my code through a method wrapper that EF creates. ...Our development environment is not 100% in sync with production one so when I try adding the stored procedure deployed to development environment using "Update Model From Database" menu...

Deleting parent-child relation with Entity Framework or Entity Framework Core

I'm learning how to use Entity Framework, having a NHibernate background. There are plenty of tutorials on the net, but I didn't find something for my specific case. I don't want to delete the Category record, I only want to delete the relation!...I have following poco's:... public class TrainingCourse { [Key] public int Cour...

Fluent Api in Entity Framework 6 not compatible Entity Framework Core

direct link to ...table maping... documentation. Read the rest of it as well. EF core is a new product not an upgrade to EF6.

Issue when inserting new entity with relationships to existing entities (Entity Framework Core 1.1.0 )

I have encountered an issue when inserting (...Add... method of EF API) or updating (...Update... method of EF API) entities holding reference properties to existing entities (I call existing entity an entity that already exists in the database, and has its PK properly set)....The model consists in ...Place..., ...Person..., ...Address..., and ...S...

Both Entity Framework Core and Entity Framework 6 are installed

I use Visual Studio 2017 and create a new ASP.NET Core project. I add migration for Entity Framework Core as below...add-migration "Initial Create" ...and get the following error:...Both Entity Framework Core and Entity Framework 6 are installed. The Entity Framework Core tools are running. Use 'EntityFramework\Add-Migration' for Entity Framework 6...

How to refresh an Entity Framework Core DBContext?

Oh, this issue had me in knots for days. ...I'm using Visual Studio 2017 with .Net Core 2.1, and my EF Core code looked something like this:...// 1. Load a [User] record from our database int chosenUserID = 12345; User usr = dbContext.Users.FirstOrDefault(s => s.UserID == chosenUserID); // 2. Call a web service, which updates that [User] reco...

Log DbContext.SaveChanges Exception to the database in Entity Framework/Entity Framework Core

In try block you are adding some changes to db context. While saving you got some exception and using the same db context in catch block to log that exception. Here the db context still has unsaved changes made in try block. So you will get the same exception while saving the context. ...To avoid this you have to discard the changes from db context...

Entity Framework 6 vs Entity Framework Core Raw Sql

Entity Framework 6 example writing SQL queries for non-entity types:...context.Database.SqlQuery<string>(" ; with tempSet as " + "(select " + ...In Entity Framework 6, I can also write the following query with ...SqlQuery.... How can I run the following query with Entity Framework Core?...; with tempSet as ( ...

Conflict between Entity Framework Core and Entity Framework

I have already created mssql db and project (class library) for data access layer at .net framework. Then I created project at asp.net core. To access to this db I use in startup class within ...ConfigureServices... method. I use EF core in asp.net core project....services.AddDbContext<TradeEvoDbContext>(options => options.UseSqlServer(Configur...

Add migration - Both Entity Framework Core and Entity Framework 6 are installed

I have a solution with multiple projects one of them with EF 6 and another one with entityframeworkcore....The migrations were working fine before adding EF6 project, but now I can't use the migration's command : ...add-migration 'anything'...Both Entity Framework Core and Entity Framework 6 are installed. The Entity Framework Core tools are runnin...