我如何在linq中编写此查询 [英] how i write this query in linq

问题描述

我有查询要显示记录到网格视图为此目的我有这样的SQL查询，如

i have query like to display record to grid view for this purpose i have this sql query like

SELECT  tbl_Post_History.Title, CAST (tbl_User_master.First_name+' '+tbl_User_master.Last_name AS VARCHAR(50)) AS [Publisher], tbl_Post_History.Created_datetime, tbl_History_Files.File_name,
        tbl_History_Files.File_ext, tbl_History_Files.File_Size, tbl_Post_History.Category_id
FROM    tbl_History_Files INNER JOIN
        tbl_Post_History ON tbl_History_Files.Post_History_id = tbl_Post_History.Id INNER JOIN
        tbl_User_master ON tbl_Post_History.User_id = tbl_User_master.Id AND tbl_Post_History.ToUser_id = tbl_User_master.Id
WHERE(tbl_Post_History.User_id = '1' OR tbl_Post_History.ToUser_id = '1')

如何使用包含此查询的此强制转换函数在linq中编写此查询。



请帮助我..

how i write this query in linq using this cast function that i include this query.

please help me..

推荐答案

使用像 LINQPad [ ^ ]

这篇关于我如何在linq中编写此查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！