Changing Primary Key using Entity Framework Core Migrations

Entity Framework, Load multiple entities by primary key in a single query while still using caching

I have a list of primary key ids for a table whose entities I want to pull into EF memory, modify, and then save....With a single id you would do something like...var entity = dbContext.Entity.Find(id); entity.SomeColumn = "something"; dbContext.SaveChanges() ...Currently I'm doing something like this to pull all the entities to be modified in on...

EF Core: Using ID as Primary key and foreign key at same time

Using attributes only, without FluentAPI:...public abstract class DtoBase { [Key] public Guid ID { get; protected set; } } public class PersonDto : DtoBase { [InverseProperty("Person")] public ProspectDto Prospect { get; set; } } public class ProspectDto : DtoBase { [ForeignKey("ID")] // "magic" is here public Pe...

EF6 vs Entity Framework Core : Insert an entity without resetting the primary key (identity) to zero

Since EF Core doesn't support interceptors, my recommendation is to "hack it"....If you overwrite the ...SaveChanges... method you can provide this functionality on ...every... save without a massive refactor....public class MyContext : DbContext { //... public override int SaveChanges() { foreach (var dbEntityEntry in ChangeTr...

Many-to-many relationship in Entity Framework Core when one entity has composite primary key

I have the following classes:...public class InvoiceLine { public Guid Id { get; set; } public int LineNumber { get; set; } public List<ProductCode> ProductCodes { get; set; } } public class ProductCode { public string Category { get; set; } public string Value { get; set; } } ...In the case of ...ProductCode... the ....

Entity Framework .Core treating foreign key as a primary key

I have the two classes shown below. When trying to insert two ...HeroEntry... with the same ...IdentityId..., the context is only saving one of the two entries. Any ideas what I am doing wrong?...public class Identity { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int IdentityId { get; set; } public string Firs...

Entity Framework Core - realtion between two tables without using primary key

I would like to write Console application in dotnet core 2.1 with EFCore.Postgres 2.1.2....I have two tables in existing Database. Every table has it's own Primary key, but these tables should be related via another field - UserId...My models:...public class UserAddress { public int UserAddressId {get;set;} public int UserId {get;set;} ...

Entity Framework Core: Violation of PRIMARY KEY constraint Cannot insert duplicate key in object

I am getting the following error when inserting records into a child table, Why is Entity Framework Core trying to insert a record into the parent table(IdentityUser table) when I am asking it to insert a record into a child table(Keywords table)? ...StackTrace:...An unhandled exception occurred while processing the request. SqlException: Violation...

Net Core: Find Primary Key of Entity Framework Core and Reflection

How do I find Primary Key from an Entity Framework Core 2 Database Scaffold using Reflection .dll?...We need to find Primary Key Member given an EntityName, and return Primary Key Member as string. Conducted Reverse Scaffolding on Sql Server database ....modelBuilder.Entity<Product>(entity => { entity.HasKey(e => e.ProductInfoId) .HasName...

How to change single primary key to composite primary key with EF Core

I want to delete the single primary key Id column in a SQL table that has already been created and does not contain data and define a composite primary key instead....My current entity definition is as follows:...[Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } public long IpFrom { get; set; } public long Ip...

EF Core Code-First Migration Changing Primary Key from Int to Long Failed

I'm using Dotnet Core 3.1 with Entity Framework Core 3.1.3 using Code-First with Azure SQL Database....During the development, I want to change the Primary Key of a table from int to long from the Model class in dotnet core project and use ...add-migration.... However, when using ...Update-Database..., there are errors:...Failed executing DbCommand...