EF Core update-database System.Globalization.CultureNotFoundException: – C#

The Problem:

An error message "System.Globalization.CultureNotFoundException: Only the invariant culture is supported in globalization-invariant mode." is being encountered when running the "update-database" command in the package manager console for database creation using EF Core 7.0.11. This seems to be due to the globalization-invariant mode being enabled.

The Solutions:

Solution 1: Check runtime options for globalization

The error is caused by the globalization-invariant mode being enabled. In this mode, only the invariant culture is supported. To fix the issue, you need to disable the globalization-invariant mode by setting the “System.Globalization.Invariant” property to false in the project’s runtime options.

1. Open the project file (.csproj) in a text editor.
2. Find the runtimeOptions section.
3. Set the System.Globalization.Invariant property to false.

<Project Sdk="Microsoft.NET.Sdk.Web">

  <PropertyGroup>
    <TargetFramework>net7.0</TargetFramework>
    <ImplicitUsings>enable</ImplicitUsings>
    <Nullable>enable</Nullable>

    <RuntimeOptions>
      <ConfigProperties>
        <System.Globalization.Invariant>false</System.Globalization.Invariant>
      </ConfigProperties>
    </RuntimeOptions>
  </PropertyGroup>

</Project>

4. Save the project file.

5. Rebuild the project.

The error should now be gone.

Solution 2: Update InvariantGlobalization to false

You need to change `InvariantGlobalization` to `false` in your project file. This setting controls whether or not the globalization-invariant mode is enabled. In globalization-invariant mode, only the invariant culture is supported. This setting must be set to `false` in order for EF Core to create the database correctly.

<PropertyGroup>
  <TargetFramework>net8.0</TargetFramework>
  <Nullable>enable</Nullable>
  <ImplicitUsings>enable</ImplicitUsings>
  <InvariantGlobalization>false</InvariantGlobalization>
</PropertyGroup>

Video Explanation:

The following video, titled "EF Core 8: Only the invariant culture is supported in globalization ...", provides additional insights and in-depth exploration related to the topics discussed in this post.

An unhandled exception has occurred while executing the request. System.Globalization.CultureNotFoundException: Only the invariant culture ...