System.InvalidCastException: Unable to cast object of type 'System.Guid' to type 'Microsoft.Xrm.Sdk.EntityReference'.

(0) Share

Report

Posted on by Jf Marwen

QueryExpression query = new QueryExpression();
query.EntityName = "product";
query.ColumnSet.AllColumns = true;
query.Criteria = new FilterExpression();
query.Criteria.FilterOperator = LogicalOperator.And;
query.Criteria.Conditions.Add
(
new ConditionExpression("new_idproduct", ConditionOperator.Equal, document.Element("prestashop").Element("order").Element("associations").Element("order_rows").Elements().ElementAt(f).Element("product_id").Value)
);
EntityCollection entities = service.RetrieveMultiple(query);
if (entities.Entities.Count > 0) {
if (entitiespr[0].GetAttributeValue<EntityReference>("productid").Id.Equals(entities[0].Id))
{
f++;
}
}

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ben Bartle 5 on at

Like (1)

Report
Copy link

Link copied!
Hello,

When querying data within Dynamics, the primary field is always type Guid, rather than EntityReference. EntityReference is used for foreign keys, where you need to specify the entity logical name as well.

If you change:

if (entitiespr[0].GetAttributeValue<EntityReference>("productid").Id.Equals(entities[0].Id))

to:

if (entitiespr[0].GetAttributeValue<Guid>("productid").Equals(entities[0].Id))

It should work.

Thanks,

Ben

Was this reply helpful? Yes No
Jf Marwen 75 on at

Like (0)

Report
Copy link

Link copied!

it did'nt work

Was this reply helpful? Yes No
Kokulan 18,054 on at

Like (0)

Report
Copy link

Link copied!

Hi

Could you please make sure this is GUID not entity reference?

document.Element("prestashop").Element("order").Element("associations").Element("order_rows").Elements().ElementAt(f).Element("product_id").Value - IS this GUID or Entity. reference? This should be GUID

And change your

if (entitiespr[0].GetAttributeValue<EntityReference>("productid").Id.Equals(entities[0].Id))

to

if (entitiespr[0].GetAttributeValue<Guid>("productid").Id.Equals(entities[0].Id))

Was this reply helpful? Yes No
Jf Marwen 75 on at

Like (0)

Report
Copy link

Link copied!

not works

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

The only place you are type casting is "GetAttributeValue<EntityReference>" so the error has to be within this statement. I noticed you have used entitiespr[0] not entities[0], is this a typo? It is possible that the same exception is occurring from some other code. Share your full code if this still doesn't work.

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello, you may try below :

new ConditionExpression("new_idproduct", ConditionOperator.Equal, Guid(document.Element("prestashop").Element("order").Element("associations").Element("order_rows").Elements().ElementAt(f).Element("product_id").Value))

Try it and let me know if it works

Regards,

Jitendra

Was this reply helpful? Yes No