8,497
社区成员
发帖
与我相关
我的任务
分享
public List<TableName> GetInfo()
{
var info= from p in tbl_infos
where p.id=2
select p;
return p.ToList();
}
var localTable = (from objTableA in objDataContext.furniture_bargain_review.Where(objQueryWhere)
where objTableA.furniture_bargain_Id == bargainId
join objTableB in objDataContext.furniture_bargain on objTableA.furniture_bargain_Id equals objTableB.furniture_bargain_Id
select new
{
objTableA.furniture_bargain_review_Id,
objTableA.furniture_bargain_review_Date,
objTableB.furniture_bargain_Id,
objTableB.furniture_bargain_Name,
objTableA.furniture_bargain_review_Name,
objTableA.furniture_bargain_review_Email,
objTableA.furniture_bargain_review_Ip,
objTableA.furniture_bargain_review_Body
}).OrderByDescending(p => p.furniture_bargain_review_Date);