Specified cast is not valid error

(0) Share

Report

Posted on by Community Member

Hello guys,
I have a piece of code which looks something like this :

QueryExpression queryname = new QueryExpression(entityname);
queryname.ColumnSet = new ColumnSet(fieldnames);
queryname.Criteria.AddCondition(new ConditionExpression(condition));
EntityCollection collectionName = _service.RetrieveMultiple(queryname);
if (collectionName.Entities.Count > 0)
{
tracingService.Trace("into method - 1, EC Count :" + collectionName.Entities.Count);
foreach (Entity entityname in productThresoldRecords.Entities)
//businesslogic..

I am getting an error in the foreach line - "Specified cast is not valid.".(Confirmed by the error log - the above trace is displayed . But the first trace in the foreach method is not..)

I can't figure out why I would get that error.Could it be because of the count of entity collection? Usually it is 1..

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Hi,

Your result from the RetrieveMultiple is saved in a parameter called collectionName, not productThresholdRecords.

Try replace that and see if it works.

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Aric,

Thanks for the response. Sorry I forgot to replace the sample name for that. It is the parameter name from Entity Collection. So it looks like this only :

QueryExpression queryname = new QueryExpression(entityname);

queryname.ColumnSet = new ColumnSet(fieldnames);

queryname.Criteria.AddCondition(new ConditionExpression(condition));

EntityCollection collectionName = _service.RetrieveMultiple(queryname);

if (collectionName.Entities.Count > 0)

{

tracingService.Trace("into method - 1, EC Count :" + collectionName.Entities.Count);

foreach (Entity entityname in collectionName.Entities)

//businesslogic..

Still getting the error.

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Not sure if you are replacing your code for the forum, but you also have entityname appear once in the name of the Query Expression and once in the foreach statement.

Basically the following should work:

QueryExpression query = new QueryExpression(entityName);

query.ColumnSet = new ColumnSet(fieldNames);

query.Criteria.AddCondition(new ConditionExpression(condition));

EntityCollection results = _service.RetrieveMultiple(queryname);

if (results.Entities.Count > 0)

{

tracingService.Trace("into method - 1, EC Count :" + results.Entities.Count);

foreach (Entity current in results.Entities)

{

}

}

I would basically check syntax, since this is pretty straight forward.

Are you sure the error is in the foreach statement?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Aric,

Apologies for the confusion. Yes - my code looks like how you have mentioned. Yes, the error is in the foreach statement. I confirmed it by inserting a trace message before and after the foreach. Could it be because of the data am retrieving?

My condition expression checks if a lookup field is equal to a guid. I am also retrieving some lookup fields. However, the queryexpression is retrieving something. Because in the trace, the count is 1 - expected behaviour.

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

So, do you have entityname appear twice (once in the query expression and once in the for each statement)?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No just once . My code looks like how you mentioned :

QueryExpression query = new QueryExpression(entityName);

query.ColumnSet = new ColumnSet(fieldNames);

query.Criteria.AddCondition(new ConditionExpression(condition));

EntityCollection results = _service.RetrieveMultiple(query);

if (results.Entities.Count > 0)

{

tracingService.Trace("into method - 1, EC Count :" + results.Entities.Count);

foreach (Entity current in results.Entities)

{

}

}

Was this reply helpful? Yes No
Verified answer

ashlega 34,477 on at

Like (0)

Report

Hi,

what's the first trace in the foreach? What are you tracing there? I think the cast error is, actually, in that line..

Was this reply helpful? Yes No
Verified answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Can you show what code you have inside the foreach, and do have have any tracing there that is displayed?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Aric and Alex,

You guys were right. The error was due to the trace immediately into the foreach method. I was treating a decimal variable as int. Fixed the issue

Thank you!

Was this reply helpful? Yes No