I am definitely a type 2 developer, though my current job is more based around WPF and components. We are using WPF for example, but the UI is the basic Aero one, and I don't think that will be changed.
The problem with Linq to SQL and Entity Framework, is that they are just higher abstractions that generate T-SQL anyway. The reason most people struggle with T-SQL is because it is a pure functional language. The forthcoming EF will have a feature that allows
you to define a class, and then an option that says "generate database" that creates all the SQL for you. I just don't get why one would want to waste time learning Linq to SQL when you can open up SQL Sever Management Studio and compose you queries and SPROCS
Simply because the LINQ query EDSL gives you a cleaner, more flexible, more composable