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

CRM 2011 – CRM Development Standards

I was searching for some CRM Development standards today and I was surprised that I couldn’t really find any.

Whilst searching the internet I did find this excellent article from Darren Liu about what should be in a CRM development standards document.

I think this is an area where Microsoft could improve and create some guidelines for CRM Development.  You can read the full article here

In our standards document, we have the following sections:

  • Configuration Standards
    • Entity
    • Form
    • Attribute
    • Relationship
  • Customization Coding Standards
    • Naming Conventions
    • Comments
    • Client Side Coding
      • JavaScript
      • jQuery
      • HTML
      • CSS
    • Server Side Coding
      • C#
      • ASP.Net
      • MVC
  • Database Standards
    • Table
    • Store Procedure
    • Function