With Linq search the words that start from H to L

Question

In my LinQ query I have to search words that start from H to L. This is my code:

var Artists = context.GetTable<Artist>();
var leftOuterJoinQuery =
            from arti in Artists
            where arti.Name.StartsWith("H")//to L

var Artists contains table with all artists from my Database.

Someone knows how resolve this?

@Magnus i did some search and i see linq to entities does not support regex. so i deleted the answer. — M.kazem Akhgary, Nov 15 '15 at 14:56
maybe duplicate of http://stackoverflow.com/questions/7216883/linq-query-find-strings-based-upon-first-letter-b-w-two-ranges — Simon Mourier, Nov 15 '15 at 16:48

score 1 · Answer 1 · answered Nov 15 '15 at 14:29

1

you could have a list of letters and then filter on that - e.g:

var letters = new[] {"H","I", "J", "K", "L"};
var Artists = context.GetTable<Artist>().Where (a => letters.Any (l => a.Name.StartsWith(l)));

answered Nov 15 '15 at 14:29

NDJ

5,189
1
18
27

score 1 · Accepted Answer · answered Nov 15 '15 at 15:02

In SQL you can use relational operators for this (>, <, etc.), but C# doesn't accept stringA > stringB. Fortunately, EF translates String.CompareTo into relational operators, so you can do:

where arti.Name.CompareTo("H") >= 0 && c.Name.CompareTo("M") < 0)

This will be translated into

WHERE ([Extent1].[Name] >= 'H') AND ([Extent1].[Name] < 'M')

Note that it depends on the database collation of the Name column whether or not case sensitivity is accounted for.

very nice. i think the fastest way. – M.kazem Akhgary Nov 15 '15 at 15:08 — M.kazem Akhgary, Nov 15 '15 at 15:08

With Linq search the words that start from H to L

2 Answers2