SqlSugar is a simple and easy-to-use open source ORM framework.
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
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.
Function:
The functional requirements of SqlSugar are all real project requirements from more than 1,000 developers. Based on these requirements, we have designed them perfectly. After more than 5 years of accumulation, we can perfectly meet all enterprise-level needs, especially the query function, which supports various types of It returns data such as DataTable, List, dictionary, etc. It also supports various queries, such as querying multiple result sets at one time, and of course also supports stored procedures.