A high-performance, multi-database compatible .NET ORM framework with low-code features and enterprise-ready solutions.
SqlSugar is an open-source ORM framework for .NET that simplifies database operations by mapping objects to relational databases. It solves the complexity of raw SQL by providing a fluent, intuitive API for CRUD operations, querying, and transactions across multiple database systems. The framework is designed for high performance, supporting big data scenarios and enterprise features like multi-tenancy and low-code development.
.NET developers building data-intensive applications, especially those needing multi-database support, high-performance data access, or enterprise features like SAAS tenant isolation. It's also suitable for teams adopting low-code approaches or requiring compatibility with specialized databases like Chinese domestic databases.
Developers choose SqlSugar for its exceptional ease of use, extensive database compatibility, and robust performance features out of the box. Unlike some ORMs, it combines low-code flexibility with enterprise-grade capabilities like automatic table splitting, cross-database transactions, and AOT support, making it a versatile choice for both simple and complex .NET projects.
.Net aot ORM SqlServer ORM Mongodb ORM MySql 瀚高 Postgresql ORM DB2 Hana 高斯 Duckdb C# VB.NET Sqlite ORM Oracle ORM Mysql Orm 虚谷数据库 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET9 ORM .NET8 ORM ClickHouse ORM QuestDb ,TDengine ORM,OceanBase ORM,GaussDB ORM,Tidb ORM Object/Relational Mapping
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Supports over 20 databases including niche Chinese ones like Dameng and Renmin Jincang, making it versatile for diverse environments.
Optimized for big data with Fastest.BulkCopy and BulkUpdate methods, efficiently handling millions of records as demonstrated in the README examples.
Includes multi-tenancy, automatic table splitting, and cross-database transactions, ready for SAAS applications without additional setup.
Enables dynamic table creation and CRUD without entities using JSON or XML, reducing boilerplate code for rapid development.
The README prioritizes Chinese documentation links, which can hinder non-Chinese speakers from accessing comprehensive guides and support.
The plethora of features like dynamic expression building and automatic table splitting adds unnecessary overhead for simple CRUD applications.
Compared to Entity Framework Core, SqlSugar has fewer third-party tools, extensions, and community resources, limiting integration options.
SqlSugar is an open-source alternative to the following products: