Setting -TargetMigration with EF core

Where should my application setting be in a .Net Core / EF Core class library project?

I am trying to store my database connection string in a config file so that I can change it depending on the deployment environment. My data access is using EF Core 1.1.0....I have looked at some full .Net applications that use EF Core and use App.config to store and retrieve the connection string like this:... protected override void OnConfiguring...

EF Core "Cannot insert explicit value for identity column" although IDENTIY_INSERT is set to ON

I'm using Entity Framework Core 2.1 and want to Insert some Data using IDENTITY_INSERT. Although I'm setting IDENTITY_INSERT to On, i still get an exception on the line ...identityContext.SaveChanges();...:...Microsoft.EntityFrameworkCore.DbUpdateException: 'An error occurred while updating the entries. See the inner exception for details.'...Inn...

Setting SET IDENTITY_INSERT for multiple tables in Entity Framework Core

I want to set tables ...IDENTITY_INSERT... to ...ON.... I can for one table at a time. But how can I achieve for more than one as I am doing code-first approach....I'm getting this error:...System.Data.SqlClient.SqlException : IDENTITY_INSERT is already ON for table 'Some Table'. Cannot perform SET operation for table 'ref.EmploymentType'...Test.cs...

Use settings.json on a Net Core Class Library with EF Core migrations

On a NET Core 2.1 Class Library I have a Entity Framework Core 2.1 DbContext:...public class AppContext : IdentityDbContext<User, Role, Int32> { public AppContext(DbContextOptions options) : base(options) { } } ...To run migrations on the Class Library I needed to add the following:...public class ContextFactory : IDesignTimeDbContextFactory<Co...

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

I was wondering... since there is no EDMX in EF Core, what is the difference between those 2? And if the major difference would be the possibility to change the database tables, why not use code first then use EF code-first migrations?

Migrating from EF Core 2 to EF Core 3

After upgrading my project from (dotnet core 2/ef core 2) to (dotnet core 3/ef core 3) almost all of my entity framework LINQ queries are broken. while I already read ...this... it's still unclear to know what to do.... Here are some examples that I have problem with: ...var league = await dbContext.League.LastAsync(); ...While this code worked jus...

EF Core 2.1 Linq Query to EF Core 3.0

I am dealing with a query that i cannot get to work on ef core 3.0 and it worked fine in the 2.1 version, i would like if anyone can help figure how i can get it work in the 3.0 version....So let me start with the challenge. ...i have a table that is named Zone and it has a one to many relationship to a table called Bin, and bin has a one to many r...

EF core 2.2 to EF core 3.1

when I used to use EF 2.2 it rans this code without problems:...var resource = locResRepo.GetWhere(i => i.ForApplication.ToLower() == applicationName.ToLower()) .Where(resourcesConditionExpression) .Select(item => new ResourceKeyObject { Id = item.Id, ResourceKey = item.ResourceKey...

Migrate .NET Core 2.2 to .NET Core 3.1 and keep referencing EF Core 2

I have a C# application written with .NETCore 2.2 and Postgres and I would like to migrate it to .NET Core 3.1....The problems is that there are so many breaking changes, especially in Entity Framework that it is not possible to rewrite everything now. At the same time, other developers continue development on .NET Core 2.2 branch and I need to do ...

EF Core migration generated `ReferentialAction.Restrict` but in context set as `DeleteBehavior.ClientSetNull`

I discover this while I tried to run my delete query when it stop my with the error ...The DELETE statement conflicted with the REFERENCE constraint "FK_List_ListId"...When I through an analysis to the issue, noticed that in the latest migration ...onDelete: ReferentialAction.Restrict.... But I have generated this migration after set ....OnDelete(D...