Linq int to string

by

With EF v4 you can use SqlFunctions.StringConvert. So your code would end looking like this:

from s in ctx.Services
where SqlFunctions.StringConvert((double)s.Code).StartsWith("1")
select s

EDIT

As Rick mentions in his comment, the reason for casting the int to a double (decimal probably works too) is that the function does not have an overload for int.

More Related Contents:

  1. LINQ to Entities does not recognize the method
  2. How to do SQL Like % in Linq?
  3. Linq to Entities – SQL “IN” clause
  4. Why use LINQ Join on a simple one-many relationship?
  5. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  6. Which method performs better: .Any() vs .Count() > 0?
  7. What is the difference between IQueryable and IEnumerable?
  8. LINQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria
  9. Like Operator in Entity Framework?
  10. LINQ to SQL Left Outer Join
  11. Case insensitive string compare in LINQ-to-SQL
  12. “Or” equivalent in Linq Where() lambda expression
  13. How do I get the MAX row with a GROUP BY in LINQ query?
  14. LINQ Single vs First
  15. C# – code to order by a property using the property name as a string [duplicate]
  16. Why does a Linq Cast operation fail when I have an implicit cast defined?
  17. EF LINQ include multiple and nested entities
  18. .NET LINQ query syntax vs method chain
  19. Ignore namespaces in LINQ to XML
  20. LINQ to Entities does not recognize the method Int32 get_Item(Int32)
  21. Does LINQ work with IEnumerable?
  22. LINQ, can’t join to string
  23. How to use “contains” or “like” in a dynamic linq query?
  24. Why does IQueryable.All() return true on an empty collection?
  25. How to Convert LINQ Comprehension Query Syntax to Method Syntax using Lambda
  26. What can I do to resolve a “Row not found or changed” Exception in LINQ to SQL on a SQL Server Compact Edition Database?
  27. Linq: What is the difference between Select and Where
  28. Linq to Objects: does GroupBy preserve order of elements?
  29. The model backing the ‘ApplicationDbContext’ context has changed since the database was created
  30. How to Convert Row to Column in Linq and SQL

Leave a Comment