An error occurred while updating the entries ошибка

Turn the Pluralization On. The problem is that you model object are using singular name (Pupil) convention, while in your database you are using pluralized names Pupils with s.

UPDATE

This post shows how can you turn it on or off.
Some relevant excerpt of that post:

To turn pluralization on and off

• On the Tools menu, click Options.

• In the Options dialog box, expand Database Tools.
  Note: Select Show all settings if the Database Tools node is not visible.

• Click O/R Designer.

• Set Pluralization of names to Enabled = False to set the O/R Designer so that it does not change class names.

• Set Pluralization of names to Enabled = True to apply pluralization rules to the class names of objects added to the O/R Designer.

UPDATE 2

But note that, you should avoid pluralized names.
You can read here how to do it (I’ll cite it here, just in case the link gets broken).

(…) When you work with Entity Framework Code First approach, you are creating your database tables from your model classes. Usually Entity Framework will create tables with Pluralized names. that means if you have a model class called PhoneNumber, Entity framework will create a table for this class called “PhoneNumbers“. If you wish to avoid pluralized name and wants singular name like Customer , you can do it like this
In your DBContext class, Override the “OnModelCreating” method like this (…)

(…) Having this Method Overriding will avoid creating tables with pluralized names. Now it will create a Table called “PhoneNumber” , Not “PhoneNumbers” (…)

This post was most recently updated on February 19th, 2023.

3 min read.

This article offers yet another possible fix to an issue, where trying to call SaveChanges() in Entity Framework Core throws a pretty generic “An error occurred while updating the entries”-exception, and you’re left wondering what in tarnation is wrong this time.

And admittedly, that’s a really generic error, so it could pretty much be whatever. But in this article, I’ll go through one possibility – hopefully, it helps!

Problem

So I was just pushing in some new rows to an incredibly simple table in my small Azure MS SQL database when this error occurred:

An error occurred while updating the entries. See the inner exception for details.

This error can be thrown due to incredibly many different reasons. And there are different variants of the error – some of them below:

microsoft.entityframeworkcore.dbupdateexception: 'an error occurred while updating the entries. see the inner exception for details.

microsoft.entityframeworkcore.dbupdateexception: 'an error occurred while saving the entity changes. see the inner exception for details.'

What gives? 🤔

Reason

Huh, so the actual error message itself is extremely generic. That’s not going to be enough to help us figure this out.

But what about the details of the exception – you can catch it and, like the error proposes, take a look at the inner exception and associated HResult – it’s bound to contain an error code, right?

Well, yes. The HResults were:

• Exception: -2146233088 (Generic, doesn’t help us much)
• InnerException: -2146232060 (Generic SQL Server error)

Ugh – that’s extremely generic as well! No help at all.

But wait – let’s do what it tells us to, and see the inner exception, then:

{"Cannot insert explicit value for identity column in table '[Not the table I was inserting stuff to, and not one that had any direct relations to it either]' when IDENTITY_INSERT is set to OFF.rnCannot insert explicit value for identity column in table '[Another unrelated table]' when IDENTITY_INSERT is set to OFF.rnCannot insert explicit value for identity column in table '[One more unrelated table]' when IDENTITY_INSERT is set to OFF.rnCannot insert explicit value for identity column in table '[Yet another unrelated table]' when IDENTITY_INSERT is set to OFF.rnCannot insert explicit value for identity column in table '[This one was just as unrelated]' when IDENTITY_INSERT is set to OFF."}

That’s, uhh… Not that helpful, still? What’s up with all of these errors from other tables??

Oh. Wait. The exception only contains references to other tables, not about my actual entity at all? And that’s going to be pretty important.

See – those references are going to be the key term here.

Solution

Okay – this is going to be specific to this particular case, and probably different for you, but might be worth checking out anyway.

So, I was handling some non-tracked entities earlier in the code – and was in fact trying to associate one of these entities with a new entity that I was saving.

In the code, this looks somewhat like the below:

var item = ctx.Entities.Where(x => x.Amount > 1000).AsNoTracking().First();

ctx.OtherEntities.Add(new OtherEntity(){
   Id = 0,
   Entity = item
});

ctx.SaveChanges();

Did you catch it? The item is not tracked – and you can’t associate it with a tracked entity!

So, what you need to do, is to fetch the item without.AsNoTracking() if you plan on associating it with any tracked entities.

Super simple – but the exception thrown is definitely not very informative.

In case this article didn’t help you, your underlying cause might be different. But luckily, I have another one explaining another solution to the same error (but a different underlying issue) here:

By default, the .Net client has a 30-second client-side command timeout. The error you are seeing is saying that the response from the server took more than 30 seconds.

Here’s some example C# code showing the problem by executing a WAITFOR DELAY statement that waits 31 seconds:

using System;
using System.Data.SqlClient;

namespace ConnectionTimeoutTest
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnectionStringBuilder sqlConnectionStringBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder
            {
                InitialCatalog = "tempdb",
                IntegratedSecurity = true,
                DataSource = "localhost"
            };

            using SqlConnection connection = new SqlConnection();
            connection.ConnectionString = sqlConnectionStringBuilder.ConnectionString;
            connection.Open();
            using SqlCommand sqlCommand = new SqlCommand("WAITFOR DELAY '00:00:31';SELECT 'Hello World!';", connection);
            SqlDataReader reader = sqlCommand.ExecuteReader();
            while (reader.Read())
            {
                Console.WriteLine(reader.GetString(0));
            };
        }
    }
}

And the exception:

System.Data.SqlClient.SqlException
HResult=0x80131904
Message=Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Source=Core .Net SqlClient Data Provider
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at ConnectionTimeoutTest.Program.Main(String[] args) in C:UsersHannah.MVCTsourcereposConnectionTimeoutTestConnectionTimeoutTestProgram.cs:line 23

Inner Exception 1:
Win32Exception: The wait operation timed out.

Here’s the fix to make the client wait for 60 seconds:

using System;
using System.Data.SqlClient;

namespace ConnectionTimeoutTest
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnectionStringBuilder sqlConnectionStringBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder
            {
                InitialCatalog = "tempdb",
                IntegratedSecurity = true,
                DataSource = "localhost"
            };

            using SqlConnection connection = new SqlConnection();
            connection.ConnectionString = sqlConnectionStringBuilder.ConnectionString;
            connection.Open();
            using SqlCommand sqlCommand = new SqlCommand("WAITFOR DELAY '00:00:31';SELECT 'Hello World!';", connection);
            sqlCommand.CommandTimeout = 60;  // <---- this is new
            SqlDataReader reader = sqlCommand.ExecuteReader();
            while (reader.Read())
            {
                Console.WriteLine(reader.GetString(0));
            };
        }
    }
}

The code above is available in GitHub.

Hi Folks,

I’m getting the following error message when I try to save a new record to the Visits table:

Here is my table T-SQL:

Here are my class definitions:

I first make a Visitor record and it successfully saves. Then I make a new Visit record using the integer value ThisVisitorId from the Visitor record for the VisitorId field:

            ‘make new visit
            Dim VisitDb As New VisitContext
            Dim VisitorVisit As New Visit
            VisitorVisit.VisitDateAndTime = Now
            VisitorVisit.VisitorId = ThisVisitorId

            VisitDb.Visits.Add(VisitorVisit)

When I try to save the Visit record on the line VisitDb.SaveChanges(), I get the error.

‘save new visit record
Try
    VisitDb.SaveChanges()
Catch ex As DbEntityValidationException
    For Each a In ex.EntityValidationErrors
        For Each b In a.ValidationErrors
        Dim st1 As String = b.PropertyName
        Dim st2 As String = b.ErrorMessage
        Debug.WriteLine(st1)
        Debug.WriteLine(st2)
        Next
    Next
End Try

I don’t understand why there is a conflict between the VisitorId field and the Foreign Key: they are the same value!

Any help would be appreciated.

Microsoft.EntityFrameworkCore.DbUpdateException HResult=0x80131500 Message=An error occurred while updating the entries. See the inner exception for details.

The INSERT statement conflicted with the FOREIGN KEY constraint «FK_City_Country_IdofCountry». The conflict occurred in database «MyVinylProject», table «dbo.Country», column ‘Id’.
The statement has been terminated.
-whole exception code is under code

UPDATE: Well, i fixed this with ViewModels, how? I put under comment line(remove) field «Country CityCountry» , and left only making «int IdofCountry» where i will remember just Id, and when i need to write it, i will use ViewModel , or something like that.

IF ANYONE HAS BETTER SOLUTION, PLEASE EXPLAIN IT. I dont like this solution but since it works ..

Anyone knows what i did wrong, and what is solution ?! Thanks!

public class Country
    {
     [System.ComponentModel.DataAnnotations.ScaffoldColumn(false)]
[System.ComponentModel.DataAnnotations.Schema.DatabaseGenerated(System.ComponentModel.DataAnnotations.Schema.DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }
        public string Name { get; set; }

        public virtual IEnumerable<City> CitiesinCountry { get; set; }
    }

public class City
    {
      [System.ComponentModel.DataAnnotations.ScaffoldColumn(false)]
 [System.ComponentModel.DataAnnotations.Schema.DatabaseGenerated(System.ComponentModel.DataAnnotations.Schema.DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }
        public string Name { get; set; }

        //public Country CityCountry { get; set; }                                   <----FIX
        //[System.ComponentModel.DataAnnotations.Schema.ForeignKey("CityCountry")] <----FIX
        public int IdofCountry { get; set; }
     }
public class VShContextClass : DbContext
    {
         public VShContextClass()
         {
         }
         public VShContextClass(DbContextOptions<VShContextClass> options)
            : base(options) { }
        public DbSet<Country> Country { get; set; }
        public DbSet<City> City { get; set; }
}
//controller
        public IActionResult CreateCity()
        {
            return View();
        }
        [HttpPost]
        public IActionResult CreateCity(CityViewModel City)
        {
            if (ModelState.IsValid)
            {
                City newCity = new City()
                {
                    Name = City.Name,
                    IdofCountry = City.CountryId

                };
                _repository.AddCity(newCity);
            }
            ModelState.Clear();

            return View();
        }


//repository
public void AddCity(VinylShop.Models.Record.City newCity)
        {
            db.City.Add(newCity);
            db.SaveChanges();                 //----> THROWS EXCEPTION HERE
        }

So i guess you see in code where it throws exception:

Microsoft.EntityFrameworkCore.DbUpdateException HResult=0x80131500 Message=An error occurred while updating the entries. See the inner exception for details. Source=Microsoft.EntityFrameworkCore.Relational StackTrace: at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(Tuple2 parameters) at Microsoft.EntityFrameworkCore.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded) at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, TState state, Func2 operation) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IReadOnlyList1 entries) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges() at VinylShop.Repository.ShopRepo.AdministratorRepo.AddCity(City newCity) in C:UsersBobejnDesktopMyProject-CoreVinylShopVinylShopRepositoryShopRepoAdministratorRepo.cs:line 61 at VinylShop.Controllers.Administrator.AdminController.CreateCity(CityViewModel City) in C:UsersBobejnDesktopMyProject-CoreVinylShopVinylShopControllersAdministratorAdminController.cs:line 83 at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.d__12.MoveNext() Inner Exception 1: SqlException: Invalid column name ‘CountryId’.

Further technical details

EF Core version: 2.0.6
Database Provider: Microsoft.EntityFrameworkCore.SqlServer Version=»2.0.2″
Operating system: Windows 10
IDE: Visual Studio 2017 15.4