November 2026
Every post published in November 2026, newest first. Pick a day to jump straight to it.
- Posts
- 1,091
- Topics
- 89
- Reading time
- 124 h
- Active days
- 16
Posts 1,021–1,050 of 1,091 · November 3, 2026
Page 35 of 37
Tuesday, November 3, 2026
30 of 91 posts
How to Write a MySQL Connection String for .NET C#
Build a MySQL connection string for .NET C# with Oracle's MySql.Data driver, key by key: Server, Port, Database, User ID, Password and SslMode, with their documented defaults. Test it with a one-file C# program that reports the user, version and TLS, and keep the password out of your code.
11 min readHow to Pin the .NET SDK Version with global.json in a .NET C# Project
Make every developer and build machine use the same .NET SDK for your C# project with a global.json file. Create it with dotnet new globaljson, see which SDK a folder uses, and watch each rollForward value pass or fail against a real installed SDK, including .NET 10's custom errorMessage.
10 min readHow to Check Which .NET SDKs and Runtimes Are Installed for C# Development
Find out which .NET SDK and runtime versions your computer has, which one your C# project actually uses, and whether they're up to date: dotnet --version, --list-sdks, --list-runtimes, --info and dotnet sdk check, with real output from .NET 10 on macOS.
8 min readHow to Install dotnet-ef as a Local Tool in a .NET C# Project
Install the EF Core command-line tools, dotnet ef, as a local tool pinned to your project's EF Core version, instead of one global copy for the whole computer. See where .NET 10 puts the tool manifest, why dotnet ef picks the local copy, how teammates restore it, and the Design package the tools need. Real output from .NET 10.
14 min readHow to Show MySQL Query Results Vertically with \G
Wide MySQL results wrap into an unreadable mess in the terminal. End a statement with \G instead of a semicolon to print each row as a list of column: value lines, or start the mysql client with --vertical. Real output from MySQL 9.7.
5 min readHow to List the CHECK Constraints in MySQL
List the CHECK constraints of a MySQL database with their tables, rules and whether they're enforced, by joining INFORMATION_SCHEMA.CHECK_CONSTRAINTS and TABLE_CONSTRAINTS, or see one table's in SHOW CREATE TABLE. Real output from MySQL 9.7, with constraints created by EF Core.
6 min readHow to List the Foreign Keys of a MySQL Table
Find every foreign key in a MySQL database: which column points to which table, what happens on delete and update (RESTRICT, CASCADE, NO ACTION), and which tables reference a given table, using SHOW CREATE TABLE and INFORMATION_SCHEMA. Real output from MySQL 9.7.
8 min readHow to List the Indexes of a MySQL Table
See every index on a MySQL table with SHOW INDEX, read its columns (Non_unique, Key_name, Seq_in_index, Cardinality), and list all indexes of a database with their columns in one query from INFORMATION_SCHEMA.STATISTICS. Real output from MySQL 9.7.
8 min readHow to See the Structure of a MySQL Table (DESCRIBE and SHOW CREATE TABLE)
See a MySQL table's columns, types, keys and constraints: DESCRIBE for a quick look, SHOW FULL COLUMNS for collations, SHOW CREATE TABLE for the complete definition, and INFORMATION_SCHEMA.COLUMNS for queries. What PRI, UNI and MUL mean, with real output from MySQL 9.7.
9 min readHow to List the Tables in a MySQL Database
List the tables of a MySQL database with SHOW TABLES, filter them with LIKE, tell tables from views with SHOW FULL TABLES, and get engine, collation and row counts from INFORMATION_SCHEMA.TABLES, including why TABLE_ROWS isn't an exact count. Real output from MySQL 9.7.
7 min readHow to Run a Command Inside a Running Docker Compose Container (docker compose exec)
Run one command, or a whole interactive shell, inside a container that Docker Compose started, with docker compose exec. See how to read its environment, open bash and leave it, run as another user, and use -T in scripts. Shown with a MySQL 9.7 container.
9 min readHow to See the Logs of a Docker Compose Service (docker compose logs)
Read what a container started by Docker Compose prints, with docker compose logs: the last few lines, timestamps, only the last few minutes, live following, and searching for one message in bash or PowerShell. Shown with a MySQL 9.7 container.
11 min readFixed: "Unable to create a 'DbContext' of type 'InventoryDbContext'. The exception 'Unable to resolve service for type DbContextOptions' was thrown" in EF Core
An EF Core migrations bundle run as Production failed with: An error occurred while accessing the Microsoft.Extensions.Hosting services. Continuing without the application service provider, then Unable to create a 'DbContext' of type. Why the app's own startup code decides it, why --connection didn't help, and the fix.
7 min readFixed: "NU1608: Pomelo.EntityFrameworkCore.MySql 9.0.0 requires Microsoft.EntityFrameworkCore.Relational (>= 9.0.0 && <= 9.0.999) but version 10.0.14 was resolved"
Adding Pomelo.EntityFrameworkCore.MySql 9.0.0 to an EF Core 10 project failed with NU1608: Detected package version outside of dependency constraint, plus NU1902 for MySqlConnector 2.4.0. Why a provider for EF Core 9 can't run on EF Core 10, why suppressing the warning is wrong, and the fix: a provider built for EF Core 10.
7 min readFixed: "dotnet package update --vulnerable: error: Restore failed. Unhandled exception: Specified method is not supported."
dotnet package update --vulnerable crashed with error: Restore failed and Unhandled exception: Specified method is not supported. in a .NET 10 solution with TreatWarningsAsErrors. Microsoft's docs explain the cause, NuGet warnings failing the command's own restore, and give the workaround I used: a condition on TreatWarningsAsErrors and an environment variable.
7 min readFixed: "NU1903: Warning As Error: Package 'Newtonsoft.Json' 12.0.3 has a known high severity vulnerability"
Restore and build failed with error NU1903: Warning As Error: Package has a known high severity vulnerability. What NuGet Audit found, the two commands that failed while I tried to fix it, the report that worked with --no-restore, and the version change that cleared it. Real output from .NET 10.
7 min readFixed: "System.IO.IOException: Failed to bind to address http://127.0.0.1:5190: address already in use." in ASP.NET Core
dotnet run stopped with Hosting failed to start: System.IO.IOException: Failed to bind to address http://127.0.0.1:5190: address already in use. How to find the process that holds the port with lsof (or PowerShell on Windows), stop it cleanly, or run on another port, with real output from .NET 10 on macOS.
7 min readFixed: "error IDE0044: Make field readonly" in a .NET C# Build
dotnet build failed with error IDE0044: Make field readonly after turning on EnforceCodeStyleInBuild. What the rule checks, why a code-style suggestion became a build error, the one-word fix, and how to change the rule's severity in .editorconfig if you disagree with it.
5 min readFixed: "error NU1109: Detected package downgrade: Microsoft.EntityFrameworkCore.Relational from 10.0.12 to centrally defined 10.0.11"
dotnet restore failed with error NU1109: Detected package downgrade … to centrally defined version, in a .NET C# solution with Central Package Management and transitive pinning. How to read the two dependency lines under the message, why NuGet refuses, and the two fixes from Microsoft's NU1109 page.
5 min readFixed: "NU1202: Package Microsoft.EntityFrameworkCore 11.0.0-rc.3 is not compatible with net10.0"
dotnet package add --prerelease failed with error NU1202: Package Microsoft.EntityFrameworkCore 11.0.0-rc.3 is not compatible with net10.0 (.NETCoreApp,Version=v10.0). What the supports: line means, why the project file was left unchanged, and the two fixes: a package version for your framework, or a newer target framework.
6 min readFixed: "error CS0246: The type or namespace name 'Dewiride' could not be found (are you missing a using directive or an assembly reference?)"
dotnet build failed with error CS0246: The type or namespace name could not be found. The question at the end of the message names the two usual causes. How to tell from the name in quotes and the line number which one you have, and the fix for each: a project reference or a using directive.
7 min readFixed: "MSB1011: Specify which project or solution file to use because this folder contains more than one project or solution file."
dotnet build stopped with MSBUILD : error MSB1011 right after dotnet sln migrate created an .slnx next to the old .sln. Why MSBuild refuses to guess, what Microsoft's MSB1011 page does and doesn't cover, and the two fixes: name the file, or keep one solution per folder.
7 min readFixed: EF Core UseCollation() Doesn't Change the MySQL Column Collation with Oracle's MySql.EntityFrameworkCore
With Oracle's MySQL provider, EF Core's UseCollation("utf8mb4_0900_as_cs") produced a migration that applied with Done, yet the column stayed utf8mb4_0900_ai_ci and ERROR 1062 still fired. What the generated SQL showed, what Oracle documents instead (ForMySQLHasCollation), and the migration that really changes the collation.
10 min readFixed: "Failure processing application bundle. DOTNET_BUNDLE_EXTRACT_BASE_DIR is not set, and a read-write cache directory couldn't be created."
An EF Core migrations bundle, a single-file .NET executable, failed on macOS with Failure processing application bundle. Failed to determine location for extracting embedded files. How I found a root-owned ~/.net folder, what Microsoft's docs say about the extraction folder, and two fixes.
8 min readFixed: "The migration '…_MakeDescriptionRequired' has already been applied to the database. Revert it and try again." in EF Core
dotnet ef migrations remove refused: The migration has already been applied to the database. Revert it and try again. How to confirm which migrations are applied, revert to the previous one, remove it cleanly, and when to add a new migration instead. Real output from EF Core 10 on MySQL 9.7.
7 min readFixed: "Your target project 'Dewiride.Inventory.Api' doesn't match your migrations assembly 'Dewiride.Inventory.Data'" in EF Core
dotnet ef migrations add failed with Your target project doesn't match your migrations assembly. Either change your target project or change your migrations assembly. What the target project and the migrations assembly are, which of the message's two fixes to pick, and why migrations list worked from the same folder.
7 min readFixed: "Your startup project 'Dewiride.Inventory.Data' doesn't reference Microsoft.EntityFrameworkCore.Design" in dotnet ef
dotnet ef said: Your startup project doesn't reference Microsoft.EntityFrameworkCore.Design. This package is required for the Entity Framework Core Tools to work. Why installing the package where the message points is often the wrong fix, how to check which project has it, and the right startup project for a class library DbContext.
7 min readFixed: "No project was found. Change the current working directory or use the --project option." in dotnet ef
dotnet ef migrations add stopped with No project was found. Change the current working directory or use the --project option. Why EF Core's tools can't use a solution folder, how to see which project they need, and the command that works for a .NET C# solution with the DbContext in a class library.
6 min readFixed: "error CS8618: Non-nullable property 'Description' must contain a non-null value when exiting constructor" in C#
dotnet build failed with error CS8618: Non-nullable property must contain a non-null value when exiting constructor. What the compiler is protecting you from, the five ways to answer it, each built for real on an EF Core entity, and how to choose: required, a constructor, nullable, a default value or null!.
9 min readFixed: "The association between entity types 'Category' and 'Product' has been severed, but the relationship is either marked as required" in EF Core
Deleting a parent row with its children loaded threw InvalidOperationException: The association between entity types has been severed, but the relationship is either marked as required. Why EF Core throws it from Remove() before any SQL runs, why a try/catch around SaveChanges misses it, and the fix for a restrict-delete relationship.
10 min read