linq2db/linq2db
Linq2db
linq2db is a type-safe object-relational mapper that translates LINQ expressions into optimized SQL queries for multiple database providers. It functions as a database mapper that links classes to tables and includes a SQL query builder and a command-line schema tool for generating data classes from existing databases.
The project provides high-performance bulk data processing for inserting and loading large volumes of records via batch or binary copy methods. It also supports advanced SQL operations, including window functions, common table expressions for recursive hierarchical querying, and dataset merging.
The library covers a broad range of data manipulation and query execution capabilities, including optimistic locking, query result pagination, and many-to-many navigation translation. It also includes systems for connection lifecycle management, transaction atomicity, and database operation interception.
Features
- Class-Based Schema Mappings - Links C# classes to database tables using attributes, fluent configurations, or naming inference.
- Type-Safe Query Builders - Provides a type-safe query builder that uses C# expressions to ensure compile-time safety for database queries.
- Database Schema Mapping - Links database tables and packages to C# classes using attributes or fluent configurations for structured data access.
- Database Transaction Management - Provides programmatic control over database transaction boundaries and connection lifecycles to ensure atomicity.
- Expression-Based Data Querying - Executes type-safe queries supporting composition, pagination, and selective column projection.
- LINQ Expression Translators - Converts LINQ expression trees into optimized, provider-specific SQL command trees.
- SQL Dialect Adapters - Provides a common interface to abstract database-specific syntax and functions across multiple SQL engines.
- SQL Query Builders - Provides a programmatic builder for constructing complex SQL queries with joins and window functions.
- Table-to-Code Mappers - Maps database tables to C# classes to enable type-safe interactions and query validation.
- Transaction Lifecycle Control - Manages the commitment or rollback of atomic database operations to ensure data integrity.
- Bulk Data Ingestion - Implements high-performance utilities for importing large volumes of data using provider-specific binary protocols.
- Bulk Data Loading - Provides high-performance utilities for importing massive datasets from external sources into database tables.
- Common Table Expressions - Allows the creation of reusable temporary result sets within queries to simplify complex logic.
- Batch Insertion Interfaces - Inserts large collections of records using efficient batching or binary copy interfaces.
- Database-to-Code Scaffolding - Ships a command-line tool to automatically generate data classes from an existing database schema.
- Database Connection Lifecycles - Controls the lifecycle of database connections through explicit disposal or per-query operations.
- Hierarchical Querying - Traverses self-referencing data structures and hierarchical relationships using specialized recursive querying.
- Join Operations - Provides inner and left join syntax within expressions to combine data from multiple tables.
- Table Merge Semantics - Synchronizes two tables by inserting, updating, or deleting records based on join conditions.
- Many-to-Many Relationship Managers - Translates queries over implicit join tables into SQL while supporting eager loading and composite keys.
- Advanced SQL Construct Execution - Provides execution support for advanced SQL constructs like window functions and common table expressions through an object-oriented interface.
- Recursive CTE Queries - Supports traversing self-referencing data structures and hierarchical relationships using recursive common table expressions.
- Deferred Query Compilation - Builds internal query representations as expression trees that are only compiled to SQL upon execution.
- Window Functions - Implements analytic window functions for performing calculations across sets of rows using partitioning and ordering.
- Model Generators - Includes a command-line tool for generating data classes based on an existing database schema.
- Custom SQL Function Registrars - Exposes database-specific functions to the query builder by defining signatures and argument conversion logic.
- Method Mapping - Binds C# static methods to native database functions to enable complex expressions in type-safe queries.
- Object Relational Mappers - Fast, type-safe LINQ database access layer for POCO objects.
