Lazy loading in loop (ARCH206)

Anahtar dotnet.ef.lazy-loading-in-loop · Onem warning · Kategori ef

Lazy loading etkinken dongu icindeki her navigation erisimi sessizce ek bir sorgu tetikler.

Hatali

var customers = await _db.Customers.ToListAsync();
foreach (var c in customers)
{
    total += c.Orders.Sum(o => o.Total); // lazy load per customer
}

Dogru

var customers = await _db.Customers
    .Include(c => c.Orders)
    .ToListAsync();
foreach (var c in customers)
{
    total += c.Orders.Sum(o => o.Total);
}

Duzeltme

Iliskili koleksiyonlari Include() ile onceden yukleyin.