# DotNetNext/SqlSugar

.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

Repository: https://github.com/DotNetNext/SqlSugar
Canonical: https://ross.abutalabs.com/products/sqlsugar
Homepage: https://www.donet5.com/Home/Doc
Language: C#
License: MIT
License Family: permissive
Topics: orm, sqlsever, mysql, sqlite, oralce, postgresql, mongodb, clickhouse
Last push: 2026-08-19T08:50:11+00:00

## Health v2 (maintenance only)
Score: 70/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 98, release rhythm 16, longevity 100
- inputs: {"age_days": 4069, "days_push": 14, "days_rel": 423, "gap_med": 99, "n_releases_24m": 2}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 5827, forks 1389 (observed 2026-08-28T04:09:30.125930+00:00)

## What it is
SqlSugar is an open-source, multi-database ORM framework for .NET (C# and VB.NET), supporting MySQL, SQL Server, PostgreSQL, SQLite, Oracle, MongoDB, ClickHouse, and many Chinese and cloud databases. It provides zero-SQL CRUD, table building, indexing, big-data write/query solutions, and SaaS features like cross-database queries and tenant isolation.

## Use cases
- map C# classes to database tables without writing SQL
- build a .NET app that works across MySQL, SQL Server, and PostgreSQL
- implement multi-tenant SaaS with tenant sub-database or sub-table isolation
- write millions of rows in bulk to a database from .NET
- query and CRUD MongoDB from C# with an ORM API
- support Chinese domestic databases like Dameng, KingbaseES, and GaussDB in .NET
- do cross-database queries in a single application

## When to choose
- you are building .NET/C# applications needing one ORM across many database engines
- you need SaaS multi-tenancy, cross-database queries, or low-code dynamic table/CRUD features
- you must support Chinese domestic databases (Dameng, KingbaseES, Shentong, GBase) from .NET

## When to avoid
- your team prefers EF Core's ecosystem, LINQ conventions, and tooling
- you work outside the .NET ecosystem
- you need a lightweight micro-ORM like Dapper rather than a full-featured framework

## Facets
- artifact type: library
- maturity: active
- function: orm, database, database-driver
- domain: databases, backend, web-development, developer-tools
- platform: dotnet, cross-platform, windows
- tags: csharp, multi-database, mongodb, mysql, sqlserver, postgresql, sqlite, oracle, clickhouse, saas-multitenancy, chinese-databases, linux, macos

## Member repositories
- DotNetNext/SqlSugar (main) score 70

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:09:30.125930+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:52:05.937680+00:00, confidence not recorded.
  - readme: https://github.com/DotNetNext/SqlSugar (fetched 2026-08-28T04:09:30.125930+00:00, sha 1aaac6fdd1ac)
- Data as of 2026-08-30T08:39:29.467469+00:00.