database retrival value of zero but linqpad is not zero

Question

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.

Vulpes · 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 WhoAMI · Answer

solved already thank you very much.. the problem is that there is an extra space in 0013-047  which resulted in no record.

database retrival value of zero, but linqpad is not zero