SqlSugar open source ORM framework v5.0.4.2

Introduction to SqlSugar open source ORM framework

SqlSugar is an old .NET open source ORM framework, maintained and updated by the Fructose Big Data Technology Team. The number of Github stars is second only to EF and Dapper.

Advantages: easy to use, full-featured, high-performance, lightweight, complete services

Supported databases: MySql, SqlServer, Sqlite, Oracle, postgresql, Dameng, Renmin University of Finance and Economics

contrast
SqlSugarVSDapper completely suppresses Dapper in terms of performance and functionality. Although the basic performance is tied with Sugar, Dapper is completely incapable of batch operations.

SqlSugarVSEF, SqlSugar is small and fully functional. The most important thing is that it is easy to get started, has low learning cost and has higher performance than the EF framework.

SqlSugar open source ORM framework performance

The performance is higher than most DbHelper. The bottom layer uses Emit to dynamically create data binding assemblies for caching. The performance after caching can reach the native level. On the contrary, the original ADO requires a lot of boxing and unboxing operations, but the performance decreases.

SqlSugar open source ORM framework features

The functional requirements of SqlSugar are all real project requirements from more than 1,000 developers. Perfect design based on these requirements. After more than 5 years of accumulation,

It can perfectly meet all enterprise-level needs, especially the query function. It supports various types of returns such as DataTable, List, dictionary, etc., and also supports various queries.

For example, querying multiple result sets at one time, of course, stored procedures are also supported.

SqlSugar open source ORM framework 5.0.2 update log

Add mysqlbulkcopy

Added new multi-tenancy model

Add Change<T> to the warehouse to switch warehouses

CodeFirst composite index name optimization

Mapper irregular mapping supports Where

InitKey defaults to Attribute

mysql creates database and adds default encoding

Asynchronous sub-database, table and paging plus 3 overload query BUG

Sorting after using MergetTable() Sqlfunc.if(xx).return(xx).end(xx) parsing BUG

saveableadd removechache

sqlite supports indexing

Optimize inserting "null" string when json type value is null

Delete some outdated interfaces