One of the new innovations coming in C# 3.0 is the concept of Language Integrated Query. This bridges the gap between a programming language like C# and T-SQL. It introduces a form of syntax that will probably look pretty alien to you at first. This won't be around under the next version of Visaul Studio (next year when Vista comes out), but its good to know what it is.
Here is an example query.
IEnumerable<string> expr = from s in names where s.Length == 5
orderby s
select s.ToUpper();
At some point I will go into more detail of how it works once I fully understand it, but if you are interested in reading more about it, the article below is the place to start.
Read the complete post at http://www.dotnettipoftheday.com/blog.aspx?id=61