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 |
| SqlSugar | Fluent API for querying and modifying databases |
| FreeSql | Povides APIs for querying and modifying relational databases |
| RepoDB | Hybrid ORM library for .NET |
| Venflow | Fast and lightweight ORM for PostgreSQL |
Read our verdict in the software roundup.
 Explore our carefully curated directory of recommended free and open source software, covering every major software category.The directory forms part of our extensive collection of articles for Linux enthusiasts. It includes hundreds of detailed reviews, together with free and open source alternatives to proprietary software from companies such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. LinuxLinks also covers interesting projects worth exploring, Linux-compatible hardware, free programming books and tutorials, and much more. Know a useful free and open source Linux application that we haven’t covered? Tell us about it using our submission form. |
Please read our Comment Policy before commenting.