SqlSugar is a feature-rich object-relational mapping (ORM) framework for .NET applications. It provides a fluent API for querying and modifying databases while reducing the need to write SQL manually.
The framework supports .NET Framework, .NET Core 3.1, and modern .NET releases. It works with a broad range of databases, including MySQL, MariaDB, SQL Server, SQLite, PostgreSQL, Oracle, MongoDB, DuckDB, DB2, ClickHouse, OceanBase, GaussDB, TiDB, SAP HANA, and ODBC data sources.
This is free and open source software.
Key Features
- Offers fluent APIs for querying, inserting, updating, and deleting data.
- Supports joins, paging, navigation properties, dynamic expressions, and query filters.
- Creates database tables and indexes directly from entity definitions.
- Provides bulk copy, bulk update, bulk merge, bulk query, and bulk deletion operations.
- Supports multiple databases and cross-database queries within an application.
- Includes multi-tenant databases, tables, transactions, and data isolation.
- Automatically partitions tables by year, quarter, month, week, or day.
- Provides repositories, units of work, value objects, AOP, and DbContext support.
- Supports dynamic entities, JSON-to-SQL conversion, and low-code development.
- Runs on .NET Framework, .NET Core 3.1, and .NET 5 through .NET 10.
Website: github.com/DotNetNext/SqlSugar
Support:
Developer: Fructose Big Data Technology team
License: MIT License
SqlSugar is written in C#. Learn C# with our recommended free books and free tutorials.
Related Software
| C# Object-Relational Mapping Software | |
|---|---|
| Entity Framework Core | Modern object-database mapper for .NET. |
| Dapper | Simple object mapper for .NET |
| NHibernate | Mature, open source object-relational mapper for .NET |
| LINQ to DB | LINQ database access library |
| RepoDB | Hybrid ORM library for .NET |
| Venflow | Fast and lightweight ORM for PostgreSQL |
Read our verdict in the software roundup.
 Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |
Please read our Comment Policy before commenting.