[Solved] Lambda expression Compare operator “>”,”>=” issue


Thanks for all responses The Lambda expression query is correct only.

db.Companies.where(Company => (Compare(Convert(Company.Name), "Test") > 0))
db.Companies.where(Company => (Compare(Convert(Company.Name), "Test") >= 0))

I changed the “right arg” value to “Test”. I have one record ‘Name’ with Test. executed the following query.

db.Companies.where(Company => (Compare(Convert(Company.Name), "Test") > 0)) 

and shown the results 105(here Name with ‘Test’ is not shown. – Correct

Then I executed this

db.Companies.where(Company => (Compare(Convert(Company.Name), "Test") >= 0)) 

and shown the results 106(here Name with ‘Test’ is shown) – Correct

solved Lambda expression Compare operator “>”,”>=” issue