If you are using CRM 2011 with an on premise then you should be taking advantage of the new LINQ capabilities. LINQ is really good to use because it’s basically means that instead of writing SQL queries you can write .NET code to access the database. One warning I will give you is LINQ is not compatible with CRM 2011 online I think it’s because you can’t put it in the sandbox because LINQ uses transactions, although I’m not sure of the actual reason all I am saying is be careful because you might find yourself rewriting the LINQ queries in query expression if you change to CRM 2011 online. On the other hand if it’s an on premise solution then you should definitely use LINQ
I have written a blog entry before about CRM 2011 – getting started with LINQ
Today on Jamie Miley’s blog entry about using LINQ and CRM
There is an excellent tool which you can use to practise writing your LINQ queries and it’s called linqpad and you can read more about it and download it here
here is a bit of a description
LINQPad Plug-in for Microsoft Dynamics CRM 2011 lets you use LINQPad tool to query Microsoft Dynamics CRM 2011 with the CRM LINQ provider shipped with Microsoft Dynamics CRM 2011 SDK.
LINQPad (http://www.linqpad.net/) is a tool that may be described as “SQL Management Studio for LINQ queries”. LINQPad supports many standard .NET LINQ providers as well, as many of nonstandard ones. This project is intended to add support for the Microsoft Dynamics CRM 2011 LINQ-to-CRM provider.