✅ EF SaveChanges in transactions
Hello,
Does it make a difference if
Multiple times
One time
Does it make a difference if
SaveChangesSaveChanges is called after each AddAdd operation or only one time after the last AddAdd operation?Multiple times
c#
await using var transaction = await _dbContext.Database.BeginTransactionAsync();
await _dbContext.Domains.AddAsync(domain);
await _dbContext.SaveChangesAsync();
await _dbContext.DomainVerifications.AddAsync(domainVerification);
await _dbContext.SaveChangesAsync();
await transaction.CommitAsync();c#
await using var transaction = await _dbContext.Database.BeginTransactionAsync();
await _dbContext.Domains.AddAsync(domain);
await _dbContext.SaveChangesAsync();
await _dbContext.DomainVerifications.AddAsync(domainVerification);
await _dbContext.SaveChangesAsync();
await transaction.CommitAsync();One time
c#
await using var transaction = await _dbContext.Database.BeginTransactionAsync();
await _dbContext.Domains.AddAsync(domain);
await _dbContext.DomainVerifications.AddAsync(domainVerification);
await _dbContext.SaveChangesAsync();
await transaction.CommitAsync();c#
await using var transaction = await _dbContext.Database.BeginTransactionAsync();
await _dbContext.Domains.AddAsync(domain);
await _dbContext.DomainVerifications.AddAsync(domainVerification);
await _dbContext.SaveChangesAsync();
await transaction.CommitAsync();