CRM 2011 – CRM and LINQPad – An excellent way to test you LINQ CRM queries

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

roject 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 ( 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.

2 thoughts on “CRM 2011 – CRM and LINQPad – An excellent way to test you LINQ CRM queries

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.