{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 Evening l夕情丶 的问题《LINQ version of TOP PERCENT》','https://www.manongdao.com/q-1219297.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
Is there a way to perform a top (Take) linq query using percentage? The T-SQL would have been:
SELECT TOP 20 PERCENT ...
But LINQ seems to only want an int.
It seems that I would have to do a count and then a take. Any suggestions?
相关问题
- Check if tie in count of lists using linq
- Trouble with OR in Sharepoint CAML
- get key value pairs from xml using linq
- query and create objects with a one to many relati
- select column from dataset using LINQ
相关文章
- 想问问Linq中有没有根据条件选择要不要关联表。
- Why do I need a ToList() to avoid disposed context
- DateDiff in LINQ
- LINQ .Include() properties from sub-types in TPH i
- “Between” in Linq C# [duplicate]
- Can a method chain be called LINQ?
- Get grouped comma separated values with linq
- How does a LINQ expression know that Where() comes
I don't think there's anything built into LINQ to SQL. You could do it with a stored procedure. I don't like that much, unless you happen to be using a procedure anyway, but it's probably better than doing it with two separate queries.
You would have to perform the query twice, in essence. You would have to perform it once to get a count, and then again to figure out the percentage (because you will pass the number that corresponds to the count that will equal 20%).