How select just numeric values in LINQ?

[Ronald S. Cook]

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

 

[Jon Skeet [C# MVP]]

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

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?

 

[parez]

I havent used linq but

you could try.


from number in numbers
where IsNumber(number)

write your IsNumber or use double.TryParse