怎样以下SQL语句转为LINQ查询？
自己转换了一个，但是得不到期望的结果...
SQL语句：

select top 5authorName,count(*)
from dbo.authors
group by authorName
having authorName like '赵%'
order by   count(*) desc 

自己转换的LINQ查询：

  V1DataContext DB = new V1DataContext();
                    var queryName = (from A in DB.authors
                                     group A by new
                                     {
                                         authorName = A.authorName
                                     } into grA
                                     select new
                                     {
                                         authorName = grA.Key.authorName,
                                         Quantity = grA.Count()
                                     } into orderbygrA
                                     where  orderbygrA.authorName.StartsWith("张")
                                     orderby orderbygrA.Quantity descending
                                     select orderbygrA.authorName).Distinct().Take(7);

[解决办法]
给你推荐个Linq工具 LinqPad ，可以把linq查询的语句转成sql
[解决办法]

 
 
var query=(from A in DB.authors.Where(b=>b.authorName.StartsWith("张"))
          group A by A.authorName into g
          let c=g.Count()
          orderby c desending
          select new {authorName=g.Key,cnt=c}).Take(5);