How select just numeric values in LINQ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ronald S. Cook - 05 Mar 2008 21:20 GMT

We have a table "Animal" that contains the column "AnimalNumber" with values
like these:

100001
100002
100003
1XAB
10E43ABC
11RU5V

Having letters in the value was done in the past. These days, it's just a
the numeric value.

How can I write a LINQ statement to select only the numeric values? E.g.:

100001
100002
100003

Thanks fror any help,
Ron

Reply to this Message

Jon Skeet [C# MVP] - 05 Mar 2008 21:34 GMT

> We have a table "Animal" that contains the column "AnimalNumber" with values
> like these:
[quoted text clipped - 14 lines]
> 100002
> 100003

Hmm... that sounds tricky, to be honest. Can you not either remove the
data from the server, or fetch the redundant data and then prune it out
on the client?

Signature

Jon Skeet - <skeet@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
World class .NET training in the UK: http://iterativetraining.co.uk

Reply to this Message

parez - 05 Mar 2008 22:09 GMT

I havent used linq but

you could try.

from number in numbers
where IsNumber(number)

write your IsNumber or use double.TryParse

> We have a table "Animal" that contains the column "AnimalNumber" with values
> like these:
[quoted text clipped - 17 lines]
> Thanks fror any help,
> Ron

Reply to this Message

Rate this thread:

How select just numeric values in LINQ?

Free Magazines