SugarORm使用

使用Sugar ORM库执行自增操作的示例

using SugarDb = Sugar;

public class Program
{
    public static void Main(string[] args)
    {
        var db = new SugarDb.SugarDB("connection_string");

        // 假设要自增的模型的ID为1
        var sql = $"UPDATE MyModel SET Count = Count + 1 WHERE Id = {1}";
        db.Ado.ExecuteCommand(sql);
    }
}

采用乐观并发控制（Optimistic Concurrency Control）来解决冲突的问题。以下是一个使用Sugar ORM和乐观并发控制解决并发修改的示例

using SugarDb = Sugar;

public class Program
{
    public static void Main(string[] args)
    {
        var db = new SugarDb.SugarDB("connection_string");
        
        // 假设要自增的模型的ID为1
        var model = db.FindById<MyModel>(1);
        if (model != null)
        {
            model.Count++;
            model.Version++; // 递增版本号
            var rowsAffected = db.Update<Model>(m => new Model { Count = m.Count, Version = m.Version }, m => m.Id == model.Id && m.Version == model.Version);
            if (rowsAffected == 0)
            {
                // 更新失败，版本号不匹配，说明有并发修改
                Console.WriteLine("Concurrent modification detected. Please try again.");
            }
        }
    }
}