✅ EF SaveChanges in transactions

Hello,
Does it make a difference if

SaveChanges

SaveChanges

is called after each

Add

Add

operation or only one time after the last

Add

Add

operation?

Multiple times

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();

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

await using var transaction = await _dbContext.Database.BeginTransactionAsync();
            
await _dbContext.Domains.AddAsync(domain);
await _dbContext.DomainVerifications.AddAsync(domainVerification);

await _dbContext.SaveChangesAsync();
await transaction.CommitAsync();

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#•2y ago•

30 replies

Core

✅ EF SaveChanges in transactions

Hello,
Does it make a difference if

SaveChanges

SaveChanges

is called after each

Add

Add

operation or only one time after the last

Add

Add

operation?

Multiple times

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();

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

await using var transaction = await _dbContext.Database.BeginTransactionAsync();
            
await _dbContext.Domains.AddAsync(domain);
await _dbContext.DomainVerifications.AddAsync(domainVerification);

await _dbContext.SaveChangesAsync();
await transaction.CommitAsync();

await using var transaction = await _dbContext.Database.BeginTransactionAsync();
            
await _dbContext.Domains.AddAsync(domain);
await _dbContext.DomainVerifications.AddAsync(domainVerification);

await _dbContext.SaveChangesAsync();
await transaction.CommitAsync();

✅ EF SaveChanges in transactions

Similar Threads

✅ EF SaveChanges in transactions

Similar Threads

Similar Threads

Similar Threads