About mooSQL
mooSQL is a .NET-based SQL query framework. Its goal is to provide a simple, flexible, and powerful SQL querying solution.
Principles
Multi-database compatibility, multi-database by design, database-oriented, combining strengths of Dapper and SqlSugar.
WARNING
During iteration we try to stay backward compatible, but new features and simplicity take priority.
Repository
html
http://137.12.207.30:8088/maplehan/u8common.gitArchitecture
Stack
| Category | Choice |
|---|---|
| Runtime | .NET Framework 4.5+, .NET 6, .NET 8 |
| Layers | Execution, SQL composition, repository, expression |
| Multi-DB | Multi-database by design; switch anytime |
| Components | ORM-first; extensions (auth, Excel, AI, etc.) |
| Databases | SQL Server, MySQL, PostgreSQL, Oracle, SQLite, OceanBase, Taos, etc. |
| Extensibility | Dialect abstraction; low cost to extend |
| Advanced | Primary/replica, repositories, expression functions |
| Unique | SQLClip: complex queries without magic strings |