Do you only get the rows you need?

Loading last updated info...

It's expensive retrieving data from a database, as such it's important to only ask for the rows you require when getting data.

Entity Framework nicely translates the various filters like the Where method into SQL WHERE clauses. This makes it really easy to write nice readable code that is also very efficient.

List<Sale> sales = context.Sales.ToList();
foreach (var sale in sales)
{
    if (sale.ProductId == request.ProductId)
    {
        // Do stuff
    }
}

❌ Figure: Bad example - Retrieved all the data instead of items that matched the product id.

List<Sale> sales = context.Sales
      .Where(sale => sale.ProductId == Request.ProductId)
      .ToList();

foreach (var sale in sales)
{
    // Do stuff
}

✅ Figure: Good example - Only the data required was retrieved from the database

Do you only get the rows you need?

Categories

Authors

Need help?