Skip to main content

EFCore - Update command is not updating the underlying data

Why my update command using EFCore is not updating the underlying data in the database though in middle-tier code it's successful, not throwing any error?

Let's try to get the root cause and how to solve this. 

When creating the model class of related database object if the primary key name is Id then no need to explicitly mention the Key in ef-core OnModelCreating. 

But if we've key name different from Id then we have to explicitly mention it in our OnModelCreating.

Something like this:

 entity.HasKey(c => new {c.CustId });

Assume in the database we've Customers table like this:

CREATE TABLE [dbo].[Customers](
	[CustId] [INT] IDENTITY(1,1) NOT NULL Primary Key,
	[FirstName] [VARCHAR](50) NULL
)

Point to ponder: In the database table, column CustId is already defined as Primary key. 

In EFCore model setup, it's up to us to configure the Key as (custId) or configure it as HasNoKey()


Assume we've set our entity with HasNoKey()

Customer-Model-HasNoKey
  
protected override void OnModelCreating(ModelBuilder modelBuilder)
{   
	modelBuilder.Entity(entity =>
	{
		// Here we're not setting kay key to EFCore model.
		entity.HasNoKey();

		entity.Property(e => e.FirstName)
			.HasMaxLength(50)
			.IsUnicode(false);
	});
	OnModelCreatingPartial(modelBuilder);
}

  

 And executed the command to update Customers entity using  EFCore code

EfCore code snippet:

var customer = _dbContext.Customers.Where(x => x.CustId == 1).FirstOrDefault();
customer.FirstName = "Updated name - with primary key";
_dbContext.SaveChanges();

 Then trying to update the Customers entity from EFCore code base, related entries value in the database will not change.  Here is the screen is shown before & after executing the ef-core code.



Now let's try to add the primary key in Customers model and then update 

Customer-Model-HasKey

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
	modelBuilder.Entity(entity =>
	{
		// define your key here.
		entity.HasKey(c => new {c.CustId });

		entity.Property(e => e.FirstName)
			.HasMaxLength(50)
			.IsUnicode(false);
	});
	OnModelCreatingPartial(modelBuilder);
}

and now execute the same EfCore code to update the customers' entity and verify in the database, yes, out data got updated. 


Conclusion:

In EFCore if it good to have primary key explicitly defined (if it's not Id) in our model, otherwise at runtime we may come across a situation like this (update not happening, sorting not working....)



Comments

Popular posts from this blog

How to install Zen-coding plugin

As a web-developer, irrespective of the technologies (java, c-sharp, python, php e.t.c.…), we used to write CSS code to make our web-pages looks good if not at least we’re involved in write html codes. What if there is some tool to whom you give some instruction and that tool generates a good, well formatted html tags for you. These kind of coding is possible and known as “ Zen coding ” and there are lots of plug-in available from different vendors. We’re going to  discuss the steps to install this “zen-coding” plugin for “visual studio, eclipse, sublime-text & notepad++ in next few lines. Follow the below steps to install "zen-coding" plugin based on your editor.  Steps to install zen-coding plugin for (visual studio, eclipse, sublime-text,notepad++) -- -- For Visual Studio 1. Go to "Tools" -> "Extensions and Updates" 2. It'll open the "Extensions and Updates windows"    Select online form Left hand menu items ent...

Azure SQL - Re-build index and update stats

Useful script to rebuild table indexes and update stats You can update the queries based on your requirement. To update the table stats --Query to update the table stats SELECT N'UPDATE STATISTICS ' + t.TABLE_SCHEMA + '.' + t.TABLE_NAME + ' ;' FROM INFORMATION_SCHEMA.tables AS t WHERE t.TABLE_TYPE = N'BASE table'; GO To re-build table indexes: --To rebuild table index DECLARE @myDatabaseName NVARCHAR(255) = N'your-database-name'; DECLARE @runningTableName NVARCHAR(255); DECLARE @cmd NVARCHAR(1000); DECLARE @name NVARCHAR(100)= 'your-database-name'; -- Populate the database cursor. DECLARE myDatabaseLevelCursor CURSOR READ_ONLY FOR SELECT @name; OPEN myDatabaseLevelCursor; FETCH NEXT FROM myDatabaseLevelCursor INTO @myDatabaseName; WHILE @@FETCH_STATUS = 0 BEGIN -- In this command we're declaring table level cursor SET @cmd = 'DECLARE myTableCursor CURSOR READ_ONLY FOR SELECT '...

EFCore - Scaffold-DbContext how to use

EFCore versions, we don't have GUI to manage the DB-entities & dbContext like we used to have with EF6 (or EF5/4 version). With EFCore we've the Scaffold-DbContext command which helps us to create entities & DB context from our DB-objects.  Let's see how to use Scaffold-DbContext: Assume we're connecting with SQL Server so after creating a sample project you'll have to install EFCore related libraries as mentioned below.  Install entity-framework-core for SQL Server, at this time 3.1.9 is the latest stable version   Microsoft.EntityFrameworkcore   Microsoft.EntityFrameworkCore.SqlServer  To use Scaffold-DbContext, following two NuGet packages are required Microsoft.EntityFrameworkCore.Tools  Microsoft.EntityFrameworkCore.Design Let's say we've two DB tables (e.g. dbo.Employees & dbo.Users )  Now let's see how to use Scaffold-DbContext to create c-...