如何在Entity Framework中安全地增加计数器

// 定义计数器实体类
public class Counter
{
    public int Id { get; set; }
    public int Value { get; set; }
}

// 创建DbContext类
public class MyDbContext : DbContext
{
    public DbSet<Counter> Counters { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        // 配置数据库连接字符串
        optionsBuilder.UseSqlServer("YourConnectionString");
    }
}

// 在应用程序中使用计数器
public class CounterService
{
    public void IncreaseCounter(int increment)
    {
        using (var dbContext = new MyDbContext())
        {
            using (var transaction = new TransactionScope())
            {
                // 获取计数器的当前值
                var counter = dbContext.Counters.FirstOrDefault();
                if (counter != null)
                {
                    // 增加计数器的值
                    counter.Value += increment;

                    // 保存计数器的值回数据库
                    dbContext.SaveChanges();
                }

                transaction.Complete();
            }
        }
    }
}