How to use linq contains like %[0-9]%

Question

I am trying to write a Linq query that uses like %[0-9]% from sql-server.

This is my start:

string[] partNumbers = new string[] 
{ 
    "India", "US","UK", "Australia","Germany", "1", "7", "9" , "50", "A1"
};

var result = partNumbers.OrderBy(x => x).ToList();

How to write a linq query in c# which contains like "%[0-9]%"

This is the expected output:

1
7
9
50
A1

First write a method that performs the operation on a single value in your sequence. Then it should be a very simple matter of looking through the given linq operators to see how to apply that operation on the entire sequence to get all of the values where that given condition is met. — Servy, Dec 10 '13 at 17:41

score 2 · Accepted Answer · answered Dec 10 '13 at 17:53

2

You could use Regular expression

var result = partNumbers.Where(x => Regex.Match(x, "\\d+").Success);

answered Dec 10 '13 at 17:53

Magnus

45,362
8
80
118

Hossein Narimani Rad · Answer 2 · 2013-12-10T17:47:16.240

1

This may helps:

string[] partNumbers = new string[] 
{ 
    "India", "US","UK", "Australia","Germany", "1", "7", "9" , "50", "A1"
};

char[] numbers = {'0','1','2','3','4','5','6','7','8','9'};

var result = partNumbers.Where(i=>i.Intersect(numbers).Any()).ToList();

Result:

EDIT: if you are looking for LIKE operator in SQL you can use the SqlMethods.Like method.

edited Dec 10 '13 at 17:47

answered Dec 10 '13 at 17:41

Hossein Narimani Rad

31,361
18
86
116

don't we have anything like sql like operator – user3080252 Dec 10 '13 at 17:45
sqlmethods is not working, I had included the following namespace even System.Data.Linq.SqlClient – user3080252 Dec 10 '13 at 17:51
can you show your code? – Hossein Narimani Rad Dec 10 '13 at 17:53
`SqlMethods.Like` only works for Linq2Sql queries, not linq2object. – Magnus Dec 10 '13 at 17:55

How to use linq contains like %[0-9]%

2 Answers2