MySql Linq to SQL conver int to string

Question

Hello I have a MySQL and LINQ to SQL task to convert Int value from DB to String, toString() is not supported by MySql, and I am getting error about it.

var data = (from o in ObjectContext.MyTable.Where(d => d.a == a)
                              select new MyObject
                              {
                                  Id = o.Id,
                                  StringProperty = o.intColumn.ToString()
                              });

SqlFunction class is not suported for MySql.

ToString() (capital T)

Lev
– Lev

2014-02-27 10:21:25 +00:00
Commented Feb 27, 2014 at 10:21 — Lev
– Lev, Commented Feb 27, 2014 at 10:21

Milen · Accepted Answer · 2022-10-08 15:04:45Z

1

You can try to convert the results to Enumerable and then query on it:

var data = (from o in ObjectContext.MyTable.Where(d => d.a == a)
                              select new MyObject
                              {
                                  Id = o.Id,
                                  StringProperty = o.intColumn.ToString()
                              }).AsEnumerable();

edited Oct 8, 2022 at 15:04

answered Feb 27, 2014 at 10:23

Milen

8,8977 gold badges47 silver badges59 bronze badges

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

2 Comments

Kjartan Over a year ago

This will work, but all the data in the table will be enumerated (fetched) here, if I'm not mistaken. May be a bad idea if you have lots of data.

Gert Arnold Over a year ago

At least do .AsEnumerable() after the Where.

Kjartan · Accepted Answer · 2014-02-27 10:40:36Z

You could fetch all the data by adding AsEnumerable() to the table, or you could do the fetch first, then the conversion later - if I'm not mistaken, this should produce a slightly lighter SQL call:

var tempData = (from o in ObjectContext.Where(d => d.a == a) select o);

var converted = (from o in tempData.AsEnumerable()
                select new MyObject
                          {
                              Id = o.Id,
                              StringProperty = o.intColumn.ToString()
                          });

Alternatively, write it all in one go by using the first part as a sub query:

var data = from x in 
                  (from o in ObjectContext.Where(d => d.a == a) select o)
                  .AsEnumerable()
           select new MyObject
                           {
                              Id = x.Id,
                              StringProperty = x.intColumn.ToString()
                          });

Wang Jijun · Accepted Answer · 2017-08-09 02:57:17Z

0

int to string in Entity Framework also had supported a great solution you can refer. By this method you can change you source as the following.

var data = (from o in ObjectContext.MyTable.Where(d => d.a == a)
                          select new MyObject
                          {
                              Id = o.Id,
                              StringProperty = SqlFunctions.StringConvert((double)o.intColumn)
                          });

answered Aug 9, 2017 at 2:57

Wang Jijun

3264 silver badges10 bronze badges

Collectives™ on Stack Overflow

MySql Linq to SQL conver int to string

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related