linq2db/linq2db

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.

Star history