Ben Walker
  • Blog
  • Blog

Connecting LINQPad to Dynamics CRM using the Dynamics CRM LINQPad Driver

20/4/2017

3 Comments

 
LINQPad is an invaluable tool for any .Net developer, and it will greatly enhance your ability to write and support applications using Dynamics CRM. There are two ways with which to connect to an instance of Microsoft Dynamics CRM using LINQPad. This two-part article will describe these two different methods and examine the reasons why you might choose one over the other.
Connecting to CRM using the Dynamics CRM LINQPad Driver
NB The CRM LINQPad driver works with CRM 2011 – 2017. It seems as if the connector does not work with Dynamics 365. I have not been able to confirm this myself – if this is the case, you can try the LINQPad 4/5 Driver for Dynamics CRM Web API or create a manual connection as described here.

The LINQPad Driver for Dynamics CRM has been developed by Microsoft’s Premier Field Engineering (PFE) team. It allows you to create a number of predefined connections to CRM, which you can then use in your LINQPad CRM scripts.
The LINQPad driver for Dynamics CRM can be downloaded here, and the (very easy) installation instructions are to be found here.
LINQPad connection definitions persists between sessions, so, providing your credentials do not change, you can use your predefined connections in all subsequent queries.
You can write and run code which utilises the Organisation Service of the connection you are using:
Picture
You can easily switch between organisations in your script by simply choosing from the list of available connections:
Picture
To help prevent you from accidentally running code against production which should not be run in production, you can mark individual connections as Production and they will display like this:
Picture
Not only can you write and execute code using the CRM Driver for LINQPad, you can also explore the entities within the organisation you are connected to:
Picture
and explore the composition of entities in detail:
Picture
The connector creates a set of Early Bound classes when it is initially set-up and it is therefore possible to write LINQ queries directly against these entities:
Picture
and the editor gives you full Intellisense on the entity:
Picture
In the second article in this series I will show you how you can manually create a connection to CRM in LINQPad and why you might wish to do this.
3 Comments
inventory management development software link
22/7/2022 09:23:41 pm

LINQPad is an invaluable tool for any .Net developer, and it will greatly enhance your ability to write and support applications using Dynamics CRM. Great article thank you so much!

Reply
customer relationship management application link
15/8/2022 05:14:50 pm

Thank you so much for sharing all this wonderful info with us! It is so appreciated!

Reply
Fan Installation Texas link
3/12/2022 02:24:31 pm

Thanks great blog posst

Reply



Leave a Reply.

    Archives

    July 2021
    June 2021
    May 2020
    March 2020
    December 2019
    October 2019
    June 2018
    February 2018
    October 2017
    September 2017
    August 2017
    May 2017
    April 2017

    Categories

    All
    Dynamics 365
    Dynamics CRM
    FakeXrmEasy
    LINQPad
    Testing

    RSS Feed

    Author

    Some stuff about me!

Proudly powered by Weebly