data type casting in Linq to Sql

Question

I have to convert data type from long to string in linq query join statement. e.g.

 from t1 in table1

 join t2 in table2 on new {t1.field1, t1.field2} equals new {t2.field1, t2.field2} 

 select new {t1.field1,t2.field1 all columns}

t1.field2 is of long type and t2.field2 is of string type. When I put ToString method it throws exception. Exception message

LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression.

Any help will be appreciated.

Habib · Accepted Answer · 2013-01-10 07:25:45Z

4

Use SqlFunctions.StringConvert

SqlFunctions.StringConvert((double) t1.field2)

answered Jan 10, 2013 at 7:25

Habib

224k30 gold badges420 silver badges446 bronze badges

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

4 Comments

Gyandeep Over a year ago

Thanks habib it is working fine but it is not returning the result while the SQL query is giving result on the same filter

Habib Over a year ago

@user1748975, you should check the generated SQL query against your LINQ expression and see what is going on

Gyandeep Over a year ago

(((STR( CAST( [t1].[field2] AS float))) = [t2].[field2]) OR ((STR( CAST( [t1].[field2] AS float)) IS NULL) AND ([t2].[field2] IS NULL))) it is adding this filter there. When I put the same filter in the SQL query it also doesn't give results

Habib Over a year ago

@user1748975, try StringConvert on the other field in your LINQ query

Collectives™ on Stack Overflow

data type casting in Linq to Sql

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