Convert List item to decimal

Rich

14y7.8kLINQ

This seems really simple, but I can't figure out what I am missing. I am trying to cast an item from a list to a decimal. The error I am getting is Can not implicitly convert type to decimal. Thanks in advance.

public class specialTeam
{
public decimal Scores {get;set;}

public specialTeam(string awayTeam)
{
Scores = bBall.getStatList().Where(t => t.Teams == awayTeam).Select(s => s.score);
}
}

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
In that case are you sure that the Scstat.score property returns a decimal and not some other numeric type?

If there's only one result then you can use the First() extension method.

P.S.

Did you remember to change the type of the Scores property to decimal[] ?
0
Rich14y ago
Vulpes, ok thanks for the great explanation! That really helped me out.
0
Vulpes14y ago
If you're certain that there's only going to be a single result, then the second one is better because less memory is needed and it's easier to access a scalar value than a value within a collection.

If there may be one or no results, then you can use FirstOrDefault() rather than First().

If there were no results, this would then set Scores to 0m which is the decimal type's default value.
0
Rich14y ago
Sam, that's a good point. I'll definitely make use of that perspective. Thanks!
0
Rich14y ago
Ok, got it. Vulpes, I actually did forget to add the .ToArray() to the end of the statement, but anyhow, both of the statements below work:

public ListScores {get;set;}

Scores = bBall.getStatList().Where(t => t.Teams == awayTeam).Select(s => s.score.score).ToList();

or

public decimal Scores {get;set;}

Scores = bBall.getStatList().Where(t => t.Teams == awayTeam).Select(s => s.score.score).First();

Is there an advantage by one over the other?
0
Sam Hobbs14y ago
Rich, think of it this way. Eventhough you know there is only one item that will be found, the computer must be able to return more than one result. Correct? So you still need to do a conversion. I think Vulpes is more qualified to help with the details and at least I got the point made that the data returned was not what you expected. Also, as I said, the power of LINQ and other things is useful when it does what we need to do but it can also be frustrating when we don't understand what is happening.
0
Rich14y ago
Vulpes, that didn't work either. Got the same error with an added statement saying "an explicit conversion exist (are you missing a cast?)" and I am pretty sure that the query should be returning only one item.
0
Vulpes14y ago
It appears that the query returns more than one score in which case you need to convert the IEnumerable to an array or a list of decimals:

public class specialTeam
{
public decimal[] Scores {get;set;}

public specialTeam(string awayTeam)
{
Scores = bBall.getStatList().Where(t => t.Teams == awayTeam).Select(s => s.score.score).ToArray();
}
}
0
Rich14y ago
Vulpes, okay that was a duh moment right there for me, lol. I failed to include the decimal property. Here is the new line:

public specialTeam(string awayTeam)
{
Scores = bBall.getStatList().Where(t => t.Teams == awayTeam).Select(s => s.score.score);
}

But now the error is Can not implicitly convert IEnumerable to decimal. I am not seeing how to properly cast or convert it.
0
Vulpes14y ago
The error message suggests that s.score is of type Scstat rather than decimal.

If that's the case, does the Scstat class (or struct) have a decimal property or have you defined an explicit conversion between the two types?
0
Rich14y ago
Sam, I left out the type in the original post on accident. Can not implicitly convert type IEnumerable to decimal. I am sure that that an item is being returned, if it is indeed communicating with the List. And the item being returned is a decimal also.
0
Sam Hobbs14y ago
If it were me I would determine what the type is. Do you know what type it is that is to be converted?

That is a problem with powerful tools. Your one line is actually doing multiple things. That is good when it works but it is difficult to diagnose when it does not work.

Are you assuming that the Select method returns an item? Are you sure it does?
0