No announcements
Found 145825 threads
-
0 VotesLeft Outer join LINQ query with four entities in CRM 2011 and with multiple where clauses
Hi Saga, You can do LEFT OUTER JOINS using the LINQ provider for CRM2011 provided there is just a single level - but the OP was trying to do more than one ...Answered | 6 Replies | 12081 Views | Created by Vinu Kumaran - Friday, October 19, 2012 5:11 PM | Last reply by Scott Durow (MVP) - Tuesday, March 19, 2013 1:52 PM
-
0 Votes
Linq to CRM Left and Inner Join
Linq to CRM does support Left Outer Joins.Proposed | 2 Replies | 1581 Views | Created by marvswork - Friday, November 15, 2013 5:10 PM | Last reply by Daryl LaBar - Tuesday, June 24, 2014 10:59 PM -
0 Votes
INNER JOIN in reports
Change Inner Join to Left Join.Answered | 1 Replies | 6697 Views | Created by brosimba - Tuesday, August 4, 2009 8:43 AM | Last reply by Andrii Butenko - Tuesday, August 4, 2009 8:44 AM -
0 Votes
How is Linq used in CRM 2011
The Advanced Developer Extensions LINQ query provider offers the following capabilities: Supports ...Answered | 2 Replies | 5005 Views | Created by Sandra.CRM - Friday, September 14, 2012 5:50 PM | Last reply by Imran I Abbasi - Friday, September 14, 2012 9:49 PM -
0 Votes
Inner Join Challenge
Can anyone point out what am doing wrong with this inner join command.Answered | 3 Replies | 1770 Views | Created by kremilk - Monday, May 13, 2019 5:11 AM | Last reply by Guido Franzke - Tuesday, May 21, 2019 7:26 AM -
0 Votes
CRM 2011 LINQ and Min
Hi, This is a limitation of LINQ - you can'y use aggregate functions like MIN.Answered | 3 Replies | 2332 Views | Created by SPCRM2011 - Sunday, July 7, 2013 4:22 AM | Last reply by SPCRM2011 - Thursday, July 11, 2013 12:21 PM -
0 Votes
Linq To CRM Query Alternatives
I haven't used CRM2011's LINQ provider yet, but from what I know of the CRM4.0 equivalent and reading through the CRM2011 SDK, your join should look more ...Answered | 2 Replies | 8097 Views | Created by jcaruso_fp - Thursday, February 24, 2011 4:13 PM | Last reply by pogo69 - Thursday, February 24, 2011 10:39 PM -
0 Votes
Why Basic Linq Join is not supported in My CRM 2011 "The method 'Join' is not supported"
Hi, I am positive this is nothing to do with the server structure, in fact my environment is the similar to you. my dev box is 32 bit and crm server is 64 bit.Answered | 5 Replies | 5039 Views | Created by Bhautik Desai-XRM Tech - Wednesday, November 16, 2011 12:37 PM | Last reply by Bhautik Desai-XRM Tech - Thursday, November 17, 2011 10:43 AM -
0 Votes
LINQ to CRM Sample Left and Inner join
from a in AccountSet join c in ContactSet on a.PrimaryContactId.Id equals c.ContactId into gr from c_joined in gr.DefaultIfEmpty() select ...Proposed | 1 Replies | 1807 Views | Created by marvinbaby - Friday, November 15, 2013 11:22 AM | Last reply by Scott Durow (MVP) - Friday, November 15, 2013 12:22 PM -
5 Votes
Displaying CRM 2011 LINQ in GridView
How do you query values that are empty in LINQ.Answered | 6 Replies | 5306 Views | Created by CrazyeD1583 - Monday, August 15, 2011 9:34 PM | Last reply by CrazyeD1583 - Tuesday, August 16, 2011 8:50 PM -
1 Votes
How to convert inner join to QueryExpression?
sql: select * from lead inner join listmember on listmember.entityid=lead.leadid where ...Answered | 4 Replies | 5230 Views | Created by nixjojo - Wednesday, July 20, 2011 9:53 AM | Last reply by DhavalPanchal247 - Tuesday, October 16, 2012 12:41 PM -
1 Votes
Exception in a CRM LINQ query with joins.
There are some limitations in CRM LINQ, as explained here.Answered | 6 Replies | 3357 Views | Created by RDevelopment - Wednesday, November 28, 2012 4:51 PM | Last reply by RDevelopment - Friday, November 30, 2012 2:50 PM -
0 Votes
WQL Script for SCCM using the INNER JOIN function
http://www.google.com/search?Answered | 3 Replies | 2648 Views | Created by Mr Me 2 - Thursday, October 1, 2015 7:33 PM | Last reply by Bill_Stewart - Thursday, October 1, 2015 8:45 PM -
0 Votes
CRM 2011: Linq queries tutorials from A to Z
hi Mostafa , As you understand linq is a NET Language-Integrated Query its same if you are using in a .NET code WEB project or CRM plugin ...Answered | 2 Replies | 3759 Views | Created by Mostafa Moatassem - Monday, November 14, 2011 3:24 PM | Last reply by D kay - Wednesday, November 16, 2011 12:10 PM -
0 Votes
Linq: Join & OrderBy -> Invalid Argument
Hi, Pat is right - the problem is using the o.Id in your linq.Answered | 3 Replies | 3186 Views | Created by hfaun - Thursday, December 13, 2012 8:27 PM | Last reply by hfaun - Friday, December 14, 2012 6:31 PM -
0 Votes
CRM 2011 - LINQ
Shonak, In that case, make sure that your LINQ query is returning the type that your List variable is expecting.Answered | 9 Replies | 9528 Views | Created by shonak - Tuesday, March 1, 2011 12:38 PM | Last reply by faithfulld - Tuesday, August 19, 2014 5:25 AM -
0 Votes
CRM LINQ generates wrong SQL code, can anyone explain?
It helps to think about CRM LINQ queries in terms of the underlying provider and what it translates queries into - Query Expression.Answered | 3 Replies | 4248 Views | Created by PDMarsden - Sunday, September 11, 2011 5:22 PM | Last reply by pogo69 - Monday, September 12, 2011 6:09 AM -
2 Votes
Microsoft CRM 5 - LINQ provider "constraints"
Hi Jeremias, I've added an example on how to do this at: ...Answered | 6 Replies | 5280 Views | Created by Jeremias K - Tuesday, January 3, 2012 9:22 AM | Last reply by Jeremias K - Monday, January 9, 2012 7:57 AM -
0 Votes
Can LINQ be used with CRM Plug-ins
My problem is integrating LINQ with my plug-ins because it makes querying very simple.Answered | 10 Replies | 6819 Views | Created by sebastian.mayer.67 - Friday, September 3, 2010 12:31 PM | Last reply by sebastian.mayer.67 - Tuesday, September 7, 2010 7:44 AM -
2 Votes
Updating a subset of fields using the CRM LINQ provider
When you use select new - it is called a 'projection' and the CRM LINQ provider interprets this as creating a QueryExpression that only contains the fields that you reference.Answered | 2 Replies | 3683 Views | Created by Abhijeet P - Saturday, September 22, 2012 8:11 PM | Last reply by Abhijeet P - Tuesday, September 25, 2012 2:56 PM - Items 1 to 20 of 145825 Next ›
No announcements
