SqlSugar is a .NET object-relational mapping framework that supports multiple database systems and .NET versions from the framework through .NET 10.
The tool addresses the need for a lightweight ORM that minimizes boilerplate code while maintaining performance across diverse database platforms. It achieves this through a zero-SQL approach where table creation, indexing, and CRUD operations require no manual SQL writing. The framework supports both entity-based and dynamic operations, allowing developers to work with or without predefined entity classes. It includes specialized handling for large-scale data operations, multi-tenancy scenarios with database and table sharding, and cross-database queries within a single application.
SqlSugar suits teams building applications on .NET that need to work with multiple database backends without rewriting data access logic. It is particularly valuable for projects requiring multi-tenancy support, high-volume data operations, or compatibility with both mainstream databases like MySQL, SQL Server, and PostgreSQL alongside specialized systems like ClickHouse, MongoDB, and various Chinese domestic databases. The framework's support for dynamic operations and JSON-to-SQL conversion makes it applicable to low-code scenarios and applications with flexible schema requirements.
The maintainers typically respond to new issues and pull requests within a day.
