CODEWITHSUNDEEP
c#linq-to-sql
Rippo
Rippo

Reputation: 22424

linq to sql - how do i rewrite the following

Is there a better way to create the following linq to sql query? I am trying to get all Company Names that start with a number [0-9]...

var suppliers = from s in context.Supplier where 
    SqlMethods.Like(s.CompanyName, "0%") ||
    SqlMethods.Like(s.CompanyName, "1%") ||
    SqlMethods.Like(s.CompanyName, "2%") ||
    SqlMethods.Like(s.CompanyName, "3%") ||
    SqlMethods.Like(s.CompanyName, "4%") ||
    SqlMethods.Like(s.CompanyName, "5%") ||
    SqlMethods.Like(s.CompanyName, "6%") ||
    SqlMethods.Like(s.CompanyName, "7%") ||
    SqlMethods.Like(s.CompanyName, "8%") ||
    SqlMethods.Like(s.CompanyName, "9%")
 select s;

Many Thanks

Upvotes: 1

Views: 132

Answers (1)

Konamiman
Konamiman

Reputation: 50273

What about:

var suppliers = from s in context.Supplier where 
    SqlMethods.Like(s.CompanyName, "[0-9]%")
select s;

Upvotes: 4

Related Questions