Search Wiki:
Project 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.

Connect to Microsoft Dynamics CRM 2011 – Online or OnPremise - browse entity schema, write and execute LINQ-to-CRM queries.

Features
1) Support of all Microsoft Dynamics CRM 2011 deployment types: Online, OnPremise and SPLA
2) Entity schema browsing – navigating through entity sets, entity attributes and relationships
3) Writing and executing LINQ queries against entity sets
4) Examining QueryExpression used for actual data retrieval

Installation instructions
1) Make sure you have .NET Framework 4.0 and Windows Identity Foundation installed
2) Download and install LINQPad for .NET Framework 4.0 from http://www.linqpad.net
3) Download CrmLINQPadPlugin.lpx from ‘Downloads’ section of this page
4) Run LINQPad and register the plugin – go to "Add Connection\View More Drivers\Browse" and select CrmLINQPadPlugin.lpx
5) To create a CRM connection, click "Add Connection" and select "MS CRM 2011" in "Use a typed data context from your own assembly" section

Screenshots

screenshot1.png

screenshot2.png

screenshot3.png
Last edited Jan 7 2011 at 11:40 PM  by alexigrushkin, version 10
Comments
theiwaz wrote  Jan 7 2011 at 3:44 PM  
Nice work !! Go to http://linqpadsp2010driver.codeplex.com to download a LinqPad Data Context Driver for SharePoint 2010

jsun027 wrote  May 18 2011 at 6:24 AM  
Can you throw this on codeplex please? Issues will get resolved quicker when there is a community behind it.

Great work! :)

Gooch wrote  Jun 2 2011 at 5:31 PM  
Can you share the source code for this? Thanks! Great Driver!

bcbeatty wrote  Aug 23 2011 at 5:04 PM  
I'm getting the following error when I try to connect to the online dynamics crm (https://dev.crm.dynamics.com)

"Exiting program with exception: The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the <serviceDebug> configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation and inspect the server trace logs."

Any ideas?
Thanks

jefferyp2100 wrote  Dec 2 2011 at 9:09 PM  
Works once, then never again. Could not load file or assembly 'C:\users...\Temp\LINQPad\CrmLINQPadPlugin.dll' or one of it's dependencies.

Source code would be great!

withersdavid wrote  Oct 10 2012 at 10:48 PM  
"there is an error in xml document (5,5)" crm online office365

vissu wrote  Feb 28 2013 at 2:27 PM  
Check credentials andError : make sure Windows Identity Fountation is Installed Details: CrmSvcUtil : CRM Service Utility [Version 5.0.9688.42] c2010 Microsoft Coporation. How can I work on it.??

vissu wrote  Feb 28 2013 at 2:29 PM  
Windows Identity Foundation is enabled in my system. but still now working I checked, given credentials are correct.

Thanks in Advance for solution.

MarcoMedrano wrote  Apr 24 2013 at 9:52 PM  
I am using the last version of LinqPad and CRM 2011 onlie, does not work fails trying to generate the Context.
Please share the source code.

Selfi wrote  Jun 3 2013 at 9:57 AM  
Don't forget your organization name in the url:

http://yourserveraddress.com/yourorgname

LaughingJohn wrote  Jun 24 2013 at 4:17 PM  
I've raised a connect item to ask for this to be supported or open sourced. Please vote if you agree: https://connect.microsoft.com/dynamicssuggestions/feedback/details/790571/officially-support-or-open-source-the-crm-2011-linqpad-plugin

kocha wrote  Oct 24 2013 at 1:09 AM  
please release crm 2013 version or source code...

kocha wrote  Oct 24 2013 at 7:20 AM  
http://archive.msdn.microsoft.com/crm2013linqpad

Updating...
Page view tracker