Check if a String value contains any number by using Lambda Expression

Question

I have a SQL query that retrieves only the names not containing any number:

...
WHERE Name NOT LIKE '%[0-9]%'

On the other hand, when trying to use this query in Lambda Expression with different combinations as shown below, none of them is working does not work:

.Where(m => !m.EmployeeName.Contains("%[0-9]%")

or

 .Where(m => !m.EmployeeName.Contains(".*[0-9].*")

How can I use NOT LIKE method in Lambda Expression?

Update: My lambda expression is shown below:

return Json(db.TEmployees
    .Where(m => m.Status == Enums.Status.Active)
    .AsEnumerable()
    .Where(m => !Regex.IsMatch(m.EmployeeName, ".*[0-9].*"))
    .Select(m => new { ID = m.EmployeeID, EmployeeName = m.EmployeeName }), 
        JsonRequestBehavior.AllowGet);

Answer 1

As far I know you can't apply regular expression in Linq to Entities. What I recommend to do is if you have other conditions call Where method using them first, and then call AsEnumerable to work with Linq to Object which allows you use regular expressions, so you can apply the condition you need:

var query= context.YourDbSet.Where(...)
                            .AsEnumerable()
                            .Where(m => !Regex.IsMatch(m.EmployeeName, @"\d"));

Or you can also do the following:

var query= context.YourDbSet.Where(...)
                            .AsEnumerable()
                            .Where(e=>e.!EmployeeName.Any(char.IsDigit));

Update:

A third solution could be using DbSet.SqlQuery method to execute your raw SQL query:

var query= context.YourDbSet.SqlQuery("SELECT * FROM Table WHERE Name NOT LIKE '%[0-9]%'");

Translating that to your scenario would be:

                     // This column names must match with 
                     //  the property names in your entity, otherwise use *
return Json(db.TEmployees.SqlQuery("SELECT EmployeeID,EmployeeName 
                                    FROM Employees 
                                    WHERE Status=1 AND Name NOT LIKE '%[0-9]%'"), 
           JsonRequestBehavior.AllowGet);// Change the value in the first condition for the real int value that represents active employees

Answer 2

You can use Regex.IsMatch.

yourEnumerable.Where(m => !Regex.IsMatch(m.EmployeeName, @"\d"));