private void WriteToDb(MyMessage message)
{
using (var context = new MyMessageDbContext())
{
context.Messages.Add(message);
context.SaveChanges();
}
}
public void WriteToDb(List <MyMessage> messages)
{
using (var context = new MyMessageDbContext())
{
foreach (var message in messages)
{
context.Messages.AddOrUpdate(message);
}
context.SaveChanges();
_logger.LogInformation($"Saved {context.ChangeTracker.Entries().Count()} of {messages.Count} records to database ({context.ChangeTracker.Entries().Count(e => e.State == Microsoft.EntityFrameworkCore.EntityState.Modified)} updates, {context.ChangeTracker.Entries().Count(e => e.State == Microsoft.EntityFrameworkCore.EntityState.Added)} inserts, {context.ChangeTracker.Entries().Count(e => e.State == Microsoft.EntityFrameworkCore.EntityState.Unchanged)} existing)");
}
}
