public async Task Increment(int amount)
{
using (var context = new StarContext(_config))
{
await context.TransactionRetryOnFailure(async transaction =>
{
/* Pessimistic lock. */
context.Database.ExecuteSqlCommand(
"SELECT null as dummy FROM dbo.starCounts WITH (tablockx, updlock)"
);
var starCount = context.StarCounts.Only();
starCount.Count = starCount.Count + amount;
await context.SaveChangesAsync();
transaction.Commit();
}, retries : 3);
}
}