int to string in Entity Framework

by

Sadly EF does not know how to convert .ToString(). You must use the embedded function SqlFunctions.StringConvert: http://msdn.microsoft.com/en-us/library/dd466292.aspx
Also there is no overload for int so you must typecast to double 🙁

var vendors = 
   from v in Vendors  
   select new
   {             
       Code = SqlFunctions.StringConvert((double)v.VendorId)
   };

More Related Contents:

  1. ORM Entities vs. Domain Entities under Entity Framework 6.0
  2. No executable found matching command “dotnet-ef”
  3. How to ensure proxies are created when using the repository pattern with entity framework?
  4. Entity Framework validation with partial updates
  5. Solution for “Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details.”
  6. NOT using repository pattern, use the ORM as is (EF)
  7. How do you update an edmx file with database changes?
  8. Cascading deletes with Entity Framework – Related entities deleted by EF
  9. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  10. EF Query With Conditional Include
  11. Entity Framework CTP 4 – Code First Custom Database Initializer
  12. How do I singularize my tables in EF Code First?
  13. Set decimal(16, 3) for a column in Code First Approach in EF4.3 [duplicate]
  14. How to create index in Entity Framework 6.2 with code first
  15. Upgrade EF 4 EDMX to EF 6
  16. Efficient way to do bulk insert/update with Entity Framework
  17. Entity Framework and calling context.dispose()
  18. Stuffing an anonymous type in ViewBag causing model binder issues
  19. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  20. Error 6002: The table/view does not have a primary key defined
  21. What would cause the Entity Framework to save an unloaded (but lazy loadable) reference over existing data?
  22. How do I remove underscore of foreign key fields in code first by convention
  23. Best way to incrementally seed data in Entity Framework 4.3
  24. Entity Framework Validation confusion – maximum string length of ‘128’
  25. Logging every data change with Entity Framework
  26. Number of members in conceptual type does not match with number of members on object side type
  27. Delete an object and all of its related entities in Entity Framework
  28. LINQ To Entities + Include + Anonymous type issue
  29. Entity Framework Core 2.0 – Run migrations step by step
  30. EF4 LINQ Ordering Parent and all child collections with Eager Loading (.Include())

Leave a Comment