int to string in Entity Framework

Question

How do you convert an int to a string in Link to EF?

The clr cant imagine casting an int to a string and Entity framework cant figure out what SQL snippet to translate .ToString() into.

So how do you write a linq statement that returns a string instead of an int?

EF >= 6.1 supports ToString: blogs.msdn.com/b/adonet/archive/2014/03/17/… — Stephan Bauer
– Stephan Bauer, Commented Aug 21, 2014 at 7:03

drawnonward · Accepted Answer · 2017-02-18 01:06:08Z

54

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)
   };

edited Feb 18, 2017 at 1:06

drawnonward

53.7k16 gold badges109 silver badges112 bronze badges

answered Dec 27, 2010 at 18:39

Karel Kral

5,5146 gold badges44 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Rabbi Over a year ago

B"H Wow, that sucks. What I do now is always project to an intermidiate (usualy anonymous) type in the select and then project into my real objects in the next step after a AsEnumerable() or something like that

iProgrammer Over a year ago

i have to pass this converted value in where clause

ChaseMedallion Over a year ago

It's also often important to call Trim() on the output to avoid having your string come out padded.

Anderson Over a year ago

And how does one use this in EntityDataSource?

Collectives™ on Stack Overflow

int to string in Entity Framework

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related