SELECT
`Extent1`.`FavoriteCount`, 
`Extent1`.`ResId`, 
`Extent1`.`UseCount`, 
`Extent1`.`ShareCount`, 
`Extent1`.`PublishDate`, 
`Extent2`.`PasswordId`, 
`Extent1`.`ResName`, 
`Extent2`.`TerminalCode`, 
`Extent1`.`Keyword`, 
`Extent3`.`Description`, 
`Extent3`.`Author`, 
`Extent3`.`Column`
FROM `resources` AS `Extent1` 
INNER JOIN 
`specialresourcedatas` AS `Extent2` 
 ON `Extent1`.`ResId` = `Extent2`.`ResId` 
INNER JOIN 
`articles` AS `Extent3` 
 ON `Extent1`.`ResId` = `Extent3`.`ResId`
 WHERE `Extent2`.`TerminalCode` = @p__linq__0

SELECT
`Project1`.`FavoriteCount`, 
`Project1`.`ResId`, 
`Project1`.`UseCount`, 
`Project1`.`ShareCount`, 
`Project1`.`PublishDate`, 
`Project1`.`PasswordId`, 
`Project1`.`ResName`, 
`Project1`.`TerminalCode`, 
`Project1`.`Keyword`, 
`Project1`.`Description`, 
`Project1`.`Author`, 
`Project1`.`Column`
FROM (SELECT
`Extent1`.`ResId`, 
`Extent1`.`ResName`, 
`Extent1`.`PublishDate`, 
`Extent1`.`Keyword`, 
`Extent1`.`FavoriteCount`, 
`Extent1`.`ShareCount`, 
`Extent1`.`UseCount`, 
`Extent2`.`TerminalCode`, 
`Extent2`.`PasswordId`, 
`Extent3`.`Column`, 
`Extent3`.`Author`, 
`Extent3`.`Description`
FROM `resources` AS `Extent1` INNER JOIN `specialresourcedatas` AS `Extent2` ON `Extent1`.`ResId` = `Extent2`.`ResId` INNER JOIN `articles` AS `Extent3` ON `Extent1`.`ResId` = `Extent3`.`ResId`
 WHERE `Extent2`.`TerminalCode` = @p__linq__0) AS `Project1`
 ORDER BY 
`Project1`.`UseCount` DESC LIMIT 0,5

 1                 ArticleManager aMgr = new ArticleManager();
 2                 IQueryable<Resource> rRes = rMgr.LoadConditions(HttpContext.Current.Request.QueryString);//.Include(u => u.Article);
 3                 IQueryable<Article> articalRes = aMgr.LoadConditions(HttpContext.Current.Request.QueryString);
 4                 IQueryable<SpecialResourceData> srdRes=spdMgr.LoadConditions(HttpContext.Current.Request.QueryString);
 5                 //链接 终端表
 6                 var rsJsin = rRes.Join(srdRes, u => u.ResId, v => v.ResId, (u, v) => new { u.ResId, u.ResName, u.UseCount, u.FavoriteCount, u.ShareCount, u.PublishDate, u.Keyword, v.TerminalCode, v.PasswordId });
 7                 //链接文章表
 8                 var rs_aJoin = rsJsin.Join(articalRes, u => u.ResId, v => v.ResId, (u, v) => new { u.ResId, u.UseCount, u.FavoriteCount, u.ShareCount, u.PublishDate, u.PasswordId, u.ResName, u.TerminalCode,u.Keyword,v.Description, v.Author, v.Column });
 9                 //三项检索项
10                 string _SearchTerm = HttpContext.Current.Request.QueryString["SearchTerm"];
11                 if (!string.IsNullOrEmpty(_SearchTerm))
12                     rs_aJoin = rs_aJoin.Where(u => (u.Keyword.Contains(_SearchTerm) || u.ResName.Contains(_SearchTerm)) || u.Description.Contains(_SearchTerm));
13                 bool isRelation = false;
14                 IQueryable<ResourceCategory> rcRes =rcMgr.LoadConditions(HttpContext.Current.Request.QueryString,ref isRelation);
15                 IQueryable<ResourceCategoryRelation> rcrRes = rcrMgr.LoadConditions(HttpContext.Current.Request.QueryString, ref isRelation);
16                 if (isRelation)
17                 {
18                     var rrJoinTemp = rcRes.Join(rcrRes, u => u.ResCategoryId, v => v.ResCategoryId, (u, v) => new { u.CategoryOrder, u.Name, u.ResCategoryId, v.ResId });
19                     //连接 分类表
20                     rs_aJoin = rs_aJoin.Join(rrJoinTemp, u => u.ResId, v => v.ResId, (u, v) => u);//new { u.ResId, u.UseCount, u.FavoriteCount, u.PublishDate, u.ShareCount, u.PasswordId, u.ResName, u.TerminalCode, u.Author, u.Column, v.Name, v.ResCategoryId, v.CategoryOrder }
21                 }
22                var res=  rs_aJoin.OrderBy(u => u.UseCount).Skip(0)
23                         .Take(5);