Snippets for 2009 blog post "Testing LINQ Queries"

TL1.cs

/// <summary>
/// Finds leads in the repository by Customer Name.
/// </summary>
/// <param name="repo" />Repository of Leads</param>
/// <param name="customerName" />Customer name</param>
/// <returns>Leads matching the criteria</returns>
public static IQueryable<Lead> ByCustomerName(this IQueryable<Lead> repo, string customerName)  
{
    if (customerName.IsNullOrEmpty())
    {
        return repo;
    }

    return repo
        .Where(
            l => l.Customers.Any(c => c.Name.Contains(customerName)));
}

TL2.cs

return this.leadRepository  
    .ByAllocatedUserId(query.AllocatedUserId)
    .ByClosed(query.Closed)
    .ByCustomerId(query.CustomerId)
    .ByCustomerName(query.CustomerName)
    .ByLeadTypeIds(query.LeadTypeIds)
    .ByProjectId(query.ProjectId)
    .ByScapeId(query.ScapeId)
    .ByStarred(query.Starred)
    .Sort(sortField, sortDescending)
    .Skip(offset)
    .Take(maximumResults)
    .ToDto()
    .ToArray();