Loading

database retrival value of zero, but linqpad is not zero

TAN WhoAMI

this is ok, see the image below at this link:

http://imagedrop.co/img-52c4d454f3427

The Testtime of 19112 is being retrieved properly.

But when I change to another SystemType = 0013-047, the Testtime is zero. But LinqPad does display the Testtime value of 14519.

see image at

http://imagedrop.co/img-52c4d6de456b7

I really cannot see why, would appreciate any useful help.

2 Replies

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

Vulpes12y ago
Accepted answer
See if it makes any difference if you change the query from:

var TimeTest = query.Select(row => row.Field("TIME_TEST">)).Sum();

to:

var TimeTest = query.Select(row => row.Field("TIME_TEST">).Where(tt => tt != null && tt > 0)).Sum();
TAN WhoAMI12y ago
solved already, thank you very much.. the problem is that there is an extra space in "0013-047 " which resulted in no record.