What is equivalent to clause between, for comparas

Question

How do I filter a query interval of two string using LINQ or Lambda Expression.

example:

SELECT * FROM dbo.Country WHERE Name BETWEEN "Argentina" AND "Jamaica";

Answer 1

Have you tried:

yourDataContext.Country.Where(c => c.Name >= "Argentina" && c.Name <= "Jamaica");

Answer 2

perpetrators >= and <= are not for strings. they will throw compile time error to you. you can use CompareTo for this as shown below

x.Name.CompareTo(Start) >= 0 && x.Name.CompareTo(End) <= 0