Simple Join Query is not working

(0) Share

Report

Posted on by Khaled Rimawi

145

Hi ,

i have custom "class" entity which contains "course" lookup. in my code i have a list of course GUIDs and i want to perform a join query between this list and classes records , but it's not working, this exception occurs : {"Invalid 'join' condition. An entity member is invoking an invalid property or method."}.

here is my code :

using (var orgContext = crmConnection.GetContext()){
    var w = (from c in orgContext.CreateQuery<New_class>()
             join courseId in courseIds on c.new_courseid.Id equals courseId
             select c).ToList();
}

courseIds is the list of course GUIDs

Categories:

Customization / Solutions / SDK and API

All responses (2)

Answers (0)

Khaled Rimawi 145 on at

Like (0)

Report

RE: Simple Join Query is not working

@Mahadeo , i think you mess understood what i want, i don't want to join classes records with courses records, i want to join them with list of static GUIDs that i have.
Suggested answer

Mahadeo Matre 17,021 on at

Like (0)

Report

RE: Simple Join Query is not working

Hi..

your query should be

using (var orgContext = crmConnection.GetContext()){

var w = (from c in orgContext.CreateQuery<New_class>()

join course in orgContext.CreateQuery<New_course>() on c["new_courseid] equals course [new_courseid]

"]

select c).ToList();

}

you need to use entity names / table of course in query