First I'd like to say that I enjoy reading the book. It's very informative and a great reference.
I also love the blueprint.
I'm looking for some explanation & sample on using the DAL when I only need part of the data.
Let's say that I only want to display a list of customers in some list box. I may have an index on the Name column of the Customer table - making this very fast compared to fetching all of the fields.
How do I do that?
Do you have any sample of such scenario?