双表联合查询

public IQueryable<ViewModel> List(string key = "", string page = "1", string pagesize = "5", string title = "")
{

int p = 1, size = 20;
int.TryParse(page, out p);//将string类型的p和SIZE转化INT类型
int.TryParse(pagesize, out size);
ViewBag.page = p;
ViewBag.size = size;
var query = from d in db.GetList()
join n in nf.GetList() on d.MFCCode equals n.Key
where d.MFCCode == key || n.PKey == key
orderby d.ATime descending
select new ViewModel()//抽取数据表的部分属性形成新的表
{
ID = d.ID,
Title = d.Title,
ATime = d.ATime,
Img = d.Img,
Img2 = d.Pic,
key = d.MFCCode,
intro = d.intro
};
var model = query.Skip((p - 1) * size).Take(size);//传递分页的数据
ViewBag.count = query.Count();
return model;
}

 

转载于:https://www.cnblogs.com/liangliping/p/9066228.html