Dapper.FastCRUD

Uses C# 6 nameof operators and formattable strings to prevent mistyped column names, ensuring errors are caught at compile time rather than runtime, as shown in the query example with nameof(Person.FirstName).

Works with SQL Server, MySQL, PostgreSQL, SQLite, SQL Anywhere, and LocalDb, providing flexibility for applications targeting different database systems without switching ORMs.

Benchmarks show it performs competitively with Dapper and significantly faster than Entity Framework, with pre-computed CRUD queries for efficient operations, as detailed in the benchmark table.

Supports code-first via data annotations, fluent registration, database-first (SQL Server only), and semi-POCO metadata, catering to various development workflows and legacy codebases.

Allows joins and self-referenced entities with alias support for complex queries, enabling relationship handling only when needed, as demonstrated with the Include method and aliases.