linq2db/linq2db

Health v2 · maintenance only

Adoption not part of the score

3322 stars · 479 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

LINQ to DB is a fast, lightweight LINQ database access library for .NET that provides a type-safe layer between POCOs and databases. It sits above micro-ORMs like Dapper by offering compile-time checked LINQ queries while avoiding the overhead of change-tracking ORMs like Entity Framework.

Use cases

• query databases with type-safe LINQ instead of raw SQL strings
• perform bulk inserts and bulk copies into SQL Server, PostgreSQL, or ClickHouse
• use advanced SQL features like CTEs, window functions, and MERGE from C#
• access many databases (Oracle, DB2, Firebird, Informix, SAP HANA) through one API
• get faster data access than Entity Framework without change tracking
• write database queries that are checked by the C# compiler and refactorable
• use LINQ-style database access from F#

When to choose

• you want type-safe SQL with LINQ and minimal abstraction overhead
• you need high-performance data access with bulk copy and advanced SQL support
• you find Entity Framework too heavy but Dapper too string-based
• you need broad multi-database support in a single .NET library

When to avoid

• you rely on automatic change tracking and unit-of-work semantics
• you want a full-featured ORM with migrations and lazy loading out of the box
• your project is not on the .NET platform

Facets

library · maturity active

orm database database-driver serialization databases backend web-development developer-tools dotnet cross-platform windows linq sql micro-orm type-safe bulk-insert csharp fsharp clickhouse postgresql sqlserver mysql sqlite oracle linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="linq2db/linq2db")