Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Linq error Unable to c...

Linq error Unable to cast object of type 'Microsoft.Xrm.Sdk.Linq.Query`1[EarlyBound.Contact]' to type 'EarlyBound.Contact'

(0) Share

Report

Posted on by Community Member Microsoft Employee

I m querying entity. here is my query,

 Contact c1=
                       (Contact)(from c in ppContext.pp_configurationSet
                        join p in ppContext.ContactSet.DefaultIfEmpty()
                        on c.cav_name equals p.FullName
                        where c.pp_name == "DELBY" &&
                        c.StateCode == pp_configurationState.Active
                        select p);

plz guide hot to convert it Entity "Contact". thanks

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Temmy Wahyu Raharjo 2,914 on at

Like (0)

Report
RE: Linq error Unable to cast object of type 'Microsoft.Xrm.Sdk.Linq.Query`1[EarlyBound.Contact]' to type 'EarlyBound.Contact'

Hi hussmom,
You need to understand ppContext.pp_configurationSet will return EntityCollection data. So for that code, you need to do something like this:

Contact c1= (from c in ppContext.pp_configurationSet join p in ppContext.ContactSet.DefaultIfEmpty() on c.cav_name equals p.FullName where c.pp_name == "DELBY" && c.StateCode == pp_configurationState.Active select p).FirstOrDefault();

Hope this help!