SqlSugar Core Methods for Database Operations
The methods encapsulated in the Sqlsugar base class include the following options:
- Method of querying data: Use methods like Select, GetList, GetPageList to retrieve data from the database.
- Method of inserting data: Use methods such as Insert, InsertRange to insert new data into the database.
- Method for updating data: Update, UpdateRange, and other methods can be used to modify the data in the database.
- Method of data deletion: Use methods such as Delete and DeleteRange to remove data from the database.
- Transaction processing methods: Implement transaction processing using methods like BeginTran, CommitTran, RollbackTran, etc.
- Database connection method: Manage database connection and structure through methods like DbMaintenance and DbFirst.
These methods encapsulate basic database operations, simplifying code writing and improving development efficiency. Additionally, Sqlsugar provides a rich set of extension methods and attributes that allow for customization based on specific needs.