Tutorial :How do I convince Linq to Sql to generate Sql to compare strings with greater than or less than? [duplicate]

Question:

This question already has an answer here:

• Issues Doing a String Comparison in LINQ 1 answer

Let's say I have a MS-SQL 2005 table named "People" with the following rows:

|FirstName|LastName|  |JD       |Conley  |  |Joe      |Schmo   |  |Mary     |Jane    |  

I want to execute a SQL statement like:

select * from People where FirstName > 'JD'  

The problem I'm having is I can't think of a way to get LINQ to SQL to generate this SQL statement. Obviously I can't use ">" and "<" operators on strings in C#.

Solution:1

You want String.CompareTo here

var query = from p in db.People              where p.FirstName.CompareTo("JD") > 0              select p;  

Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com

• Twitter
• Facebook
• Google
• Tumblr
• Pinterest