SqlSugar
SqlSugar is an open source ORM framework for .NET, designed to be easy to use right out of the box with a low-code, high-performance approach. It supports a wide range of .NET versions including .NET Framework, .NET Core 3.1, .NET 5 through 10, and works with both C and VB.NET. The framework is compatible with numerous databases such as MySQL, SQL Server, SQLite, Oracle, PostgreSQL, MongoDB, DB2, Hana, DuckDB, ClickHouse, QuestDb, TDengine, OceanBase, GaussDB, TiDB, and several Chinese databases including Dameng, Kingbase, Highgo, and Shentong. Key features include zero-SQL table creation, automatic indexing, and full CRUD support without writing SQL statements. It handles big data operations efficiently, supporting millions of writes, updates, subtable partitioning, and billions of query statistics. SqlSugar offers comprehensive SAAS capabilities including cross-database queries, audit logging, tenant-based sub-database and sub-table isolation, and tenant data separation. It supports dynamic class and table