Can I combine a foreach and a LINQ query into one?

Question

I have a C# code that looks like this:

foreach (var entry in this.ChangeTracker.Entries()
                     .Where(e => e.Entity is IAuditableTable &&
                                 e.State == EntityState.Added))
{
    IAuditableTable e = (IAuditableTable)entry.Entity;
    e.ModifiedDate = DateTime.Now;
}

This seems to be like a combination of foreach and LINQ. Can sometone tell me is it possible for me to remove the foreach and combine this into one LINQ statement

Answer 1

I'd suggest not doing this. Keep everything as readable as possible:

var auditableTables = this.ChangeTracker.Entries()
                                        .Where(e => e.State == EntityState.Added)
                                        .Select(e => e.Entity)
                                        .OfType<IAuditableTable>();

foreach (var table in auditableTables)
{
    table.ModifiedDate = DateTime.Now;
}

My rule of thumb for coding - if you can't read it like a sentence, then it needs fixing.