SQL Server - Concatenated string sequence as primary key - Insertion fail via EF code

asp.net-core c# entity-framework entity-framework-core sql-server

Question

I am using SQL-Server 2016 and Entity Framework Core.

Let's say we want to use a concatenated string to a sequence as a primary key of a table.
I have created the table using Code-First migration successfully, and have set the default value of the column to be the desired concat (Screenshot from SSMS): enter image description here

When I insert rows to the table manually using the INSERT command, it works as expected. If I choose to omit the value of the column, it is generated from the sequence, otherwise - it uses the value provided.

However, when I try to insert entities by code - an exception is being thrown

System.InvalidOperationException: 'Unable to create or track an entity of type 'EntityName' because it has a null primary or alternate key value.'

The relevant field of the entity is a simple string property. I tried adding [DatabaseGenerated(DatabaseGeneratedOption.Computed)] annotation, but that didn't help.

EDIT : When I call Add (Sync) stack trace - 

Result StackTrace:  
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.NullableKeyIdentityMap`1.Add(InternalEntityEntry entry)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.StartTracking(InternalEntityEntry entry)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.InternalEntityEntry.SetEntityState(EntityState oldState, EntityState newState, Boolean acceptChanges)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.EntityGraphAttacher.PaintAction(EntityEntryGraphNode node)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.EntityEntryGraphIterator.TraverseGraph(EntityEntryGraphNode node, Func`2 handleNode)
   at Microsoft.EntityFrameworkCore.DbContext.SetEntityStates(IEnumerable`1 entities, EntityState entityState)

When I call AddAsync stack trace -

Result StackTrace:
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.NullableKeyIdentityMap`1.Add(InternalEntityEntry entry)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.StartTracking(InternalEntityEntry entry)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.InternalEntityEntry.SetEntityState(EntityState oldState, EntityState newState, Boolean acceptChanges)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.EntityGraphAttacher.PaintAction(EntityEntryGraphNode node)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.EntityEntryGraphIterator.TraverseGraph(EntityEntryGraphNode node, Func`2 handleNode)
   at Microsoft.EntityFrameworkCore.DbContext.SetEntityStates(IEnumerable`1 entities, EntityState entityState)
   at Microsoft.EntityFrameworkCore.DbContext.AddRangeAsync(IEnumerable`1 entities, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Internal.InternalDbSet`1.AddRangeAsync(IEnumerable`1 entities, CancellationToken cancellationToken)
   at (Rest of the stack trace...)

Any suggestions? Thanks

1
1
4/19/2017 1:17:17 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You can try to set StoreGeneratedPattern value to Identity. I am using Database First approach and setting this property helped me a lot.

0
4/19/2017 10:42:35 AM

Related Questions

Entity Framework Code-First Migration Fails with SQL Server

Using Entity Framework 6 and SQL Server, I get the following error when EF is doing the migration thing:...Unable to update database to match the current model because there are pending changes and automatic migration is disabled. Either write the pending model changes to a code-based migration or enable automatic migration. Set ...DbMigrationsConf...
c# entity-framework entity-framework-6
asked by John Smith

How to make EF-Core use a Guid instead of String for its ID/Primary key

I haven't messed with the migrations for this example yet (they might need some tweaks), however ASP.NET Identity v3 is far more extensible than v2 was in this regard....The following should give you an Identity store based on Guid primary keys for Users and Roles alike:...public class ApplicationUser : IdentityUser<Guid> { } public class GuidData...
asp.net-core asp.net-identity asp.net-identity-3 c# entity-framework-core
asked by Ron DeFreitas

Mapping foreign key to non primary surrogate key column in EF code first

public class A { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public virtual int Aid { get; set; } public virtual ICollection<B> B { get; set; } } public class B { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public virtual int Bid { get; set; } [Key] [Column(Order = 0)] ...
c# ef-code-first entity-framework entity-framework-6 foreign-keys
asked by user5419119

Connect to Azure SQL server via AAD Authentication using EF Core

Azure SQL servers support AAD authentication, and I want my applications to connect to SQL server using AAD authentication and not SQL server admin credentials. I am using EF core to connect to SQL, how do I enable EF Core to use AAD authentication....My application is deployed in Azure App Service and it has MSI extension enabled, so I am looking ...
azure-active-directory azure-sql-database azure-sql-server azure-web-sites entity-framework-core
asked by Pratik Bhattacharya

2 Foreign Keys as Primary Key using EF Core 2.0 Code First

I have two tables: ...Comment... and ...Like.......public class Comment { CommentID { get; set; } .... } public class Like { CommentID { get; set; } UserID { get; set; } } ...Using entity framework core 2.0 code first, I want to define my "Like" model as only having the two fields which reference other primary keys (as foreign keys) but al...
c# entity-framework-core
asked by Jessie Cryer

EF 6 Code-First Many to Many relationship with same entity on non-primary key

I have an EF 6 Task entity, which looks like this:...public class Task { public Guid TaskId {get; set;} public TaskTypeEnum TaskType {get; set;} public TaskStatusEnum TaskStatus {get; set;} public virtual ICollection<Task> Dependencies {get; set;} } ...Tasks of a certain type can be dependent on all other tasks of a certain type to...
.net c# database entity-framework entity-framework-6
asked by user3802230

How can I define primary key with External table Sql Server 2017

I am working on multiple azure sql databases and trying to join data using Elastic query. ...I created external tables. ...When I try to create entity from EF Core. this fails and I am getting below error....Unable to identify the primary key for table 'xxxx'. Unable to generate entity type for table 'xxxx'....How can I create primary key for exte...
.net-core entity-framework-core sql-server
asked by M G

Getting "NEXT VALUE FOR" for a SQL Server sequence using EF Core 3.1 - impossible?

Looks like executing raw SQL is not priority for EF Core, so up to now (EF Core 3.1) it's providing publicly just few basic limited methods. ...FromSql... requires entity type or ...keyless entity type..., and ...ExecuteSqlRaw... / ...ExecuteSqlInterpolated... are the "modern" bridge to ADO.NET ...ExecuteNonQuery... which returns the affected rows....
ef-core-3.1 entity-framework-core sequence sql-server
asked by Ivan Stoev

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...
.net .net-core c# entity-framework entity-framework-core
asked by Umut Gür

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...
.net-core azure-sql-database entity-framework-core
asked by Wilton Kwok

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow