How do I filter a query interval of two string using LINQ or Lambda Expression.
SELECT * FROM dbo.Country WHERE Name BETWEEN "Argentina" AND "Jamaica";
Have you tried:
yourDataContext.Country.Where(c => c.Name >= "Argentina" && c.Name <= "Jamaica");
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