If you are developing ESRI web mapping applications that have a database backend and you are not using LINQ or the Entity framework and are still writing straight SQL queries then you need to get in gear and read this book.
Entity Framework learning guide is a great FREE resource. The deal with LINQ and EF is that they are ORM's or Object Relational Mappings. In a nutshell, they create strongly typed classes modeled from your database. If you have a table in your SQL database called Streets, then you'll have a class in C# that contains all the attributes of that table as properties. So awesome! The EF is build on top of the LINQ syntax but is getting more attention from microsoft so we at AGRC are going to be adopting this technology in our new applications. It states to have a better grasp on complicatated relationships.
Fire up that brain and start playing with lamda expressions and leave the SQL at home!