Issues Doing a String Comparison in LINQ

by

Try:

var zipLinqQuery =
    from z in db.ZIPMASTERs
    where z.CORP == 12
    && z.ZIPBEG.CompareTo("85546 ") <= 0
    && z.ZIPEND.CompareTo("85546 ") >= 0
    select z;

I don’t know that String.CompareTo works in LINQ to SQL, but it’s the first thing to try.

(Normally you should use a StringComparer to specify the right type of comparison, but I suspect in this case CompareTo is the better option.)

More Related Contents:

  1. Use linq to generate direct update without select
  2. Join and Include in Entity Framework
  3. How to write this nested foreach loop query in LINQ?
  4. How to use LINQ to select object with minimum or maximum property value
  5. What is the syntax for an inner join in LINQ to SQL?
  6. Linq: GroupBy, Sum and Count
  7. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  8. linq case statement
  9. LINQ Aggregate algorithm explained
  10. Equivalent of SQL ISNULL in LINQ?
  11. Distinct in Linq based on only one field of the table
  12. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  13. Extension methods syntax vs query syntax
  14. Conversion from List to array T[]
  15. Executing query with parameters
  16. How do I create an expression tree calling IEnumerable.Any(…)?
  17. SqlConnection.Close() inside using statement
  18. What is the performance of the Last() extension method for List?
  19. Should I use two “where” clauses or “&&” in my LINQ query?
  20. Max or Default?
  21. Performance of Find() vs. FirstOrDefault() [duplicate]
  22. How do I do a left outer join with Dynamic Linq?
  23. LINQ performance FAQ
  24. Last and LastOrDefault not supported
  25. Check if a SQL table exists
  26. A dictionary where value is an anonymous type in C#
  27. How to convert DataTable to class Object?
  28. How do I compose Linq Expressions? ie Func
  29. Generating sql code programmatically
  30. Do we have transactions in MS-Access?

Leave a Comment