Equivalent Linq Query for SQL Query?
-
Select Article_id, Article_Title, Case Article_Home_Display when 'Y' then 'Yes' Else 'No' End Article_Home_Display, Article_Type, Case Dflag when 'A' then 'Active' Else 'Not Active' End Status from Articles where co_id=" & companydetails.iCoId & " Order By Article_id Desc I Need Linq query for the above sql query. Thanks in advance.
Have A Nice Day! Murali.M Blog
-
Select Article_id, Article_Title, Case Article_Home_Display when 'Y' then 'Yes' Else 'No' End Article_Home_Display, Article_Type, Case Dflag when 'A' then 'Active' Else 'Not Active' End Status from Articles where co_id=" & companydetails.iCoId & " Order By Article_id Desc I Need Linq query for the above sql query. Thanks in advance.
Have A Nice Day! Murali.M Blog
-
Select Article_id, Article_Title, Case Article_Home_Display when 'Y' then 'Yes' Else 'No' End Article_Home_Display, Article_Type, Case Dflag when 'A' then 'Active' Else 'Not Active' End Status from Articles where co_id=" & companydetails.iCoId & " Order By Article_id Desc I Need Linq query for the above sql query. Thanks in advance.
Have A Nice Day! Murali.M Blog
You can convert it here : http://www.linqpad.net/[^] http://www.sqltolinq.com/[^]
So much complexity in software comes from trying to make one thing do two things. Sibeesh