This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Programming › .Net/C # › Simple use of the ORM framework SqlSugar
View: 45700|Reply: 1

[Source] Simple use of the ORM framework SqlSugar

[Copy link]
Posted on 2021-4-20 10:32:16 | | |

SqlSugar is a veteran .NET open source ORM framework maintained and updated by the Fructose Big Data Technology team, with a Github star count second only to EF and Dapper

Advantages: Easy to use, full of functions, high performance, lightweight, complete service, with professional technical support 18 hours a day

Supported databases: MySql, SqlServer, Sqlite, Oracle, postgresql, Dameng, and People's Congress Jincang

GitHub address:https://github.com/donet5/SqlSugar

Document address:https://www.donet5.com/home/doc

review

The ORM framework Dapper is simple to use
https://www.itsvse.com/thread-9509-1-1.html

The ORM framework Dapper gets the executed sql statement
https://www.itsvse.com/thread-7509-1-1.html
Insertion for the TimeStamp field

Create a class

Add [SugarColumn(IsOnlyIgnoreInsert = true)] to the property, otherwise an error will occur. The error is as follows:

You cannot insert explicit values into timestamp columns. Use INSERT on the column list to exclude timestamp columns, or insert DEFAULT into timestamp columns.






Previous:ASP.NET Core SignalR Distributed Chat System [with source code]
Next:The difference between utf8 and utf8mb4 in MySQL

Related Posts
Posted on 2021-12-10 08:43:57 |
Learn to learn
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com