How to concatenate strings in Entity Framework Query

Question

I want to perform the following query in Entity framework 6. Although i tried converting integer field to strings but it did not worked out.

using (var context = new HospitalEntities())
            {
                var ibed = from u in context.Employee
                           where u.EmployeeId == employeeId
                               select new
                               {
                                   _empId = u.EmployeeId,
                                   _name =Convert.ToString(u.Code) + u.EmployeeName


                               };

Model Class:

public class Employee
{

    public int EmployeeId { get; set; }
    public int Code { get; set; }
    public string EmployeeName { get; set; }

}

Please help me. Thanks in advance.

Greg · Accepted Answer · 2014-03-06 22:42:14Z

2

In EF 6 you need to use System.Data.Entity.SqlServer.SqlFunctions (NOT System.Data.Objects.SqlClient.SqlFunctions which was used in prior versions)

using (var context = new HospitalEntities())
{
var ibed = from u in context.Employee
where u.EmployeeId == employeeId
select new
{
      _empId = u.EmployeeId,
      _name = System.Data.Entity.SqlServer.SqlFunctions.StringConvert((int?) u.Code) + u.EmployeeName


};

I'm using the long name here for emphasis. In prior projects you'll just replace the includes. Again, this is for Entity Framework 6 when trying to do StringConvert or other SQL functions.

//using System.Data.Objects.SqlClient;
using System.Data.Entity.SqlServer;

edited Mar 6, 2014 at 22:42

answered Mar 6, 2014 at 22:32

Greg

2,70523 silver badges28 bronze badges

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

1 Comment

Roger Johansson Over a year ago

As of EF 6.1 (blogs.msdn.com/b/adonet/archive/2014/03/17/…) you can now concat any primitive type.. e.g entity.MyInt + entity.MyStr + "hello" and it will work.

Cris · Accepted Answer · 2013-11-27 07:41:21Z

0

Use System.Data.Objects.SqlClient.SqlFunctions.StringConvert

_name =SqlFunctions.StringConvert((double)u.Code) + u.EmployeeName

answered Nov 27, 2013 at 7:41

Cris

13.4k5 gold badges37 silver badges51 bronze badges

Collectives™ on Stack Overflow

How to concatenate strings in Entity Framework Query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related