SQLSugar C# Tutorial: ORM Database Guide

1 year ago
Sophia Anderson
1 minute

Using the SQLSugar library in C# makes it easy to manipulate databases. SQLSugar is a database access library based on ORM (Object Relational Mapping) which helps developers simplify database operations.

Here is a basic usage example of SQLSugar:

  1. Set up database connection information:
string connectionString = "Data Source=server;Initial Catalog=database;User Id=user;Password=password;";
SqlSugarClient db = new SqlSugarClient(connectionString);
  1. Search for data:
var userList = db.Queryable<User>().ToList();
  1. Inserting data:
User user = new User()
{
    Name = "Alice",
    Age = 25,
    Email = "alice@example.com"
};
int id = db.Insertable(user).ExecuteReturnBigIdentity();
  1. Update data.
db.Updateable<User>().SetColumns(it => new User() { Name = "Bob" }).Where(it => it.Id == 1).ExecuteCommand();
  1. Delete data:
db.Deleteable<User>().Where(it => it.Id == 1).ExecuteCommand();

The basic usage of the SQLSugar library can be easily understood through the examples above. Developers can perform more complex database operations based on specific requirements and business logic.

bannerAds