Guide EF Core migration and LINQ usage for Pomelo MariaDB in .NET 10 projects.
npx skills add https://github.com/rloisell/rl-agents-n-skills --skill ef-core-rloisell
Please help me install this Agent Skill. Skill: ef-core Source: https://github.com/rloisell/rl-agents-n-skills/tree/main/ef-core Command: npx skills add https://github.com/rloisell/rl-agents-n-skills --skill ef-core-rloisell
Provides clear, production-ready guidance to avoid migration failures, runtime LINQ surprises, and misconfigured DbContext registrations when using EF Core with the Pomelo MariaDB provider.
Add a migration named InitialCreate to the project and apply it to the database using the Pomelo MariaDB provider.
High-intent search queries and answers about installing and using this skill.
EF Core migration failures with Pomelo MariaDB often stem from using EnsureCreated() instead of db.Database.Migrate() or misconfigured DbContext registrations. This guidance enforces proper migration workflows and DI registration to prevent schema update errors and startup failures.
To fix the LINQ Contains runtime bug on Linux, use List<string> collections instead of other enumerable types in your LINQ queries. This prevents the ReadOnlySpan translation issue specific to the Pomelo MariaDB provider environment.
You need the Microsoft.EntityFrameworkCore and Pomelo.EntityFrameworkCore.MySql NuGet packages for your .NET 10 project. These packages provide the core EF Core functionality and the specific MariaDB database provider implementation.
To add and apply an InitialCreate migration with MariaDB, use the standard EF Core migration commands within your project. This guidance provides the correct naming conventions and workflow to safely add, apply, and rollback schema changes.
Yes, you can use an in-memory database for testing your EF Core data layer. This guidance includes testing recommendations and service-layer patterns to map domain exceptions to HTTP statuses, ensuring robust test configuration.
OpenCovenCheck NuGet package versions and scan .NET dependencies for vulnerabilities.
signalbeam-ioCreate EF Core migrations for microservice database contexts with dotnet ef.
BridgingIT-GmbHAutomate EF Core DbContext setup, migrations, and LINQ queries for .NET applications.
SparkymodManage EF Core migrations across SQL Server and MySQL providers.
