how to use cast in

Posted by Oswaldlily under ASP.NET on 9/19/2011 | Points: 10 | Views : 1421 | Status : [Member] | Replies : 1
Select column1 ,column2 case when column3=''
then column1+ ':' + CAST(column2 as varchar(max))
else column2 end as description
from Tablename

How to change this query to linq?
Half of my linq query as follows..Struck in using cast
dim a= From r In objectname.Tablename Select r.column1, r.column2, r.column3 Where id= "E" (Here how to use cast)(This code in


Posted by: Ketvin on: 10/8/2011 [Member] Starter | Points: 25

I am facing same issue r u overcome the problem??

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response