HowTo.md

Install the driver

1. Open LinqPad and click "Add connection".
   
2. Click "View more drivers".
   
3. Scroll down to find Dynamics CRM driver, then click "Download & Enable Driver".
   
4. Once download completed, you see the driver in your list.
   

Connect and create the context

1. Select the installed driver and click "Next".
   
2. In the pop-up windows, you have several options.
   
3. If you already have an application registered to Azure AD, then uncheck the "Register to Azure AD automatically... " then you can enter your own ClientId.
   
4. If you want to use different version of API, check "Advanced Settings" and enter the API version. At the moment, v9 endpoint didn't work well, so enter "8.2" instead.
   
5. Click "Login to CRM" then signin dialog appears. Specify your credential and login.
   
6. Once login completed, wait until progress bar complets. It may ask you another credential to register an application to Azure AD if you let the driver register it on your behalf, then enter credential which has privilege to register an application to Azure AD.
7. When it download metadata and create context, you see the window below. Click Exit and wait until entites are loaded. It may take several seconds to minutes.
   
8. When everything done, you are ready to run LINQ query against your Dynamics instance.


Run LINQ query and see results.

1. From Connection dropdown, select a connection you want to execute the query by either press F5 or click green arrow.

 1. Enter LINQ query and execute. The results are shown in "Results pane"

Run C# statement.

1. Switch language from "C# Expression" to "C# statement".
   
2. Enter any statement you want to run and execute it.
   
3. Select "SQL" tab to see URI to run the query.
   

Update the context.

1. When you need to update/refresh the context, then right click the connection and select "Refresh".
   
2. If you want to re-enter password or change setting, select Properties instead.
   
3. Select any option as you want.
   

Ken