http://blogs.msdn.com/vbteam/archive/2008/01/08/converting-sql-to-linq-part-7-union-top-subqueries-bill-horst.aspxThis post assumes you’ve read the previous posts in this series: Converting SQL to LINQ, Part 1: The Basics Converting SQL to LINQ, Part 2: FROM and SELECT Converting SQL to LINQ, Part 3: DISTINCT, WHERE, ORDER BY and Operators Converting SQL to LINQ,en-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/vbteam/archive/2008/01/08/converting-sql-to-linq-part-7-union-top-subqueries-bill-horst.aspx#7032409Tue, 08 Jan 2008 23:40:40 GMT91d46819-8472-40ad-a661-2c78acb4018c:7032409Geek Lectures - Things geeks should know about » Blog Archive » Converting SQL to LINQ, Part 7: UNION, TOP, Subqueries (Bill Horst)<p>PingBack from <a rel="nofollow" target="_new" href="http://geeklectures.info/2008/01/08/converting-sql-to-linq-part-7-union-top-subqueries-bill-horst/">http://geeklectures.info/2008/01/08/converting-sql-to-linq-part-7-union-top-subqueries-bill-horst/</a></p> http://blogs.msdn.com/vbteam/archive/2008/01/08/converting-sql-to-linq-part-7-union-top-subqueries-bill-horst.aspx#7033218Wed, 09 Jan 2008 01:10:12 GMT91d46819-8472-40ad-a661-2c78acb4018c:7033218Jorge Serrano - MVP Visual Developer - Visual Basic<p>Si quieres aprender LINQ para Visual Basic 2008, quiz&#225;s te interesen los siguientes art&#237;culos que el</p> http://blogs.msdn.com/vbteam/archive/2008/01/08/converting-sql-to-linq-part-7-union-top-subqueries-bill-horst.aspx#7033220Wed, 09 Jan 2008 01:10:15 GMT91d46819-8472-40ad-a661-2c78acb4018c:7033220El blog de Jorge<p>Si quieres aprender LINQ para Visual Basic 2008, quiz&#225;s te interesen los siguientes art&#237;culos que el</p> http://blogs.msdn.com/vbteam/archive/2008/01/08/converting-sql-to-linq-part-7-union-top-subqueries-bill-horst.aspx#7036702Wed, 09 Jan 2008 08:25:51 GMT91d46819-8472-40ad-a661-2c78acb4018c:7036702Christopher Steen<p>ASP.NET Web Development Toolbox [Via: Chris Brandsma ] WPF WPF/Xaml Web News - 2008/01/08 [Via: rrelyea...</p> http://blogs.msdn.com/vbteam/archive/2008/01/08/converting-sql-to-linq-part-7-union-top-subqueries-bill-horst.aspx#7041656Wed, 09 Jan 2008 18:28:36 GMT91d46819-8472-40ad-a661-2c78acb4018c:7041656GMA Bill<p>Thank you for showing not only how to write a LINQ statement with a particular clause, but also the results. &nbsp;That helps with understanding what to expect and what it is doing.</p> http://blogs.msdn.com/vbteam/archive/2008/01/08/converting-sql-to-linq-part-7-union-top-subqueries-bill-horst.aspx#7042919Wed, 09 Jan 2008 20:08:34 GMT91d46819-8472-40ad-a661-2c78acb4018c:7042919Roger Jennings<p>Pingback from <a rel="nofollow" target="_new" href="http://oakleafblog.blogspot.com/2008/01/linq-and-entity-framework-posts-for.html">http://oakleafblog.blogspot.com/2008/01/linq-and-entity-framework-posts-for.html</a></p> http://blogs.msdn.com/vbteam/archive/2008/01/08/converting-sql-to-linq-part-7-union-top-subqueries-bill-horst.aspx#8557396Thu, 29 May 2008 10:50:22 GMT91d46819-8472-40ad-a661-2c78acb4018c:8557396The Visual Basic Team<p>ここでは、このシリーズの前の投稿をお読みになっていることを前提としています。 Converting SQL to LINQ, Part 1: The Basics ( 英語 ) Converting SQL</p> http://blogs.msdn.com/vbteam/archive/2008/01/08/converting-sql-to-linq-part-7-union-top-subqueries-bill-horst.aspx#9850917Tue, 28 Jul 2009 15:01:07 GMT91d46819-8472-40ad-a661-2c78acb4018c:9850917DoYouKnow.IN<p>Nice Articles..</p> <p>Is there any keyword for Bottom 10 records</p> http://blogs.msdn.com/vbteam/archive/2008/01/08/converting-sql-to-linq-part-7-union-top-subqueries-bill-horst.aspx#9851255Tue, 28 Jul 2009 21:50:01 GMT91d46819-8472-40ad-a661-2c78acb4018c:9851255Jonathan Aneja<p>The best thing to do would be to sort in the opposite direction and still use the Take operator:</p> <p>dim q = from row in db.customers order by row.companyid descending take 10</p> <p>Hope that helps!</p> <p>Jonathan</p>