DotNetNext/SqlSugar
SqlSugar
SqlSugar is an object-relational mapping library for .NET that translates C# and VB objects into database queries and tables without requiring raw SQL. It is designed as a multi-database ORM supporting SQL Server, MySQL, PostgreSQL, Oracle, MongoDB, ClickHouse, and other databases through a unified API, and it is compatible with .NET AOT compilation for native ahead-of-time deployment.
The library distinguishes itself through high-speed bulk data operations that can insert or update millions of records in seconds using batch processing instead of row-by-row handling. It also provides multi-tenant transaction coordination, allowing transactions to be managed atomically across multiple databases or tenants. Dynamic query building is supported through programmatic expression composition, and time-based table partitioning routes inserts and queries to the correct physical table based on date fields.
Additional capabilities include building multi-table join queries with a fluent lambda syntax, eager loading of related navigation properties, applying global query filters, paginating results, and performing upsert operations. The library abstracts database-specific SQL dialects behind a common interface, switching providers based on connection string parameters.
Features
- Database ORMs - Maps C# and VB objects to multiple relational databases through a unified ORM interface.
- Object Mappings - Translates C# or VB objects into relational database tables and queries, enabling data access without raw SQL.
- Bulk Data Operations - Inserts or updates millions of records in seconds using bulk operations that bypass row-by-row processing.
- Batch Pipelines - Provides a batch pipeline that groups records into chunks for high-speed bulk inserts and updates.
- Eager Loading Strategies - Eagerly load nested navigation properties in a single query to retrieve related entities together.
- Database Query Joins - Constructs multi-table join queries using a fluent lambda syntax that generates SQL automatically.
- Eager Loading - Resolves related entity references in a single query by generating JOIN clauses from object graph metadata.
- LINQ Expression Translators - Translates C# lambda expressions into SQL statements at runtime using an expression tree visitor.
- Fluent Query Builders - Constructs SQL join queries through a chain of method calls that map directly to SQL clauses.
- Filter Expression Builders - Builds filter expressions programmatically at runtime by combining multiple conditions with logical operators.
- Bulk ORM Operations - Performs high-speed bulk inserts and updates for millions of records using batch operations.
- Cross-Tenant Transaction Coordinators - Coordinates transactions across multiple databases or tenants, committing or rolling back all changes atomically.
- Distributed Transaction Coordinators - Coordinates atomic transactions across multiple databases or tenants with commit or rollback.
- .NET Database Integration - Connects .NET applications to relational databases using typed objects for data retrieval without raw SQL.
- Multi-Database Providers - Supports SQL Server, MySQL, PostgreSQL, Oracle, MongoDB, and ClickHouse through a unified API.
- Bulk Update Utilities - Loads or updates large volumes of records in seconds using bulk operations that bypass row-by-row processing.
- Logical Expression Combiners - Combines multiple filter conditions into expression trees using logical operators for programmatic query building.
- Programmatic Condition Combiners - Constructs filter expressions programmatically at runtime by combining multiple conditions with logical operators.
- Transaction Coordinators - Coordinates transactions across multiple databases or tenants with atomic commit or rollback.
- Distributed Transaction Coordinators - Manages distributed transactions across multiple database connections with atomic commit or rollback.
- Database - Abstracts database-specific SQL dialects behind a common interface, switching providers via connection string.
- Fluent Join Builders - Provides a fluent lambda syntax for building multi-table join queries without writing raw SQL.
- Global Data Filters - Applies persistent filter conditions to all queries on a table, automatically restricting returned rows.
- Paginated Results - Splits a query result set into pages by specifying page index and size, returning only the requested slice.
- Upsert Operations - Inserts new rows or updates existing ones in a single operation based on whether a matching record already exists.
- Date-Based Routers - Routes insert and query operations to the correct physical table partition based on a date field value.
- Time-Based Partition Routers - Automatically routes inserts and queries to the correct physical table partition based on date fields.
- AOT-Compatible ORMs - Designed for .NET AOT compilation, enabling native deployment without reflection-based startup overhead.
- Object Relational Mappers - ORM supporting multiple relational database management systems.
