The most prominent theme of C# 3.0 was data, which is realized through Language Integrated Query (LINQ). Most of the other language features, such as implicitly typed local variables, anonymous types, lambda expressions, and extension methods were added to support LINQ. LINQ is a way to write SQL-like statements in your code to query multiple types of data sources. What is attractive about this is that you now have a common way to write code to access different data sources, meaning that you don't have to completely re-learn the wheel every time MS introduces a new data access technology or you need to use a 3rd party data source. Since most of the major database vendors are supporting LINQ in some way, the benefits of this common way to query data is being realized today.
Some people like LINQ and others don't. I'm in the camp that believes it is a great addition to the language, but you should look at your own requirements and situation and make an informed decision on whether adopting C# 3.0 is right for you.