EF 6 and EF Core

EF Core 1.1 preview1: No executable found matching command "dotnet-ef"

You need to add ..."Microsoft.EntityFrameworkCore.Tools.DotNet": "1.0.0-preview3-final"... to the tools section....See ...https://blogs.msdn.microsoft.com/dotnet/2016/10/25/announcing-entity-framework-core-1-1-preview-1/... for more info

EntityState.Modified does work differently on updating in EF Core vs EF 6

Your error is stating that your Student has SchoolclassId and that value does not exist in the foreign table which is Id in Schoolclasses table....Check the value of SchoolclassId before calling SaveChanges. Most likely this value does not exist in Schoolclasses table....In other words this error is not because of EF 6 vs EF 7 but due to a foreign ...

Remove Auto Increment in EF Core 1.0 RC2 (former EF 7 RC2)

I did not work with EF 7 but few points to check...After you changed the model you need to update database, migration or manually...Check in database if you have now autoincrement on field

How to get DbContext class in EF Core without bringing in EF 6?

This code has references to ...DbContext... (in ...System.Data.Entity...)...That seems to be your problem. Throw it away....The correct ...DbContext... lives in ...Microsoft.EntityFrameworkCore... namespace, from the same nuget package....Probably you should read ...this...:...Code First...DB First...Make sure you have the old nuget package uninsta...

How to implement a left join with some condition on second table in EF / EF Core?

Something like:...var filteredCenterCodeSends = dbContext.HISBaseCenterCodeSends .Include( ccs => ccs.Insur ) // assuming navigation property name .Where( ccs => ccs.Center.CenterCode == 2 && ccs.ServiceGroup.ID == 4 ); // if ccs.Insur/ID is nullable, also add `&& ccs.Insur != null` var insurersWithFilteredCcs = d...

Can this TestDBSet class from EF 6 be adapted to work with EF Core?

@Edward your solution worked brilliantly, by returning null the tutorial is now compatible with EF core at least for my tests, thanks for the hint....some modifications in TestContext: - using Microsoft.EntityFrameworkCore.Query.Internal; - using Microsoft.EntityFrameworkCore.ChangeTracking; - change IDbAsyncEnumaerable and IDbAsyncEnumerator to IA...

What is the difference between EF Core Database-First and EF Core Code-First approaches?

Database-First...DB-First is that you reverse engineer an existing database to create an Entity Framework model.Instead of designing the EDMX manually and generating the SQL script to create the Database, we build the latter and then generate the former using the Entity Framework Designer tool....Code-First...Code-First uses migrations to create th...

Migrating from EF Core 2 to EF Core 3

use ...OrderByDesc()... for some property and then ...FirstAsync().... (...https://github.com/aspnet/EntityFrameworkCore/issues/18211...)...the invariant compare is not translated, was probably client evaluated previously. Depending on your database collation setting you could probably just do a normal equals here. ...Calling ...AsEnumerable()... o...

EF Core 2.1 Linq Query to EF Core 3.0

ok, i figured it out....here is my new code that works.... query = query.Where(x => x.Items.Where(o => o.BinItem != null && o.BinItem.Bin != null && o.BinItem.Bin.Zone != null ...

EF core 2.2 to EF core 3.1

Starting with 3.0, EF Core LINQ queries are no longer evaluated on the client. ...learn more: MSDN...Actually i think your problem may be in i.ForApplication Property if it makes some calculations.