* within the SQL query has an unfortunate drawback. It retrieves everything based on the parameters passed into the query. This could mean hundreds of objects returned to
As previously discussed, help is at hand. That help is in the form of LINQ.
It should become apparent that LINQ is a powerful addition to the programmer's arsenal. To quote the grandfather of telesales, Billy Mays—but wait, there's more!
There are six ways of finding data within a collection:
Where allows searching a collection based on any parameter within the collection. This will result in